Before Barry inserts new formulas in the range A5:F5, he wants to clear the cell contents. How can he do so?
A) Drag the fill handle from cell A5 to cell F5.
B) Select the range and then press DELETE.
C) Select the range and then click the Clear Formats button.
D) Select the range and then click Clear on the AutoFill Options menu.

Question

Quizplus · Accepted Answer

Selecting the range and pressing DELETE will clear the cell contents, as desired. Dragging the fill handle or clicking the Clear Formats button will not achieve the desired result. Choosing Clear on the AutoFill Options menu will only clear the cell contents if the cells were populated via the AutoFill feature.

Before Barry Inserts New Formulas in the Range A5:F5, He