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

7

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

How to write the DCOUNT function to return the following result?

=DCOUNT(A1:E13,3,H2)

=DCOUNT(A1:C13,5,H1:H2)

=DCOUNT(A1:E13,3,H1:H2)

=DCOUNT(A:A13,3,H2)

2 / 10

What is the result returned by the SUMIFS function

0

18

03/09/2023

39

3 / 10

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

=TEXTJOIN(A2:B2,' ')

=CONCATENATE(A2:B2)

=A2&' '&B2

=TEXTJOIN(' ',,A2:B2)

FlashFill

4 / 10

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

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

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

=VLOOKUP(F5,A2:D18,3)

=VLOOKUP(A2:D18,F5,2)

5 / 10

What result returns the formula =VLOOKUP(F5,A2:D18,4,0)

#N/A

Beverage

7.66

Ethiopian Ground Coffee

6 / 10

What is the formula that calculates the Total column?

=C2*D2

=D2*C2

=C2+D2

=C2*A2+D2

7 / 10

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

=COUNTIF(C2:C13,6+)

=COUNTIFS(C2:C13,>=6)

=COUNTIF(>=6,C2:C13)

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

8 / 10

Which Excel function removes the spaces before each name?

SPACE

REMOVESPACE

TRIM

CLEAR

9 / 10

Which Excel function returns the position of a value in a list?

XLOOKUP

INDEX

VLOOKUP

MATCH

10 / 10

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

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

The SUM function doesn't add cell in bold

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

The SUM function doesn't add text

Your score is

The average score is 24%

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!