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

18

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

What returns the function DSUM in this situation?

2

0

11

16.5

2 / 10

What is the result returned by the SUMIFS function

39

0

18

03/09/2023

3 / 10

What is the result returned by the formula =DATE(B1,B2,1)-1

#VALUE!

31/08/2023

01/09/2023

00/09/2023

4 / 10

How do you write a logical test to select hotels with a Fitness room, with 3 stars classification or more, and the price of the menu is less than 30?

=AND(B2>=3,C2<30,E2='Yes')

=AND(B2>=3,OR(C2<30,E2='Yes'))

=XOR(B2>3,C2<30,E2=Yes)

=AND(B2>3,C2<=30,E2='Yes')

5 / 10

Which Excel function removes the spaces before each name?

SPACE

REMOVESPACE

CLEAR

TRIM

6 / 10

The following formulae use the basic mathematics operator (+, -, *, /) and parentheses. Which of the following formulae returns 36?

Row 3

Row 5

Row 4

Row 2

7 / 10

The SUM function returns the value 10 instead of 14. Why the 4 is not included?

The cell B4 is not in included in the range to sum

The SUM function doesn't add cells with a background color

The SUM function doesn't add cell in bold

The SUM function doesn't add text

8 / 10

What is the formula that calculates the Total column?

=D2*C2

=C2*D2

=C2+D2

=C2*A2+D2

9 / 10

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

2

0

11

16.5

10 / 10

Which formula or tool can join the name and the first name?

=CONCATENATE(A2:B2)

=TEXTJOIN(' ',,A2:B2)

=TEXTJOIN(A2:B2,' ')

=A2&' '&B2

FlashFill

Your score is

The average score is 31%

Share your score with your network

LinkedInFacebook

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!