MS Excel MCQs and Answers
MS Excel MCQs and
Answers
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.
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.
Post a Comment