Question

14. What will be the formula in the C6 cell if you want to copy it in the cells justbelow?

Answer 1

Answer:

Press F2 (or double-click the cell) to enter the editing mode. Select the formula in the cell using the mouse, and press Ctrl + C to copy it. Select the destination cell, and press Ctl+V. This will paste the formula exactly, without changing the cell references, because the formula was copied as text.

Explanation:

Hope it helps.