Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function?
A)Right-click on the cell containing the range and select the Format Cells option from the list
B)Position the cursor on the cell where the formula should appear
C)Drag the cell and place it on top of the reference cell
D)Select the range again and drag a handle on the border of the shading

Question

Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function? ​
A)Right-click on the cell containing the range and select the Format Cells option from the list
B)Position the cursor on the cell where the formula should appear
C)Drag the cell and place it on top of the reference cell
D)Select the range again and drag a handle on the border of the shading

Quizplus · Accepted Answer

To edit the range reference in a formula, you should select the range again and adjust it by dragging a handle on the border of the shading that appears around the selected range. This allows you to visually adjust the cells the formula references.

Which of the Following Step Should Be Followed to Edit