Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision (____ digits) to whatever format is displayed in that cell, including the number of decimal places.
A) 5
B) 9
C) 15
D) 21

Question

Quizplus · Accepted Answer

The Set precision as displayed workbook option permanently changes the values in all workbook cells to display the number of decimal places currently shown in each cell. Since the maximum number of digits that can be displayed after the decimal point is 15 in Excel, the best choice is option C. Options A, B, and D are too low or too high for the number of decimal places that can be displayed in Excel.

Selecting the Set Precision as Displayed Workbook Option Permanently Changes