Microsoft Excel 2021365 - Beginner to Advanced - Error Handling Functions
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
7 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What are the two main error handling functions available in Excel?
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
Explain the difference between IFERROR and IFNA functions in Excel.
Evaluate responses using AI:
OFF
3.
OPEN ENDED QUESTION
3 mins • 1 pt
Describe the process of using VLOOKUP to find part descriptions and unit prices.
Evaluate responses using AI:
OFF
4.
OPEN ENDED QUESTION
3 mins • 1 pt
What should you do if you encounter NA errors in your VLOOKUP results?
Evaluate responses using AI:
OFF
5.
OPEN ENDED QUESTION
3 mins • 1 pt
How can you make NA errors more meaningful in your Excel worksheet?
Evaluate responses using AI:
OFF
6.
OPEN ENDED QUESTION
3 mins • 1 pt
What is the purpose of wrapping a VLOOKUP formula in an error handling formula?
Evaluate responses using AI:
OFF
7.
OPEN ENDED QUESTION
3 mins • 1 pt
How do you specify what to display if a part number is not found using IFNA?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
