HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

Hi,

It's actually Avagadro's constant and you don't need to know that to work
out moles but it would be well to understand it.

I'm aware we are stepping over the boundary here from excel to chemistry and
I'm no expert in either but here we go.

Avagadro's constant is a number that is the amount of units of a thing that
are in 1 mole of that thing and I use 'thing' because there is no standard
unit for it.

The constant is actually 6.022 *10^23 (which is a very big number). So 1
mole of computers is 6.022 * 10^23 computers, 1 mole of Excel MVP's is 6.022
* 10^23 MVP's and for 1 mole of water we do the same sum.

So to get back to your question 1000gms of water is roughly 55.52 moles so
multiply that by Avagadro's constant and that's how many molecules of H2O are
in 1000gms of water.


Mike

"Dave" wrote:

OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"


Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave wrote:

OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

Considering the quality of the ability, or lack thereof, of today's college
graduates to even formulate a proper sentence, I think chances are probably
about 50/50 that he was taught avagardos constant instead of Avagadro's
Constant.

Can't put all the blame on the student when the faculty and administrators
keep lowering standards to make sure no child suffers the terrible,
life-long-lasting stigma of actually being held back a year until they learn
what everyone else did.

"Gord Dibben" wrote:

The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"


Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave wrote:

OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

Unfortunately, I think you may be right Jerry

I am positive that not all the posters with the spelling and grammatical
mistakes are high school or grade school drop-outs.


Gord

On Sat, 10 May 2008 20:01:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

Considering the quality of the ability, or lack thereof, of today's college
graduates to even formulate a proper sentence, I think chances are probably
about 50/50 that he was taught avagardos constant instead of Avagadro's
Constant.

Can't put all the blame on the student when the faculty and administrators
keep lowering standards to make sure no child suffers the terrible,
life-long-lasting stigma of actually being held back a year until they learn
what everyone else did.

"Gord Dibben" wrote:

The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"


Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave wrote:

OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)


Mike


"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca wrote:
The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"

Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave wrote:
OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)

Mike

"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

But it's Avogadro.

Ken Johnson

Damn! Good thing I didn't choose kimystery as a major! Thanks for the
correction to the correction, seriously.

How odd that I should have forgotten how to spell it after only about 40
years of never so much as using it in a sentence or uttering it in
conversation.

"Ken Johnson" wrote:

On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca wrote:
The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"

Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave wrote:
OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)

Mike

"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

But it's Avogadro.

Ken Johnson

Ken,

Interesting point. There are probably as many references to Avagadro as
Avogadro on the net and in textbooks but what we can agree on completely is
that it isn't avagardo and a man of such eminence; at the very least,
deserves his name to be spelt with a capital A.

Mike


"Ken Johnson" wrote:

On May 11, 10:28 am, Gord Dibben <gorddibbATshawDOTca wrote:
The proper spelling is Avagadro's Constant and can be found by searching
the 'net.

I sincerely hope your instructor did not teach you "avagardos constant"

Gord Dibben MS Excel MVP

On Sat, 10 May 2008 14:25:00 -0700, Dave wrote:
OK I understand that but my Chem tutor keeps rattling on about avagardos
constant and I thought i need that to work out moles

"Mike H" wrote:

Hi,

So it's homework time is it?

Firstly you can't do it solely in Excel without reference to a table of
atomic weights and from that you should discover the following:-

Hydrogen atomic weight = 1.0079
Oxygen atomic weight = 15.994
Put these 2 values in A1(hydrogen) and A2(oxygen)
Now work out number of moles with this formula
=1000/(A1*2+A2)

To make it more flexible you could put the 1000gms in a cell and reference
it in the formula
=A3/(A1*2+A2)

Mike

"Dave" wrote:

HELP!

How in Excel do I work out how many moles are in 1kg of water. Desperately
need an answer for Monday morning.

:)

But it's Avogadro.

Ken Johnson