Question

If a formula is entered in cell F3 to multiply the values in cells D3 and E3, Excel recalculates the product whenever new values are entered into those cells and displays the result in cell F3.

Answer 1

Answer:

Click cell C3.

Click the Copy button in the Home tab of the Ribbon.

Highlight the range C4:C11.

Click the Paste button in the Home tab of the Ribbon.

Double click cell C6. Notice that the cell reference in the formula is automatically changed to D6.

Press the ENTER key.