Home / Microsoft Excel / Question
MCQ
Which error appears when a formula uses the wrong data type?
Microsoft Excel
A #VALUE!
B #DIV/0!
C #NAME?
D #N/A
Explanation

#VALUE! indicates a type mismatch.

Related MCQs

Which function returns TRUE if all conditions are true?
Microsoft Excel View
Which key toggles between relative and absolute cell references in a formula?
Microsoft Excel View
Which function joins text with a delimiter?
Microsoft Excel View
Which function counts cells that meet a specified condition?
Microsoft Excel View
Which tab contains Text to Columns?
Microsoft Excel View
Which function returns a list of unique values from a range?
Microsoft Excel View