Excel Test for IF, IFS & IFERROR functions

Test your knowledge of the IF, IFS, and IFERROR functions in Excel with this engaging quiz. Each question presents a real-life situation where you must choose the correct answer from four options. You'll practice:

These questions will help you understand how to use these powerful functions efficiently. At the end, you'll receive feedback on your performance, highlighting areas for improvement.

Challenge yourself and learn how to use IF, IFS, and IFERROR confidently in various situations with this test. Are you ready to put your skills to the test?

 

Start

 

 

1.

Question

Which logical sign must be used to check if the invoice amount differs from the amount collected?

 

 

=B2>=C2

=B2==C2

=B2<=C2

=B2<>C2

=B2=C2

Question 1 of 7

2.

Question

How to fill in the blanks to display the message 'Error' when the values between columns B and C are not the same? If the values are equal, let the cells empty

 

=IF(B2<>C2,'''',''Error'')

=IF(B2<=C2,'''',''Error'')

=IF(B2=C2,''Error'','''')

=IF(B2<>C2,''Error'','''')

Question 2 of 7

3.

Question

Now, instead of 'Error', you want to display the gap between the 2 cells. How do you write the IF function

 

=SI(B2=C2,C2-B2,'''')

=SI(B2<>C2,B2-C2,'''')

=SI(B2=C2,B2-C2,'''')

=SI(B2<>C2,C2-B2,'''')

Question 3 of 7

4.

Question

How many conditions can you write in a IFS function?

=IFS(Condition 1, Result1, Condition 2, Result 2, ....)

 

 

 

100

10

50

200

127

256

Question 4 of 7

5.

Question

How to write the last condition of the IFS function to specify that this last value will be applied if the other conditions are not TRUE

 

 

 

 

=IFS(B2="Bronze",5%,B2="Silver",10%,NOT,15%)

=IFS(B2="Bronze",5%,B2="Silver",10%,FALSE,15%)

=IFS(B2="Bronze",5%,B2="Silver",10%,TRUE,15%)

=IFS(B2="Bronze",5%,B2="Silver",10%,LIKE,15%)

Question 5 of 7

6.

Question

Which function replaces any error in a worksheet by a custom text? Here for instance, each error is replaced by a dash

 

 

ISERR

IFERROR

IFERR

ISBLANK

Question 6 of 7

7.

Question

How do you write the IFERROR function to customize the result when there is an error?

 

=IFERROR({{{A2|''-''|ISERR()}}};{{{''-''|A2|ISERR()}}})

=IFERROR({{{A2|''-''|ISERR()}}};{{{''-''|A2|ISERR()}}})

Question 7 of 7

 Loading...

 

Related Exercises

• Training Logical Test – Beginner Level
• Training Logical Test – Advanced Level
• Logical Test – AND and OR functions

Excel-Tutorial.com, your training partner.

The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you're a beginner or an advanced user, our resources are designed to build your skills step by step.

Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced data analysis and visualization. You'll find clear instructions, easy-to-follow lessons, and structured content that ensures steady progress.

Excel-tutorial.com stands out for its interactive teaching approach. Our lessons include exercises, real-life use cases, and engaging quizzes to solidify your understanding. This lets you apply your new skills immediately to real-world tasks, making learning both practical and impactful.

Plus, you can track your progress and test your knowledge with quizzes that provide instant feedback. Our goal is to help you gain confidence in Excel, one concept at a time. Join us at Excel-tutorial.com and start transforming your data skills today!