Question

question 28
2 pts
to ensure that the row number is not incremented while a formula is copied down a spreadsheet while allowing column letters to be incremented as the formula is copied across the spreadsheet, the user would enter which of the following?
○ =a1
○ =$a1
● =a$1
○ =$a$1

Explanation:

In spreadsheet cell referencing, a dollar sign $ locks the part of the reference it precedes. To keep the row number fixed (not incremented when copying down a column) while letting the column letter increment when copying across rows, we lock only the row number.

• =A1 is a relative reference: both column and row change when copied.
• =$A1 locks the column A, so column won't increment when copying across.
• =A$1 locks the row 1, so row number won't increment when copying down, while column letter will increment when copying across.
• =$A$1 is an absolute reference: neither column nor row changes when copied.

Answer:

C. =A$1