MS Excel MCQs and Answers With Explanation | Microsoft Excel Quiz

MS Excel MCQs and Answers With Explanation – If you are searching for basic MCQ questions on MS Excel with answers, you can take a look at this article. Here, we have provided a brief introduction to MS Excel, along with Microsoft Excel MCQ questions and answers. Microsoft Excel is a powerful spreadsheet software developed by Microsoft Corporation, which is widely used in various industries and domains ranging from finance and accounting to data analysis and project management. Excel offers a wide range of features and tools, including formulas, charts, graphs, and macros, that help users organize and analyze their data more efficiently.

MS Excel MCQs and Answers

In this article, we will explore the basics of Excel and accommodate a set of Microsoft Excel Multiple Choice Questions/ Microsoft Excel Quiz to test your knowledge of this important software. Whether you are a beginner or an experienced user, this article will provide valuable insights into Excel and help you assess your understanding of its key concepts and features. Now, without any delay dive into these Top 60 MS Excel MCQ Questions and Answers and also get detailed explanations for them.

MS Excel Multiple Choice Questions

Name	MS Excel
Exam Type	MCQ (Multiple Choice Questions)
Category	Technical Quiz
Mode of Quiz	Online

Top 60 MS Excel Quiz Questions | Practice Microsoft Excel Quiz

1. Which function is used to calculate the sum of a range of cells in Excel?

a) COUNT
b) MAX
c) MIN
d) SUM

Answer: d) SUM.

Explanation: The SUM function is used to calculate the sum of a range of cells in Excel.

2. Which symbol is used to denote absolute cell references in Excel?

a) $
b) #
c) %
d) &

Answer: a) $.

Explanation: The $ symbol is used to denote absolute cell references in Excel.

3. Which shortcut key is used to create a new workbook in Excel?

a) Ctrl + N
b) Ctrl + O
c) Ctrl + S
d) Ctrl + P

Answer: a) Ctrl + N.

Explanation: The shortcut key Ctrl + N is used to create a new workbook in Excel.

4. Which function is used to count the number of cells in a range that contain numbers in Excel?

a) COUNT
b) MAX
c) MIN
d) SUM

Answer: a) COUNT.

Explanation: The COUNT function is used to count the number of cells in a range that contain numbers in Excel.

5. Which function is used to find the highest value in a range of cells in Excel?

a) COUNT
b) MAX
c) MIN
d) SUM

Answer: b) MAX.

Explanation: The MAX function is used to find the highest value in a range of cells in Excel.

6. Which function is used to find the lowest value in a range of cells in Excel?

a) COUNT
b) MAX
c) MIN
d) SUM

Answer: c) MIN.

Explanation: The MIN function is used to find the lowest value in a range of cells in Excel.

7. Which shortcut key is used to copy the contents of a cell in Excel?

a) Ctrl + C
b) Ctrl + V
c) Ctrl + X
d) Ctrl + Z

Answer: a) Ctrl + C.

Explanation: The shortcut key Ctrl + C is used to copy the contents of a cell in Excel.

8. Which shortcut key is used to paste the contents of a cell in Excel?

a) Ctrl + C
b) Ctrl + V
c) Ctrl + X
d) Ctrl + Z

Answer: b) Ctrl + V.

Explanation: The shortcut key Ctrl + V is used to paste the contents of a cell in Excel.

9. Which function is used to calculate the average value of a range of cells in Excel?

a) COUNT
b) MAX
c) MIN
d) AVERAGE

Answer: d) AVERAGE.

Explanation: The AVERAGE function is used to calculate the average value of a range of cells in Excel.

10. Which function is used to calculate the product of a range of cells in Excel?

a) COUNT
b) MAX
c) MIN
d) PRODUCT

Answer: d) PRODUCT.

Explanation: The PRODUCT function is used to calculate the product of a range of cells in Excel.

11. Which function is used to calculate the standard deviation of a range of cells in Excel?

a) COUNT
b) MAX
c) MIN
d) STDEV

Answer: d) STDEV.

Explanation: The STDEV function is used to calculate the standard deviation of a range of cells in Excel.

12. Which function is used to calculate the variance of a range of cells in Excel?
a) COUNT
b) MAX
c) MIN
d) VAR

Answer: d) VAR.

Explanation: The VAR function is used to calculate the variance of a range of cells in Excel.

13. Which function is used to concatenate two or more text strings in Excel?

