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

You have 10 minutes to complete this quiz

No more time to complete the quiz


Word cloud Excel Functions

1 / 10

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

2 / 10

What is the result returned by the DATE function?

3 / 10

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

4 / 10

What returns the function DSUM in this situation?

5 / 10

Which functions can transform the text in uppercase?

6 / 10

Which formula extracts the room number?

7 / 10

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

8 / 10

Which formula returns the minimum time worked in the week?

9 / 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?

10 / 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?

Your score is

The average score is 25%

Share your score with your network

LinkedIn Facebook

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.