Microsoft Excel 2021365 - Beginner to Advanced - Error Handling with IFERROR and IFNA

The video tutorial explains how to handle errors in spreadsheets using IFNA and IFERROR functions. It starts with an example of a bonus spreadsheet where NA errors occur due to unaccounted job ratings. The tutorial demonstrates how to use IFNA to replace NA errors with meaningful text like 'no bonus'. It then introduces IFERROR, which can handle all types of errors, providing guidance for incorrect inputs. The tutorial emphasizes the importance of error handling for clarity and consistency in spreadsheets.

What is the main purpose of using IF statements in spreadsheets?

• To perform complex calculations

• To handle errors and provide meaningful outputs

• To format cells

• To sort data

In the bonus spreadsheet example, what error appears when the job rating is below 4?

• NA error

• Name error

• Value error

• Division error

What does the IFNA function specifically handle?

• All types of errors

• Value errors

• NA errors

• Division errors

What is the second argument in the IFNA function used for?

• To calculate the bonus

• To specify the error type

• To sort the data

• To define the value if NA is found

Which function can handle all types of errors in a spreadsheet?

• SUM

• IFNA

• IFS

• IFERROR

In the IFERROR example, what message is displayed if an invalid day number is entered?

• Invalid input

• Day not found

• Error in calculation

• Please enter a number between 1 and 7

What is the key takeaway regarding the use of IFNA and IFERROR functions?

• Both functions are used for sorting data

• IFNA is for NA errors, IFERROR is for all errors

• Both functions are used for formatting cells

• IFNA can handle all errors, IFERROR is specific to NA errors