a) CONCAT
b) CONCATENATE
c) TEXTJOIN
d) JOIN

Answer: b) CONCATENATE.

Explanation: The CONCATENATE function is used to concatenate two or more text strings in Excel.

14. Which function is used to return the current date in Excel?

a) TODAY
b) NOW
c) DATE
d) TIME

Answer: a) TODAY.

Explanation: The TODAY function is used to return the current date in Excel.

15. Which function is used to return the current date and time in Excel?

a) TODAY
b) NOW
c) DATE
d) TIME

Answer: b) NOW.

Explanation: The NOW function is used to return the current date and time in Excel.

16. Which function is used to convert a text string to uppercase letters in Excel?

a) UPPER
b) LOWER
c) PROPER
d) TEXT

Answer: a) UPPER.

Explanation: The UPPER function is used to convert a text string to uppercase letters in Excel.

17. Which function is used to convert a text string to lowercase letters in Excel?

a) UPPER
b) LOWER
c) PROPER
d) TEXT

Answer: b) LOWER.

Explanation: The LOWER function is used to convert a text string to lowercase letters in Excel.

18. Which function is used to capitalize the first letter of each word in a text string in Excel?

a) UPPER
b) LOWER
c) PROPER
d) TEXT

Answer: c) PROPER.

The PROPER function is used to capitalize the first letter of each word in a text string in Excel.

19. Which function is used to extract a specified number of characters from a text string in Excel?

a) LEFT
b) RIGHT
c) MID
d) TEXT

Answer: c) MID.

Explanation: The MID function is used to extract a specified number of characters from a text string in Excel.

20. Which function is used to return the leftmost characters from a text string in Excel?

a) LEFT
b) RIGHT
c) MID
d) TEXT

Answer: a) LEFT.

Explanation: The LEFT function is used to return the leftmost characters from a text string in Excel.

21. Which function is used to return the rightmost characters from a text string in Excel?

a) LEFT
b) RIGHT
c) MID
d) TEXT

Answer: b) RIGHT.

Explanation: The RIGHT function is used to return the rightmost characters from a text string in Excel.

22. Which function is used to count the number of characters in a text string in Excel?

a) LEN
b) COUNT
c) MAX
d) MIN

Answer: a) LEN.

Explanation: The LEN function is used to count the number of characters in a text string in Excel.

23. Which function is used to find the position of a specific character in a text string in Excel?

a) FIND
b) SEARCH
c) LOCATE
d) POSITION

Answer: a) FIND.

Explanation: The FIND function is used to find the position of a specific character in a text string in Excel.

24. Which function is used to replace a specified character or text string in a text string in Excel?

a) REPLACE
b) SUBSTITUTE
c) CHANGE
d) UPDATE

Answer: b) SUBSTITUTE.

Explanation: The SUBSTITUTE function is used to replace a specified character or text string in a text string in Excel.

25. Which function is used to round a number to a specified number of decimal places in Excel?

a) ROUND
b) ROUNDUP
c) ROUNDDOWN
d) TRUNC

Answer: a) ROUND.

Explanation: The ROUND function is used to round a number to a specified number of decimal places in Excel.

26. Which function is used to round a number up to the nearest integer in Excel?

a) ROUND
b) ROUNDUP
c) ROUNDDOWN
d) TRUNC

Answer: b) ROUNDUP

Explanation:The ROUNDUP function is used to round a number up to the nearest integer in Excel.

27. Which function is used to round a number down to the nearest integer in Excel?

a) ROUND
b) ROUNDUP
c) ROUNDDOWN
d) TRUNC

Answer: c) ROUNDDOWN.

Explanation: The ROUNDDOWN function is used to round a number down to the nearest integer in Excel.

28. Which function is used to remove the decimal portion of a number in Excel?

a) ROUND
b) ROUNDUP
c) ROUNDDOWN
d) TRUNC

Answer: d) TRUNC.

Explanation: The TRUNC function is used to remove the decimal portion of a number in Excel.

29. Which function is used to calculate the average of a range of cells in Excel?

a) SUM
b) AVERAGE
c) MAX
d) MIN

Answer: b) AVERAGE.

Explanation: The AVERAGE function is used to calculate the average of a range of cells in Excel.

30. Which function is used to find the maximum value in a range of cells in Excel?

a) SUM
b) AVERAGE
c) MAX
d) MIN

