Excel Tutorial
Excel tutorials, quizzes & AI guides — all levels
RSS
  • Online Excel Exercises
  • Training
  • Excel Tests
  • Sitemap
  • Premium Quizzes
  • Shop
  • My account

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

You have 10 minutes to complete this quiz

No more time to complete the quiz


Word cloud Excel Functions

1 / 10

Which functions can transform the text in uppercase?

2 / 10

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

3 / 10

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

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?

5 / 10

Which Excel function removes the spaces before each name?

6 / 10

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

7 / 10

In this example, you have the different Vehicle Internal Numbers (VIN) How to extract the VDS which is the characters between the 4 and 9 position?

8 / 10

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

9 / 10

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

10 / 10

What is the result returned by the SUMIFS function

Your score is

The average score is 31%

Share your score with your network

LinkedInFacebook

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

Most Viewed Posts

  • Displaying Negative Numbers in Parentheses in Excel (309,767)
  • Top 10 Excel Functions You Must Know (231,843)
  • How to make automatic calendar in Excel (212,378)
  • Dash for a zero in Excel automatically (190,135)
  • Converting a Date from YYYYMMDD to DD/MM/YYYY in Excel (170,144)
  • Date Format in Excel (154,577)
  • Use Excel Online for Free (134,547)
  • Excel Split Date and Time (133,316)
  • How to calculate VAT in Excel? (126,954)
  • Exchange rate in Excel 🏛️ (124,156)
  • Add Emojis to your Excel charts or slicers (116,880)
  • Why Excel Formulas Use Comma or Semi-Colon (101,699)
  • Master XLOOKUP function in Excel (101,695)
  • UNIQUE Function – Remove duplicates with formulas (97,897)
  • Change the default Date format in Excel (94,500)

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net

Contact us
About me 
Privacy Policy

© 2022 – 2026 – excel-tutorial.com. All Rights Reserved.
Excel Tutorial is managed by majordome du net