Which of the following is a difference between relative addressing and absolute addressing when using cell formulas in Excel?
A) A relative address uses a dollar sign before either the row or column label; an absolute address uses the ampersand symbol before either the row or column label.
B) A relative address uses a dollar sign before either the row or column label; an absolute address uses just the row and column label in the cell reference.
C) A relative address uses just the row and column label in the cell reference; an absolute address uses a dollar sign before either the row or column label.
D) A relative address uses only the column label in the cell reference; an absolute address uses the row.
Correct Answer:
Verified
Q11: If, in the spreadsheet, cells B9 and
Q12: Which of the following is a differentiation
Q13: Using a $ sign before a column
Q14: The Excel function of is used to
Q15: To find the average of the total
Q17: Which of the following symbols is used
Q18: If purchase quantities of 25 units or
Q19: Trace the process of copying and pasting
Q20: measures the worth of a stream of
Q21: What is the Insert function in Excel?
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