Answer: c) MAX.

Explanation: The MAX function is used to find the maximum value in a range of cells in Excel.

31. Which function is used to find the minimum value in a range of cells in Excel?

a) SUM
b) AVERAGE
c) MAX
d) MIN

Answer: d) MIN.

Explanation: The MIN function is used to find the minimum value in a range of cells in Excel.

32. Which function is used to find the largest value that is less than or equal to a specified value in a range of cells in Excel?

a) COUNTIF
b) SUMIF
c) MAXIF
d) VLOOKUP

Answer: d) VLOOKUP.

Explanation: The VLOOKUP function is used to find the largest value that is less than or equal to a specified value in a range of cells in Excel.

33. Which function is used to count the number of cells in a range that meet a specific criteria in Excel?

a) COUNT
b) SUM
c) MAX
d) COUNTIF

Answer: d) COUNTIF.

Explanation: The COUNTIF function is used to count the number of cells in a range that meet a specific criteria in Excel.

34. Which function is used to sum the values in a range of cells that meet a specific criteria in Excel?

a) COUNTIF
b) SUMIF
c) MAXIF
d) VLOOKUP

Answer: b) SUMIF.

Explanation: The SUMIF function is used to sum the values in a range of cells that meet a specific criteria in Excel.

35. Which function is used to return the highest value in a range of cells that meets a specific criteria in Excel?

a) COUNTIF
b) SUMIF
c) MAXIF
d) VLOOKUP

Answer: c) MAXIF.

Explanation: The MAXIF function is used to return the highest value in a range of cells that meets a specific criteria in Excel.

36. Which function is used to find the average of the cells in a range that meet a specific criteria in Excel?

a) COUNTIF
b) SUMIF
c) AVERAGEIF
d) VLOOKUP

Answer: c) AVERAGEIF.

Explanation: The AVERAGEIF function is used to find the average of the cells in a range that meet a specific criteria in Excel.

37. Which function is used to return the relative position of a value within a range of cells in Excel?

a) MATCH
b) INDEX
c) VLOOKUP
d) HLOOKUP

Answer: a) MATCH.

Explanation: The MATCH function is used to return the relative position of a value within a range of cells in Excel.

38. Which function is used to return the value of a cell at a specified row and column within a range in Excel?

a) MATCH
b) INDEX
c) VLOOKUP
d) HLOOKUP

Answer: b) INDEX.

Explanation: The INDEX function is used to return the value of a cell at a specified row and column within a range in Excel.

39. Which function is used to search for a value in the first row of a range of cells and return the value in the same column from a specified row in Excel?

a) MATCH
b) INDEX
c) VLOOKUP
d) HLOOKUP

Answer: d) HLOOKUP.

Explanation: The HLOOKUP function is used to search for a value in the first row of a range of cells and return the value in the same column from a specified row in Excel.

40. Which function is used to combine the contents of two or more cells into one cell in Excel?

a) CONCATENATE
b) JOIN
c) MERGE
d) COMBINE

Answer: a) CONCATENATE.

Explanation: The CONCATENATE function is used to combine the contents of two or more cells into one cell in Excel.

41. Which function is used to split the contents of a cell into separate cells based on a specified delimiter in Excel?

a) SPLIT
b) SEPARATE
c) TEXTTOSPLIT
d) TEXTTODELIM

Answer: a) SPLIT.

Explanation: The SPLIT function is used to split the contents of a cell into separate cells based on a specified delimiter in Excel.

42. Which function is used to remove duplicate values from a range of cells in Excel?

a) DUPLICATE
b) DELETE
c) REMOVE
d) UNIQUE

Answer: d) UNIQUE.

Explanation: The UNIQUE function is used to remove duplicate values from a range of cells in Excel.

43. Which function is used to calculate the number of days between two dates in Excel?

a) DATEDIF
b) DATEVALUE
c) DAY
d) YEAR

Answer: a) DATEDIF.

Explanation: The DATEDIF function is used to calculate the number of days between two dates in Excel.

44. Which function is used to convert a text string to a date value in Excel?

a) DATEDIF
b) DATEVALUE
c) DAY
d) YEAR

Answer: b) DATEVALUE.

Explanation: The DATEVALUE function is used to convert a text string to a date value in Excel.

45. Which function is used to return the day of the month for a specified date in Excel?

a) DATEDIF
b) DATEVALUE
c) DAY
d) YEAR

