Home / Microsoft Excel / Question
MCQ
Which function returns a custom value when a formula produces an error?
Microsoft Excel
A IFERROR
B IFNA
C IF
D ERROR
Explanation

IFERROR replaces errors with a given value.

Related MCQs

Which function splits text into separate parts?
Microsoft Excel View
What does the range A1:A10 refer to?
Microsoft Excel View
Which function returns TRUE if all conditions are true?
Microsoft Excel View
Which shortcut fills the selection to the right?
Microsoft Excel View
Which function returns a match using both vertical and horizontal lookup?
Microsoft Excel View
What is the formula bar in Excel?
Microsoft Excel View