Excel Functions MCQ Quiz – 30 Questions with Answers

How well do you know Microsoft Excel functions? Test your knowledge with this Excel Functions MCQ Quiz featuring 30 multiple-choice questions.

This quiz covers commonly used Excel functions such as SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, IF, COUNTIF, SUMIF, VLOOKUP and other useful functions.

Important: Try to answer all the questions before checking the Answer Key at the bottom of this page.

30 Questions

MCQ Format

Beginner Level

Excel Functions MCQ Quiz

Instructions: Read each question carefully and select the correct option. Do not check the answers until you have completed all 30 questions.

Question 1

Which Excel function is used to add numbers together?

A) AVERAGE() B) SUM() C) COUNT() D) MAX()

Question 2

Which function calculates the average of a group of numbers?

A) SUM() B) COUNT() C) AVERAGE() D) TOTAL()

Question 3

Which Excel function returns the largest value in a range?

A) HIGH() B) MAX() C) LARGEVALUE() D) TOP()

Question 4

Which function returns the smallest value in a range?

A) LOW() B) SMALLVALUE() C) MIN() D) LOWEST()

Question 5

Which Excel function counts cells containing numbers?

A) COUNT() B) COUNTA() C) NUMBER() D) COUNTNUM()

Question 6

Which function counts non-empty cells?

A) COUNT() B) COUNTA() C) COUNTBLANK() D) NONEMPTY()

Question 7

Which Excel function counts blank cells in a range?

A) COUNT() B) COUNTA() C) COUNTBLANK() D) BLANKCOUNT()

Question 8

Which function is used to perform a logical test in Excel?

A) IF() B) TEST() C) LOGIC() D) CHECK()

Question 9

Which function adds values that meet a specified condition?

A) SUM() B) SUMIF() C) ADDIF() D) TOTALIF()

Question 10

Which function counts cells that meet a specified condition?

A) COUNT() B) COUNTIF() C) COUNTALL() D) IFCOUNT()

Question 11

Which function calculates the average of cells that meet a condition?

A) AVERAGEIF() B) IFAVERAGE() C) AVGIF() D) CONDITIONALAVERAGE()

Question 12

Which function is commonly used to look up a value vertically in a table?

A) HLOOKUP() B) VLOOKUP() C) LOOKUPV() D) FIND()

Question 13

Which function searches for a value horizontally across the top row of a table?

A) VLOOKUP() B) HLOOKUP() C) ROWLOOKUP() D) SEARCH()

Question 14

Which function can combine text from multiple cells or text strings?

A) CONCAT() B) COMBINE() C) MERGETEXT() D) JOINTEXT()

Question 15

Which function returns the number of characters in a text string?

A) CHARCOUNT() B) LENGTH() C) LEN() D) TEXTCOUNT()

Question 16

Which function converts text to uppercase letters?

A) UPPER() B) UCASE() C) CAPITAL() D) UPPERCASE()

Question 17

Which function converts text to lowercase letters?

A) LOWER() B) LCASE() C) SMALLTEXT() D) LOWERCASE()

Question 18

Which function removes extra spaces from text?

A) CLEAN() B) TRIM() C) SPACEREMOVE() D) CLEARSPACE()

Question 19

Which function rounds a number to a specified number of digits?

A) ROUND() B) ROUNDOFF() C) ROUNDNUMBER() D) FORMAT()

Question 20

Which function returns the absolute value of a number?

A) ABS() B) ABSOLUTE() C) POSITIVE() D) VALUEABS()

Question 21

Which function returns the remainder after division?

A) DIVIDE() B) REMAINDER() C) MOD() D) DIV()

Question 22

Which function returns the current date and time?

A) DATE() B) TIME() C) NOW() D) CURRENT()

Question 23

Which function returns the current date?

A) TODAY() B) DATE() C) CURRENTDATE() D) NOWDATE()

Question 24

Which function extracts the year from a date?

A) DATEYEAR() B) YEAR() C) GETYEAR() D) EXTRACTYEAR()

Question 25

Which function extracts the month number from a date?

A) MONTH() B) GETMONTH() C) DATEMONTH() D) EXTRACTMONTH()

Question 26

Which function extracts the day of the month from a date?

A) DAY() B) DATE() C) GETDAY() D) DAYVALUE()

Question 27

Which function returns the position of a value within a range?

A) INDEX() B) MATCH() C) POSITION() D) FINDVALUE()

Question 28

Which function returns a value from a specified row and column in a range?

A) MATCH() B) INDEX() C) VALUE() D) GET()

Question 29

Which function is used to handle errors by returning an alternative result?

A) ERRORIF() B) IFERROR() C) HANDLEERROR() D) ERRORCHECK()

Question 30

Which formula correctly calculates the total of cells A1 through A10?

A) =TOTAL(A1:A10) B) =ADD(A1:A10) C) =SUM(A1:A10) D) =PLUS(A1:A10)

Excel Functions Quiz – Answer Key

⚠️ Check your answers only after completing all 30 questions.

The correct answers and short explanations are given below.

1. B) SUM()

SUM() adds numbers or values from selected cells or ranges.

