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?
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 "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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
