421

Excel Quizzes

Test your Excel knowledge with our Microsoft Excel tests, are you a beginner, intermediate or advanced user?

0%

Excel Basics Quiz

Don’t know where your level of Excel knowledge is?

Try out our Basic level quiz and find out today!

1 / 10

  1. What is the shortcut key combination to select the entire worksheet in Microsoft Excel?

2 / 10

In Microsoft Excel spreadsheets, rows are labelled as _______

3 / 10

Which keyboard shortcut is used to paste only the values (without formatting) in Excel?

4 / 10

Which Excel feature allows you to combine data from multiple cells into a single cell?

5 / 10

The intersection of a column and a row in MS Excel worksheet is known as _______

6 / 10

  1. Which function is used to add up a range of cells in Excel?

7 / 10

Which of the following functions is used to find the highest value in a range of cells?

8 / 10

Formulas in Excel start with ________

9 / 10

Which keyboard shortcut is used to insert a new row in Excel?

10 / 10

In Microsoft Excel spreadsheets, COLUMNS are labelled as _______

Hey there, Thank you for completing the quiz, Please input your Name(optional) and email address and your results will be sent to you shortly.

Thank you

0%

Excel Intermediate Quiz

Already mastered the basics?

Put your skills to the test in our intermediate level quiz.

1 / 10

How can you add data labels to a chart in Excel? /

2 / 10

What is the purpose of using the “Sparklines” feature in Excel?

3 / 10

What does the function IFERROR do in Excel? /

4 / 10

What is the purpose of using data validation in Excel?

5 / 10

  1. Which Excel feature allows you to set up dropdown lists or specify range limits for data entry?

6 / 10

What does the Consolidate feature in Excel allow you to do?

7 / 10

Which Excel feature allows you to ensure that data entered into a cell meets specific criteria or conditions?

8 / 10

Which Excel feature allows you to visually represent data using different types of graphical representations? /

9 / 10

What is the purpose of conditional formatting in Excel?

10 / 10

Which Excel feature allows you to combine data from multiple cells into a single cell? /

Hey there, Thank you for completing the quiz, Please input your Name(optional) and email address and your results will be sent to you shortly.

Thank you

0%

Excel Advanced Quiz

This is the final quiz in our level test set

Test your expertise with our advanced level quiz.

1 / 10

How can you update the source data range for an existing PivotTable?

2 / 10

What does the “What-If Analysis” feature in Excel allow you to do?

3 / 10

How do you create a pivot table?

4 / 10

What is a pivot table?

5 / 10

Which Excel function can perform both vertical and horizontal lookups, allowing you to search for a value in both rows and columns simultaneously?

6 / 10

If you want to fix a cell reference, you will use –

7 / 10

What are the benefits of using a pivot table?

8 / 10

What is the difference between VLOOKUP and HLOOKUP?

9 / 10

The Not Equal operator in Excel is –

10 / 10

In a PivotTable, what does the “Values” area represent?

Hey there, Thank you for completing the quiz, Please input your Name(optional) and email address and your results will be sent to you shortly.

Thank you

View Our Courses Now

Microsoft Excel
(Basics - Advanced)

View Now

Dashboard, Power Pivot & Power Query

View Now

Visual Basics for Application (VBA)

View Now

Microsoft Power Business Intelligence (Power BI)

View Now

Financial Modelling

View Now

Financial Statement Analysis

View Now
WhatsApp chat
Skip to toolbar