Naomi Has a Spreadsheet Set Up Listing the Different Members

Multiple Choice

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.