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

B. Column B and Row 2

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.

the answer would be d. online forums.

hope it