Question

Read the spreadsheet formula below, then answer the question.

cell B5=A5*2

If this formula is filled into cell B6, what will the new formula be?

a.) =B5*B5
b.) =B5*2
c.) =A5*B6
d.) =A6*2

Answer 1

Answer: The correct answer is choice d - =A6 * 2

Explanation: The cell formula in spreadsheets are relative, so when you fill the formula from one row to the row below, it will also change the cells that it is pointing to in the formula down one row. In this case, when the formula B5 = A5 * 2 is filled to cell B6, then it will change to A6 * 2.

Answer 2

Answer:

D

Explanation:

=A6*2