After beginning a formula, what can you do instead of typing the syntax of a 3-D reference?
A) Click a sheet tab, click a cell range, and then press ENTER.
B) Copy a sheet tab and then press CTRL+V to paste it in the formula.
C) Use the fill handle to select the external range.
D) Click the Enter button on the formula bar, click a sheet tab, and then click a cell range.

Question

Quizplus · Accepted Answer

By clicking a sheet tab and then a cell range, Excel automatically adds the syntax of a 3-D reference to the formula. This is a faster and more efficient method than manually typing out the syntax.

After Beginning a Formula, What Can You Do Instead of Typing