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")
Which of the following is a type of Page Orientation? ...
How many users can open an Excel file at the same time? ...
Cascade update option in Access ...
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) ...
We can request a receipt to show an email has been read by: ...
What is the keyboard shortcut to view formulas instead of values in MS Excel? ...
In an Excel worksheet, you can select ...
Which key stroke is used to move the active cell to the right, in an Access table ? ...