Common functions (SUM, AVERAGE, MIN, MAX, COUNT) – Excel MCQs

  1. Which function in Excel is used to add a range of cells? a) AVERAGE b) SUM c) COUNT d) MIN Answer: b) SUM
  2. Which Excel function returns the smallest value in a set of values? a) MAX b) AVERAGE c) MIN d) COUNT Answer: c) MIN
  3. What does the COUNT function in Excel do? a) Counts the number of cells that contain numbers. b) Counts the number of all cells. c) Counts the number of empty cells. d) Counts the number of cells that contain text. Answer: a) Counts the number of cells that contain numbers.
  4. Which function in Excel is used to calculate the average of a group of numbers? a) SUM b) MAX c) MIN d) AVERAGE Answer: d) AVERAGE
  5. Which Excel function returns the largest value in a set of values? a) SUM b) MAX c) MIN d) COUNT Answer: b) MAX
  6. To find the total of a range of cells in Excel, you would use: a) AVERAGE b) COUNT c) SUM d) MIN Answer: c) SUM
  7. If you want to count the number of cells in a range that are not empty, which function would you use? a) COUNT b) COUNTA c) COUNTBLANK d) COUNTIF Answer: b) COUNTA
  8. Which function would you use to determine the highest score in a list of test results? a) MIN b) AVERAGE c) MAX d) SUM Answer: c) MAX
  9. To find the average of the values in cells A1 through A10, you would use: a) =SUM(A1) b) =AVERAGE(A1) c) =MIN(A1) d) =MAX(A1) Answer: b) =AVERAGE(A1)
  10. Which function can be used to count the number of numeric entries in a range? a) COUNT b) SUM c) AVERAGE d) MIN Answer: a) COUNT

Related Posts:

All Copyrights Reserved 2025 Reserved by T4Tutorials