Rajiv has been working on a file containing numerical data up to three decimal places. He changes the number format in cell B1 from Accounting to Currency format and reduces the number of decimal places by one. The value in the cell was originally $115.34. The new value displayed after the format change Rajiv has made will be _____.
A)115.34
B)$115.34
C)#115.34

Question

Quizplus · Accepted Answer

Changing the number format from Accounting to Currency and reducing the decimal places does not alter the numerical value but changes its display format. The value remains $115.34, but is displayed with the Currency format.

Rajiv Has Been Working on a File Containing Numerical Data