function symbols

  • Thread starter Thread starter Toni
  • Start date Start date
Toni,

There isn't a symbol. Are you thinking of the RATE function?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
one of my classes is on excel and we had a test with one
question stating:
"22. Assume you are creating a worksheet to calculate
projected earnings. You expect to create and copy several
formulas using the inflation rate, which is found in cell
C6. Since the inflation rate will always be in cell C6,
the formulas referencing the cell should show:
a)C6
b)$C$6
c)&C&6
d)@C@6
And I have search the book and all the excel help but
found nothing! Do you know the answer?
 
The answer is b.




one of my classes is on excel and we had a test with one
question stating:
"22. Assume you are creating a worksheet to calculate
projected earnings. You expect to create and copy several
formulas using the inflation rate, which is found in cell
C6. Since the inflation rate will always be in cell C6,
the formulas referencing the cell should show:
a)C6
b)$C$6
c)&C&6
d)@C@6
And I have search the book and all the excel help but
found nothing! Do you know the answer?
Click to expand...
 
The answer is "C" but has nothing whatsoever to do with inflation.
The use of the dollar signs in the cell reference causes it to be
"absolute", meaning that it will not change when you copy/paste
the cell or when you use the Fill edit tools. See
http://www.cpearson.com/excel/relative.htm for a brief discussion
of relative and absolute cell references.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Or the test is incorrect since the correct answer is obviously <grin>
=INDIRECT("C6")
if you want to take always in cell C6 literally.
 
Back
Top