Test Excel for Expert users

Can you correctly answer more than 8 questions about our Excel test for expert users? We’ve crafted an Excel challenge designed for the real experts out there. This test isn't just any ordinary quiz; it’s a dynamic, 10-question challenge picked randomly from a pool of 50 expertly curated questions. Here’s what you can expect:

• Diverse Questions: From advanced formulas to data visualization, this test covers all the tricky corners of Excel.
• Randomized Challenge: Every time you take the test, you’ll face a new set of 10 questions—keeping you on your toes!
• Immediate Feedback: At the end of the test, you’ll see your score and learn which questions you aced and which you slipped up.
• Learn As You Go: After each question, you’ll have the opportunity to click on handy links for detailed explanations and tutorials so you can sharpen your skills right away.

Ready to prove you’re a true Excel expert? Dive into the test, challenge yourself, and turn those mistakes into mastery! Your journey to Excel perfection starts now!

0

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

Which function allows you to find the position of an element in a list, for example, the rank of Friday in the list of weekdays?

MATCH

INDEX

INDIRECT

RANK

2 / 10

Which formula allows you to find the number of unmarried men?

=COUNTIFS(A2:A13;''Man'';D2:D13;''No'')

=COUNTIFS(''Man'';A2:A13;''No'';D2:D13)

=COUNTIF(A2:A13;''Man'';D2:D13;''No')

=COUNTIFS(A2:A13;''Man'';D2:D13;''Unmarried'')

3 / 10

Which formula can be used to round the numbers to the nearest ten?

=ROUND.DOZEN(A2,1)

=ROUND(A2,-10)

=ROUND(A2,1)

=ROUND(A2,-1)

4 / 10

Which formula adds 5 hours to cell A1?

=A1+5

=A1+5/24

=A1+TIME(5;0;0)

=A1+TIME(0;5;0)

5 / 10

Which formula counts the number of rows for men with an income greater than 40000

=COUNTIFS(''No'';D2:D13;>=400000;F2:F13)

=COUNTIFS(D2:D13;''No'';F2:F13;''>=40000'')

=COUNTIFS(D2:D12;''No'';F2:F13;''>=40000'')

=COUNTIFS(D2:D13;''No'';F2:F13;>=40000)

6 / 10

Which custom number format code displays negative numbers in parentheses?

(# ##0,00)

# ##0,00;(# ##0,00)

# ##0,00;''(''# ##0,00'')''

(0)

7 / 10

Which result returns the following formula =DATE(YEAR(TODAY());MONTH(TODAY())+1;1) ?

The first day of the following month

The first day of the year

The first Monday of the current month

The first day of the current month

8 / 10

Which statistics function returns the most frequent value in a list of values?

=MODE.SNGL(B2:E11)

=RANK(B2:E11)

=FREQUENCY(B2:E11)

=STDEV.S(B2:E11)

9 / 10

Which custom conditional formatting formula colors the weekends with a different color?

=IF(WEEKDAY(A1)>5;TRUE;FALSE)

=WEEKDAY(A1)>5

=WEEKDAY(A1)<5

=WEEKDAY(A$1;2)>5

10 / 10

Which statistical function should be associated with the average to know the dispersion around the mean?

MODE.SNGL

FREQUENCY

STDEV

QUARTILE

Your score is

The average score is 0%

Share your score with your network

LinkedIn Facebook

Restart quiz

Send feedback

More Excel quiz

• Test Excel Keywords
• 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!