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 document settings can be changed from Home tab in Microsoft Word? ...
In Access, which operation copies a backup file from the storage medium back onto the computer? ...
How can you tell the email that you have read from the email that you have not read? ...
You can convert existing excel worksheet data and charts to a HTML document by using ...
To send a business letter to a group of contacts, you should: ...
Which criteria do not return the position "Officer" as a match in MS Access? ...
By using the ___, we can see all slides at once in PowerPoint. ...
Which of the following is NOT present in MS Word? ...
What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel? ...