Which of the following is not an Error Value?
a #DIV/0
b *REF!
c #NUM!
Answers
Answered by
2
Explanation:
a) Microsoft Excel shows the #DIV/0! error when a number is divided by zero (0). It happens when you enter a simple formula like =5/0, or when a formula refers to a cell that has 0 or is blank
b) The #REF! error shows when a formula refers to a cell that's not valid . This happens most often when cells that were referenced by formulas get deleted, or pasted over.
c) Excel shows this error when a formula or function contains numeric values that aren't valid. This often happens when you've entered a numeric value using a data type or a number format that's not supported in the argument section of the formula.
Therefore, correct answer is c)
Thank you bro
Have a good day
Similar questions