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 would you add animations to text, pictures, shapes, and more in your presentation? ...
You can set your work week to be: ...
Which function is used to trap and handle #N/A errors in Excel? ...
Concatenation of text can be done in Excel using ...
In Microsoft Word, Ruler is present ________the Ribbon. ...
To open a new database in MS Access, press ...
How many users can open an Excel file at the same time? ...
In MS Access, what query do you use to answer the question “what is the average salary of empl...
What is the keyboard shortcut to stop the slideshow of a PowerPoint presentation? ...