2. C) AVERAGE()

AVERAGE() calculates the arithmetic mean of numbers.

3. B) MAX()

MAX() returns the largest value from a range.

4. C) MIN()

MIN() returns the smallest value from a range.

5. A) COUNT()

COUNT() counts cells containing numbers.

6. B) COUNTA()

COUNTA() counts cells that are not empty.

7. C) COUNTBLANK()

COUNTBLANK() counts blank cells in a specified range.

8. A) IF()

IF() performs a logical test and returns one result when the condition is TRUE and another when it is FALSE.

9. B) SUMIF()

SUMIF() adds cells that meet a specified condition.

10. B) COUNTIF()

COUNTIF() counts cells that meet a specified condition.

11. A) AVERAGEIF()

AVERAGEIF() calculates an average based on a specified condition.

12. B) VLOOKUP()

VLOOKUP() searches for a value in the first column of a table and returns a corresponding value from another column.

13. B) HLOOKUP()

HLOOKUP() searches horizontally across the top row of a table.

14. A) CONCAT()

CONCAT() combines text from multiple ranges or strings.

15. C) LEN()

LEN() returns the number of characters in a text string, including spaces.

16. A) UPPER()

UPPER() converts text into uppercase letters.

17. A) LOWER()

LOWER() converts text into lowercase letters.

18. B) TRIM()

TRIM() removes extra spaces from text, while retaining single spaces between words.

19. A) ROUND()

ROUND() rounds a number to a specified number of digits.

20. A) ABS()

ABS() returns the absolute value of a number.

21. C) MOD()

MOD() returns the remainder after one number is divided by another.

22. C) NOW()

NOW() returns the current date and time.

23. A) TODAY()

TODAY() returns the current date.

24. B) YEAR()

YEAR() returns the year from a valid Excel date.

25. A) MONTH()

MONTH() returns the month number from a date.

26. A) DAY()

DAY() returns the day of the month from a date.

27. B) MATCH()

MATCH() returns the relative position of a value within a range.

28. B) INDEX()

INDEX() returns a value from a specified row and column in a range or array.

29. B) IFERROR()

IFERROR() returns a specified alternative result when a formula produces an error.

30. C) =SUM(A1:A10)

SUM(A1:A10) adds all numeric values from cells A1 through A10.

Excel Quiz Score Guide

Score	Result
27–30	Excellent – You have a strong understanding of Excel functions.
24–26	Very Good – Your Excel function knowledge is good.
18–23	Good – Keep practicing commonly used Excel functions.
12–17	Needs Improvement – Review basic Excel functions and try again.
0–11	Keep Practicing – Start with basic Excel functions such as SUM, AVERAGE, COUNT and IF.

What Are Excel Functions?

Excel functions are predefined formulas that help users perform calculations and process data quickly. Instead of creating a complex calculation manually, you can use a built-in function to perform a specific task.

For example, the formula =SUM(A1:A10) can be used to add the numbers stored in cells A1 through A10.

Common Excel Functions Every Beginner Should Know

• SUM() – Adds numbers.
• AVERAGE() – Calculates the average.
• COUNT() – Counts numeric cells.
• COUNTA() – Counts non-empty cells.
• MAX() – Finds the largest value.
• MIN() – Finds the smallest value.
• IF() – Performs a logical test.
• COUNTIF() – Counts cells based on a condition.
• SUMIF() – Adds values based on a condition.
• AVERAGEIF() – Calculates an average based on a condition.
• VLOOKUP() – Performs a vertical lookup.
• HLOOKUP() – Performs a horizontal lookup.
• INDEX() – Returns a value from a specified position.
• MATCH() – Finds the position of a value.

Who Should Take This Excel Functions Quiz?

This Excel Functions MCQ Quiz is useful for:

• Students learning Microsoft Excel
• Beginners preparing for computer courses
• Office employees
• Data entry operators
• Teachers and trainers
• Accounting students
• Job seekers preparing for Excel tests
• Anyone who wants to improve their Excel skills

Frequently Asked Questions

What is an Excel Functions MCQ Quiz?

An Excel Functions MCQ Quiz is a multiple-choice test that checks your knowledge of Microsoft Excel functions such as SUM, AVERAGE, COUNT, IF, MAX, MIN and lookup functions.

How many questions are included in this Excel Functions Quiz?

This quiz contains 30 multiple-choice questions covering commonly used Excel functions.

Is this Excel Functions Quiz suitable for beginners?

Yes. The quiz focuses mainly on commonly used Excel functions and is suitable for beginners, students and basic computer-course learners.

Are the answers provided in this Excel quiz?

Yes. The complete Answer Key with short explanations is provided at the bottom of the quiz so you can check your answers after completing all questions.

Conclusion

Excel functions are an important part of working with spreadsheets. Learning functions such as SUM, AVERAGE, COUNT, IF, SUMIF, COUNTIF, VLOOKUP and INDEX can help you work with data more efficiently.

Take this Excel Functions MCQ Quiz, check your score using the answer key, and practice the functions you found difficult.

How many questions did you answer correctly? Try the quiz again and improve your score!