Multiple Choice
If a cell containing =B$14 is copied and pasted three columns over and two rows down, what would the resultant cell reference become?
A) E$14
B) $E$14
C) B16
D) B$16
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q21: This is a valid way to use
Q26: The MIN and MAX functions can be
Q28: In a lookup table, the number of
Q28: Which Excel function changes the value to
Q32: Which of the following is not an
Q37: When working with dates, Excel actually assigns
Q45: Which status bar statistic can you not
Q75: Which keyboard shortcut toggles through the types
Q78: A good practice when entering function names
Q97: What punctuation is used to separate the