Question

when the active cell contains a formula, dragging the fill handle causes excel to select one: a. copy the value produced by the formula into the destination cells. b. generate an error message. c. copy the formula and change the cell references relative to each destination location. d. copy the formula but keep the cell references exactly the same.

Explanation:

In Excel, when you drag the fill - handle on a cell with a formula, it copies the formula and adjusts the cell references relative to the new destination location. This is a fundamental feature for quickly applying formulas across a range of cells. For example, if in cell A1 you have a formula like =B1 + C1 and you drag the fill - handle down to cell A2, the formula in A2 will automatically adjust to =B2 + C2.

Answer:

C. copy the formula and change the cell references relative to each destination location