Microsoft Excel 2021365 - Beginner to Advanced - Error Handling Functions

The video tutorial covers error handling in Excel using IFERROR and IFNA functions. It demonstrates constructing a VLOOKUP formula to retrieve part descriptions and unit prices from a parts catalog. The tutorial explains how to handle NA errors using IFNA and other errors using IFERROR, making the worksheet more user-friendly by replacing error messages with meaningful text. The video concludes with tips on aligning and finalizing the worksheet for better presentation.

What is the primary purpose of the IFERROR function in Excel?

• To handle only NA errors

• To handle all types of errors

• To format cells

• To sort data

In the context of VLOOKUP, what does an NA error typically indicate?

• The worksheet is locked

• The data is corrupted

• The formula is incorrect

• The part number is not found in the catalogue

How can you make an NA error message more meaningful in Excel?

• By deleting the error

• By using IFNA to display a custom message

• By leaving it as NA

• By changing the cell color

What should you enclose text in when using it in a formula?

• Asterisks

• Brackets

• Quote marks

• Parentheses

Which column number is used to return the unit price in the VLOOKUP example?

• Column #1

• Column #4

• Column #2

• Column #3

What is the difference between IFERROR and IFNA?

• IFERROR handles only NA errors, IFNA handles all errors

• IFERROR handles all errors, IFNA handles only NA errors

• Both handle all errors

• Both handle only NA errors

What alignment is suggested for better readability of the worksheet?

• Center and right

• Center and bottom

• Top and left

• Right and bottom