Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

A. ERROR
B. #ERROR
C. IFERROR
D. #IFERROR

Answer: C

Computer Science & Information Technology

You might also like to view...

The three types of selection statements are:

a) If…Then, For…Next and Select…Case b) If…Then, For…Next and Select…Case c) If…Then, If…Then…Else and While d) If…Then, If…Then…Else and Select…Case

View
Computer Science & Information Technology

One way to access the AVERAGE, MAX and MIN functions is to select the ____ category of the Insert Function button on the Formulas tab

A. Calculations B. AutoSum C. Statistical D. Tools

View
Computer Science & Information Technology

Describe a RAID.

What will be an ideal response?

View
Computer Science & Information Technology

Nested lists can be displayed in a(n) _____ style through the use of contextual selectors.?

A. ?embedded B. ?outline C. ?hierarchy D. ?tree

View
Computer Science & Information Technology