Excel Advanced Test

Think you’ve mastered Excel? Test yourself with our Advanced Excel Test! Here’s what you can expect:

• 10 Questions, Randomized Each Time: Each test is unique, pulling 10 questions from a pool of 50. No two tests are the same!
• Instant Results and Feedback: Once you finish, you’ll get your score and see which questions you nailed and which ones need a bit more practice.
• Learn as You Go: Each question comes with a link to dive deeper into the topic, so you can brush up on any tricky areas.

25

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

What is the difference between the functions COUNTA and COUNT?

In a Selection, COUNT counts all the cells selected, COUNTA counts the empty cells

In a Selection, COUNT counts the number of cells with numeric value, COUNTA counts all the cells selected

No difference

In a Selection, COUNTA counts the number of cells with text value, COUNT counts all the cells selected

2 / 10

Which Excel function returns the week number according to the European and Asian rule

=WEEKNUM(B2,2)

=ISOWEEKNUM(B2,2)

=ISOWEEKNUM(B2)

=WEEKNUM(B2)

3 / 10

Which formula is used to group the 3 columns by putting a space between each word?

=CONCAT (A2:C2)

=A2+B2+C2

=A2 & B2 & C2

=TEXTJOIN(" ",,A2:C2)

4 / 10

What formula should be written to display the word 'Out of Office' when the hours worked in column B are empty?

=IF(ISEMPTY(B2),"","Out of Office")

=IF(ISEMPTY(B2),"Out of Office","")

=IF(ISEMPTY(B2),"Out of Office")

=ISEMPTY(B2)

5 / 10

Which formula allows you to return the number of rows corresponding to Men?

=COUNTIF(A2:A13)="Man"

=COUNTIF(A2:A13,"Man")

=COUNTIF("Man",A2:A13)

=COUNT(A2:A13)="Man"

6 / 10

Which formula removes spaces before and after text in a cell?

=NO.SPACE(A2)

=TRIM(A2)

=SPACE(A2)

=CLEAN(A2)

7 / 10

Which feature understands the text transformations you want to do and applies it to the rest of your data?

Automatic Fill

Flashfill

Fill Series

Magic Fill

8 / 10

What is the name of this chart?

Population pyramid

Stairs

Christmas tree

spiral

9 / 10

Which formula should be used to calculate the prices including all taxes using the reference of cell C1?

=B4*(1+$C$1)

=B4*1+$C$1

=B4*C1

=B4*(1+C1)

10 / 10

Which formula will return the date of the system date?
That means, each day, the value of the day will change to display the day of the current day

=DATE()

=DAY()

=TODAY()

=NOW()

Your score is

The average score is 55%

Share your score with your network

LinkedInFacebook

Restart quiz

Send feedback

More Excel quizzes

• 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!