When a cell is formatted in Currency,a zero value will display as ____.
A) #DIV/0!
B) $0.00
C) 0
D) $ -

Question

Quizplus · Accepted Answer

When a cell is formatted in Currency, a zero value will display as $0.00. This is the standard format for displaying a zero value in currency format. Options A, C, and D are incorrect as #DIV/0! is an error message for a divide by zero error, 0 is a plain numeric value, and $- is not a valid currency format.

When a Cell Is Formatted in Currency,a Zero Value Will