Read the spreadsheet formula below, then answer the question.cell B5=A5*2If this formula is filled into cell B6, what will the new formula be?

When a formula is filled down one row, relative cell references move down one row too. The reference A5 changes to A6, while the number 2 stays the same. The new formula is =A6*2, which is choice D.

AI-written and checked against the verified answer.