Which function is used to trap and handle #N/A errors in ...
Which function is used to trap and handle #N/A errors in Excel?
IFERROR()
ERROR()
IFNA()
IFERRORNA()
Correct answer is C
The IFNA() function is used to trap and handle #N/A errors.
Syntax:
=IFNA (value, value_if_na)
Example:
=IFNA(VLOOKUP(A5,xtable,2,0),"Error: Not found")
Which of the following tab is used to add the document citation in Microsoft Word? ...
A composite key in Access is ...
You can convert existing excel worksheet data and charts to a HTML document by using ...
What is the extension of files created in Microsoft Word 97- 2003 ...
What is the correct syntax of IF() function in Excel? ...
You can use the formula palette in Excel to ...
Which of the following is a type of checkbox available in MS Word? ...
To undo the last changes in MS Word, press ________ ...
What is the default font used in Microsoft Word 2016 document? ...