TOSA Excel – Assessment of the Excel functions

Welcome to the Excel functions Assessment based on TOSA standards!

This test evaluates your knowledge of the Excel functions, following the TOSA (Test On Software Applications) standards

• The result returned by the functions
• How to write the functions correctly
• Situations where the functions are best used

Assessment Overview

This assessment will evaluate your knowledge of Excel functions:

• Essential functions: SUM, AVERAGE, MIN, MAX
• The logical tests (=, >, <, <>)
• Condition: IF, AND, OR, COUNTIF, SUMIF
• Lookup functions: VLOOKUP, INDEX, MATCH
• DataBase functions: DCOUNT, DSUM

2

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

What is the result returned by the formula =VLOOKUP(F5,A2:D11,3,0) ?

#N/A

Detox green tea

3.95

0

2 / 10

You want to plan a meeting for the companies in the cities of Manchester and Bristol with more than 20 employees. How to write the formula?

=IF(OR(B2='MANCHESTER',B2='BRISTOL',C2>=20),'Meeting','')

=IF(AND(B2='MANCHESTER',B2='BRISTOL',C2>=20),'Meeting','')

=IF(AND(OR(B2='MANCHESTER',B2='BRISTOL'),C2>=20),'Meeting','')

=IF(OR(AND(B2='MANCHESTER',B2='BRISTOL'),C2>=20),'Meeting','')

3 / 10

Which formula returns the number of items where the quantity is greater or equal than 6?

=COUNTIF(C2:C13,'>=6')

=COUNTIF(>=6,C2:C13)

=COUNTIF(C2:C13,6+)

=COUNTIFS(C2:C13,>=6)

4 / 10

Which answer(s) returns the average for each student?

=AVERAGE(B2:E8)

=SUM(B2:E8)/COUNT(A2:A8)

=SUM(B2:E8)

=SUM(B2:E8)/5

5 / 10

What returns the function DSUM in this situation?

0

11

2

16.5

6 / 10

Which result returns the formula =DCOUNT(A1:E13,3,H1:H2)

16.5

2

11

0

7 / 10

What is the result returned by the SUMIFS function

18

39

03/09/2023

0

8 / 10

How to return the product name according to the Product ID?

=VLOOKUP(A2:D18,F5,2)

=VLOOKUP(F5,A2:D18,3,0)

=VLOOKUP(F5,A2:D18,3)

=VLOOKUP(F5,A2:D18,'C')

9 / 10

We give a bonus of 200$ for all the employees who have sold 20 units or more. Which formula do the job?

=IF(B;20,0,200)

=IF(B<20,0,200)

=IF(B2<20,200,)

=IF(B2>=20,200,0)

=IF(B2>=20,0,200)

10 / 10

What is the formula that calculates the Total column?

=C2*A2+D2

=C2+D2

=D2*C2

=C2*D2

Your score is

The average score is 25%

Share your score with your network

LinkedIn Facebook

Restart quiz

Send feedback

Other Excel Assessment

• Beginner Excel Test
• Excel Advanced Test
• Tests Excel for Expert users
• TOSA Excel – Format, Alignment, Filter

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!