Case AC 3-2 Eric is learning how to create calculated fields. Eric is typing one of his expressions and notices that Excel only displays the first 20 characters. What can Eric do to display the entire field?
A) Click the empty Field box in the design grid, and then click Zoom on the shortcut menu.
B) Click the empty Field box in the design grid, and then click Show All on the Ribbon.
C) Either a. or b.
D) Neither a. nor b.

Question

Quizplus · Accepted Answer

To display the entire field when Excel shows only the first 20 characters, Eric can click the empty Field box in the design grid and then click Zoom on the shortcut menu. This action enlarges the view so he can see the entire expression. Option B is incorrect because there is no "Show All" option on the Ribbon for this purpose in Excel.

Case AC 3-2 Eric Is Learning How to Create Calculated