Solved

If the Cell Reference $A5 in a Formula Is Copied

Question 81

Multiple Choice

If the cell reference $A5 in a formula is copied and pasted over two columns and down two rows from its original cell, what the cell reference become in the new cell.


A) $A5
B) $A7
C) $C5
D) $C7

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q76: What is the default method of referencing

Q77: You could use both A3>b9 or B9<A3

Q78: A good practice when entering function names

Q79: The inputs in a function are specified

Q80: Match the following terms with their description:<br>

Q82: The _ function finds the smallest value

Q83: What does Excel use to indicate optional

Q84: FV is a required argument in the

Q85: A lookup table should contain at least

Q86: The PMT function uses three required arguments