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: