Naomi has a spreadsheet set up listing the different members of the Art Museum, and the dues that they have paid. Please answer the two questions below.
-In cell B1, Naomi has a formula calculating the total dues the member has paid over the past five years. She wants to copy this formula down the column and wants the cell references to change to accommodate the new location. In this case, the cell reference is ____.
A) relative
B) absolute
C) either a. or b.
D) neither a. nor b.

Question

Quizplus · Accepted Answer

Relative cell references change when a formula is copied to another cell, which is what Naomi needs for her spreadsheet to correctly calculate the total dues for each member as she copies the formula down the column.

Naomi Has a Spreadsheet Set Up Listing the Different Members