Do you know the Excel functions?

Ready to prove your Excel skills? Take our exciting test and challenge yourself with 10 randomly chosen questions from a pool of 50! Here's what to expect:

• How to Write Functions: Brush up on writing essential functions like SUMIF, VLOOKUP, INDEX, and MATCH. Know the syntax, understand the parameters, and practice writing them flawlessly.
• Which Function to Use? Encounter scenarios where you’ll need to decide the best function for the job. Is it IF for simple decisions, SUMIFS for multiple criteria, or XLOOKUP for the latest lookup challenge? Pick wisely!
• Correct or Incorrect? Test your knowledge by choosing the correct way to write functions. It’s not just about knowing what functions do but also understanding the right syntax to use.

8

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

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

Row 4

Row 3

Row 5

Row 2

2 / 10

Which formula returns the minimum time worked in the week?

=MIN(B2:F10)

=MINI(B2:B10)+MIN(C2:C10)+MIN(D2:D10)+MIN(E2:E10)+MIN(F2:F10)

=MINI(B2:B10)&MIN(C2:C10)&MIN(D2:D10)&MIN(E2:E10)&MIN(F2:F10)

=MINIMUM(B2:F10)

3 / 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,OR(C2<30,E2='Yes'))

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

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

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

4 / 10

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

=TEXTJOIN(' ',,A2:B2)

=A2&' '&B2

=TEXTJOIN(A2:B2,' ')

FlashFill

=CONCATENATE(A2:B2)

5 / 10

This question concerns the position of dollars in a formula. We want to build a multiplication table by using the values in the headers.
How do you write the formula in B2 to stay on row 1 and column A?

=A2*B1

=A$2*B$1

=$A2*$B1

=$A$2*$B$1

=$A2*B$1

6 / 10

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

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

=DCOUNT(A:A13,3,H2)

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

=DCOUNT(A1:E13,3,H2)

7 / 10

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

#N/A

0

Detox green tea

3.95

8 / 10

Which functions can transform the text in uppercase?

=UPPER(A2)

=UPPERCASE(A2)

=UCASE(A2)

=PROPER(A2)

9 / 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(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","")

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

10 / 10

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

11

2

16.5

0

Your score is

The average score is 26%

Share your score with your network

LinkedInFacebook

Restart quiz

Send feedback

After you finish, you’ll see your results and any mistakes. Don't worry if you get some wrong – each question has links to help you learn more and sharpen those skills. Ready to excel in Excel? Dive in and see how you score!

Excel-Tutorial.com, your training partner.

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 analysis.

What sets excel-tutorial.com apart from other training sites is our interactive teaching approach. Exercises and real-life use cases accompany our lessons. So you can apply your new skills immediately to your day-to-day work.

Related Articles

• Test Excel Keywords
• Excel Advanced Test
• Tests Excel for Expert users
• TOSA Excel – Format, Alignment, Filter
• More Excel tests with XAT