Answer: c) DAY.

Explanation: The DAY function is used to return the day of the month for a specified date in Excel.

46. Which function is used to return the year for a specified date in Excel?

a) DATEDIF
b) DATEVALUE
c) DAY
d) YEAR

Answer: d) YEAR.

Explanation: The YEAR function is used to return the year for a specified date in Excel.

47. Which function is used to return the largest value in a range of cells in Excel?

a) MAX
b) MIN
c) SUM
d) AVERAGE

Answer: a) MAX.

Explanation: The MAX function is used to return the largest value in a range of cells in Excel.

48. Which function is used to return the smallest value in a range of cells in Excel?

a) MAX
b) MIN
c) SUM
d) AVERAGE

Answer: b) MIN.

Explanation: The MIN function is used to return the smallest value in a range of cells in Excel.

49. Which function is used to calculate the total of a range of cells in Excel?
a) MAX
b) MIN
c) SUM
d) AVERAGE

Answer: c) SUM.

Explanation: The SUM function is used to calculate the total of a range of cells in Excel.

50. Which function is used to count the number of cells in a range that meet a specified criteria in Excel?

a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTBLANK

Answer: c) COUNTIF.

Explanation: The COUNTIF function is used to count the number of cells in a range that meet a specified criteria in Excel.

51. Which function is used to count the number of non-blank cells in a range of cells in Excel?

a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTBLANK

Answer: b) COUNTA.

Explanation: The COUNTA function is used to count the number of non-blank cells in a range of cells in Excel.

52. Which function is used to count the number of blank cells in a range of cells in Excel?

a) COUNT
b) COUNTA
c) COUNTIF
d) COUNTBLANK

Answer: d) COUNTBLANK.

Explanation: The COUNTBLANK function is used to count the number of blank cells in a range of cells in Excel.

53. Which function is used to apply a filter to a range of cells in Excel?

a) FILTER
b) SORT
c) SEARCH
d) FIND

Answer: a) FILTER.

Explanation: The FILTER function is used to apply a filter to a range of cells in Excel.

54. Which function is used to sort a range of cells in Excel?

a) FILTER
b) SORT
c) SEARCH
d) FIND

Answer: b) SORT.

Explanation:The SORT function is used to sort a range of cells in Excel.

55. Which function is used to search for a specific character or text within a string of text in Excel?

a) FILTER
b) SORT
c) SEARCH
d) FIND

Answer: c) SEARCH.

Explanation: The SEARCH function is used to search for a specific character or text within a string of text in Excel.

56. Which function is used to find the position of a specific character or text within a string of text in Excel?

a) FILTER
b) SORT
c) SEARCH
d) FIND

Answer: d) FIND.

Explanation: The FIND function is used to find the position of a specific character or text within a string of text in Excel.

57. Which function is used to convert a number into its corresponding text format in Excel?

a) TEXT
b) VALUE
c) CONCATENATE
d) LEFT

Answer: a) TEXT.

Explanation: The TEXT function is used to convert a number into its corresponding text format in Excel.

58. Which function is used to convert text into its corresponding numeric format in Excel?

a) TEXT
b) VALUE
c) CONCATENATE
d) LEFT

Answer: b) VALUE.

Explanation: The VALUE function is used to convert text into its corresponding numeric format in Excel.

59. Which function is used to join two or more strings of text together in Excel?

a) TEXT
b) VALUE
c) CONCATENATE
d) LEFT

Answer: c) CONCATENATE.

Explanation: The CONCATENATE function is used to join two or more strings of text together in Excel.

60. Which function is used to return a specified number of characters from the beginning of a string of text in Excel?

a) TEXT
b) VALUE
c) CONCATENATE
d) LEFT

Answer: d) LEFT.

Explanation: The LEFT function is used to return a specified number of characters from the beginning of a string of text in Excel.

We hope that this article on MS Excel MCQs, available on Freshersnow, has helped you in learning about the important features and functionalities of this powerful spreadsheet software. Furthermore, with the increasing demand for data analysis and management skills in the business world, it is essential to have a solid understanding of the concepts covered in these MS Excel MCQs with Answers in order to succeed in the industry. Excel offers a wide range of tools and features, including formulas, pivot tables, charts, and macros, providing users with a versatile tool for managing and analyzing data. By mastering these concepts, professionals can improve their efficiency and productivity, making them valuable assets to any organization.