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.

Excel test with the function IF, IFS, IFERROR

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?

Customer acquisition cost

Calculate cost-per-customer from marketing campaign data, handling the #DIV/0! error progressively with IF, IFERROR and ROUND — 8 guided steps.

Divide the budget by the number of sales

1 / 8

You are reviewing the customer acquisition cost of 10 marketing campaigns. Column B holds the budget invested and column C the number of sales generated.
In D2, calculate the cost per sale by dividing the budget by the number of sales.

Acquisition cost — Q1 · 535

2 / 8

Fill the formula down to D11.
You will notice that some cells display #DIV/0! — that is normal when the number of sales is 0.

Acquisition cost — Q2 · 536

=IF( logical_test , value_if_true , value_if_false )

3 / 8

To avoid the #DIV/0! error, use the classic method: first test whether the number of sales is 0.
In D2, write an IF function: if the sales equal 0, display "No sales", otherwise calculate the cost per sale.

Acquisition cost — Q3 · 537

4 / 8

Fill the IF formula down (column D)

Acquisition cost — Q4 · 538

=IFERROR( value , value_if_error )

5 / 8

The IFERROR function does the same job more simply: it tries the calculation and, if an error occurs, displays a replacement text.
In D2, use IFERROR to calculate the cost per sale. If the calculation returns an error, display "No sales".

Acquisition cost — Q5 · 539

6 / 8

Fill IFERROR down (column D)

Acquisition cost — Q6 · 540

=IFERROR( ROUND( calculation , num_digits ) , value_if_error )

7 / 8

IFERROR can wrap any formula. Here, round the cost per sale to 2 decimal places with ROUND, the whole thing protected by IFERROR.
In D2, write IFERROR containing ROUND(B2/C2,2). If an error occurs, display "No sales".

Acquisition cost — Q7 · 541

8 / 8

Fill IFERROR + ROUND down (column D)

Acquisition cost — Q8 · 542

Your score is

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!

Excel Test for IF, IFS & IFERROR functions

Related Exercises

Excel-Tutorial.com, your training partner.

Most Viewed Posts