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.

68

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

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

Automatic Fill

Fill Series

Flashfill

Magic Fill

2 / 10

How to change the orientation of a range of cells easily?

Paste Special > Transpose

Page Layout > Orientation

Data > Text to Columns

Data > Consolidate

3 / 10

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

=COUNTIF(A2:A13,"Man")

=COUNTIF("Man",A2:A13)

=COUNTIF(A2:A13)="Man"

=COUNT(A2:A13)="Man"

4 / 10

Which custom Time format must be applied to display the hours over 24H?

(h):mm

hhh:mm

(h:mm)

[h]:mm

5 / 10

Which tool allows you to change the color of cells automatically according to their values (here the 10 highest values)?

Fill Color

Color Chart

Chromatic tool

Conditional Formatting

6 / 10

What is the name of this chart?

spiral

Stairs

Population pyramid

Christmas tree

7 / 10

Which tool can add a progress bar in your cell according to the value?

Insert > Progress bar

Home > Conditional Formatting > Data Bars

Insert > Sparklines > Line

Data > Validation

8 / 10

What result returns the formula =SUMIF(A2:A9,B10,C2:C9)

11

13

16

5

9 / 10

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

=TRIM(A2)

=CLEAN(A2)

=SPACE(A2)

=NO.SPACE(A2)

10 / 10

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

=A2+B2+C2

=A2 & B2 & C2

=TEXTJOIN(" ",,A2:C2)

=CONCAT (A2:C2)

Your score is

The average score is 54%

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!