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 chart type is used to show trends over time and categories in Excel? ...
Which function is used to create a Date with year, month, and day in Excel? ...
Changing the appearance of a Microsoft Word document is called ...
What is the file extension of a PowerPoint file? ...
In an Excel worksheet, you can select ...
You can use the formula palette in Excel to ...
In MS Word, Ctrl+S is used to ________ ...
In Excel, hyperlinks can be ...
Which option is used to hide/show the Headings in MS Excel? ...