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.

This test is perfect for those who want to challenge themselves and learn new Excel tricks along the way. Whether you aim to sharpen your work skills or just love solving Excel puzzles, this test is for you. Ready to see how you stack up?

Take the test now and elevate your Excel game!

 

Start

1. Which formula build to know if 2 cells are identical?

1.=SAME(A2;B2)

2.=EQUAL(A2;B2)

3.=COMPARE(A2;B2)

4.=A2=B2

Question 1 of 10

2. What is the difference between the functions COUNTA and COUNT?

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

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

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

4.No difference

Question 2 of 10

3. Which custom format code returns the date in A1?

1.d ddd mmmm yyyy

2.ddd dd mmmm yyyy

3.''Wed'' dd mm yy

4.dd dd mmm yyyy

Question 3 of 10

4. Which shortcut adds dollars to your cells' references?

1.F4

2.F7

3.F2

4.F5

Question 4 of 10

5. What is the name of this chart?

1.Sunburst

2.Donuts

3.Treemap

4.Multi-pie chart

Question 5 of 10

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

 

1.=IF(ISEMPTY(B2),''Out of Office'','''')

2.=IF(ISEMPTY(B2),'''',''Out of Office'')

3.=IF(ISEMPTY(B2),''Out of Office'')

4.=ISEMPTY(B2)

Question 6 of 10

7. What is the name of this chart?

1.Christmas tree

2.spiral

3.Population pyramid

4.Stairs

Question 7 of 10

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

1.Automatic Fill

2.Magic Fill

3.Fill Series

4.Flashfill

Question 8 of 10

9. What is the best way to create a list of months?

1.Write the first month and use the fill-handle

2.Write the formula =TEXTE(A1,''mmmm'')

3.Write each month one-by-one

4.Write the formula =MONTH(A1)+1

Question 9 of 10

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

1.=NO.SPACE(A2)

2.=SPACE(A2)

3.=CLEAN(A2)

4.=TRIM(A2)

Question 10 of 10

 Loading...

 

• Test Excel Keywords
• Excel Advanced Test
• Tests Excel for Expert users
• TOSA Excel – Format, Alignment, Filter
• More Excel tests with XAT

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!