Which function is used to trap and handle errors in Excel...
Which function is used to trap and handle errors in Excel?
IFERROR()
ERROR()
IFNA()
IFTRAP()
IFERRORTHENTRAP()
Correct answer is A
The IFERROR() function is used to trap and handle errors.
Syntax:
=IFERROR (value, value_if_error)
Example:
=IFERROR (A2/C2,"Please enter a value in C2")
How many worksheets can a workbook have? ...
How can you quickly reinstate a deleted footer placeholder in PowerPoint master view? ...
The fill function can be ____ to complete formulas in a range. ...
Superscript, subscript, outline, emboss, engrave are known as ...
A composite key in Access is ...
You can set your work week to be: ...
Paragraph group is present under which tab in Microsoft Word? ...
What is the extension of files created in Microsoft Word 97- 2003 ...
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________ ...