Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
I have a test on EXCEL tomorrow...?
Test on Excel, and looking at the practice test I can't get a few questions, and understand why it works out that way, they are below:
10) In cell K4, I type =L10 I then copy K4 to L6. What would the contents
of L6 be?
A) =N12 B) =M12 C) =M10 D) =L12 E)correct answer not listed
11) In cell K13, I type =K$18 I then copy K13 to L16.
What would the contents of L16 be?
A)=K$18 B)=K$21 C) =L$18 D)=L$21 E)correct answer not listed
12) In cell, V8 I type =$U$17 I then copy V8 to X10.
What would the contents of X10 be?
A) =$U$17 B)=$U$19 C) =$W$17 D)=$W$9 E)correct answer not listed
13) In cell F16, I type =$E16 I then copy F16 to E15.
What would be the contents of E15?
A) =$E16 B) =$D15 C) = $D16 D) = $E15
The answers, in order are:
B, C, A, D.
For some reason I have no idea why this works out, can someone explain it to me...Thanks!
2 Answers
- braydenLv 71 decade agoFavorite Answer
10) K4 is referencing the column immediately to its right at Cell 10. You then copied this to L4. Excel makes its copies in direct order of what you did before. So in this case, L4 will have to reference the column directly to its right (in this case M) just like K4 did originally. The reason it's M12, not M10, is because you moved down two slots from K4 to L6. In other words, if you'd copied K4 contents to L4, it'd have been M10. Etc.
11) The $ is used for telling excel that you always want to use what follows. so =K$18 means to tell excel to always use 18 in the cell. And in your case the letter simply signifies the column you're in.
12) Same explanation for $ as used in 11 above. The $ tells excel to always use U and always use 16
13) Same explanation for $ again.
- CozmosisLv 71 decade ago
These sites explain Relative vs. Absolute cell references
Using Absolute and Relative Formula References
http://www.mrexcel.com/articles/relative-and-absol...
Relative And Absolute References In Formulas
http://www.cpearson.com/excel/relative.aspx
Relative vs. Absolute References in Formulas
