20.2k views
3 votes
12. Which column and row references are updated when you copy the formula: =$A$9-B2? *

A. Row 9 and 2
B. Column B and Row 2
C. Column A and Row 9
D. Column A and B

2 Answers

4 votes
B. Column A and Row 9
User Jjnebeker
by
6.3k points
1 vote

Answer: B. Column B and Row 2

Step-by-step explanation:

If you are using a formula like this =$A$9-B2, you maybe are working on a spreadsheet like Microsoft Excel.

In a spreadsheet, the symbol $ tells the program we don't want to update a column or a row reference when we copy a formula. For example, $A means that column A won't be updated. And $9 means that row 9 won't be updated when we copy a formula.

In our formula, we can see that column A and row 9 have the symbol $, then $A$9 won't be updated.

but, what about B2? Column B and row 2 don't have the symbol $, then we can conclude that they will be updated when we copy the formula =$A$9-B2.

User Damien Ayers
by
7.3k points