| Join Telegram |  |
| Join Whatsapp Groups |  |
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.