Call Us Today! +91 99907 48956, +91 96503 08956 | info@analyticstraininghub.com

Excel Skills Assessment Quiz

Take this quick MCQ quiz and discover your Excel skill level in just a few minutes!

Key Instructions – Excel MCQ Quiz

Hello and welcome to the Excel MCQ Quiz at Analytics Training Hub

Read these instructions carefully before starting:

You will be presented with 10 randomly chosen multiple-choice questions from various Excel topics, including:
• Formulas and Functions
• Data Analysis Tools
• Formatting and Visualization
• Shortcuts and Productivity Features
• Conditional Logic

You need to achieve a minimum of 7 out of 10 to pass the quiz.
The questions are randomly chosen, so every attempt can contain varying sets of questions.
The quiz has a time limit, so make sure to answer each question in a reasonable amount of time.
When you are ready, click Start Quiz to start. Good luck!

Excel MCQ Quiz at Analytics Training Hub.

1 / 10

To remove duplicates, go to:

Data ➝ Remove Duplicates

Home ➝ Clear

File ➝ Options

Review ➝ Clean

2 / 10

Which formula will count only blank cells?

COUNT()

COUNTA()

COUNTBLANK()

COUNTIF()

3 / 10

What does the formula =INDEX(A2:A10, MATCH(25, B2:B10, 0)) do?

Looks up 25 and returns a value from A2:A10

Returns the row number of 25

Sums the range

Returns 25 if found

4 / 10

In Excel, rows are labelled by:

Letters

Numbers

Alphabets

Symbols

5 / 10

Which tool can be used to quickly apply the same formatting?

Format Painter

Flash Fill

Filter

Conditional Formatting

6 / 10

Which function is used to detect an error and return a custom message instead?

ERROR()

CATCH()

IFERROR()

TRAP()

7 / 10

Which formula will count non-blank cells in a range A1:A10?

=COUNT(A1:A10)

=COUNTBLANK(A1:A10)

=COUNTA(A1:A10)

=COUNTIF(A1:A10, "NOTBLANK")

8 / 10

Which function can return a dynamic array of values in Excel 365?

VLOOKUP

UNIQUE()

FIND

LEFT

9 / 10

Which function can be used to extract the year from a date in cell A1?

=YEAR(A1)

=DATE(A1)

=EXTRACT(A1, "YYYY")

=TEXT(A1, "YYYY")

10 / 10

Which Excel feature can unpivot columns into rows?

PivotTable

Power View

Power Query

Consolidate

Just a quick step—fill out the form before you begin the quiz!

NameEmailPhone Number

Your score is

The average score is 59%

Learn Data Analytics, Power BI, Tableau, & Advance Excel with hands-on training & 100% job assistance.

Connect with us!

Our Programs

Discover

Company

Contact Info

+91 99907 48956

Email

info@analyticstraininghub.com

Address

91 Springboard, B1/H3, NH-19, Block B, Mohan Cooperative Industrial Estate, New Delhi, Delhi - 110044

Professional Courses

Master's Programs