Question

When a formatted number does not fit within a cell, it displays

_________.

a. #### b. #DIV/O c. #DIV/@ d. None of these​

Answer 1

Answer:

d.none of these

hope it helped

Answer 2

Answer:

When a formatted number does not fit within a cell, it displays #### [ OPTION A]

Explanation:

• #### = If a formatted number does not fit within a cell it shows #####. Also, if an unformatted number does not fit, it will display the number in scientific format. also, it shows when MS Excel cannot able to recognize the formula entered.
• #DIV/O means in MS Excel shows the #DIV/0! error when a number is divided by zero (0). It happens when you enter a simple formula like =15/0, or when a formula refers to a cell that has 0.

Hence, When a formatted number does not fit within a cell, it displays #### [ OPTION A]

#SPJ3