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:
Verified
Q6: If a cell contains =$N$21 and two
Q7: Functions can be selected by using the
Q8: What describes a function's purpose?
A)Arguments
B)Name
C)Category
D)Variables
Q9: How many functions does Excel provide?
A)Over 40
B)Over
Q10: If a cell containing =B$14 is copy
Q12: Which keyboard shortcut toggles through the types
Q13: What punctuation is used to separate the
Q14: What does Excel use to indicate optional
Q15: What type of cell reference should be
Q16: What is not a direct option on
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents