Learn Excel EasyDaily One Lesson

Quiz › Formulas & Functions › MAX, MIN, LARGE, SMALL

MAX, MIN, LARGE, SMALL: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. A1:A5 has 40, 10, 90, 70, 30. What will this formula return?
    =MAX(A1:A5)
    • A. 40
    • B. 30
    • C. 240
    • D. 90
    Show the answerD — 90. MAX picks the largest: 90.
  2. A1:A5 has 40, 10, 90, 70, 30. What will this formula return?
    =MIN(A1:A5)
    • A. 30
    • B. 10
    • C. 5
    • D. 40
    Show the answerB — 10. MIN picks the smallest: 10.
  3. A1:A5 has 40, 10, 90, 70, 30. What will this formula return?
    =LARGE(A1:A5,2)
    • A. 40
    • B. 10
    • C. 90
    • D. 70
    Show the answerD — 70. LARGE with 2 gives the second largest: 70.
  4. A1:A5 has 40, 10, 90, 70, 30. What will this formula return?
    =SMALL(A1:A5,2)
    • A. 40
    • B. 30
    • C. 10
    • D. 70
    Show the answerB — 30. SMALL with 2 gives the second smallest: 30.
  5. A1:A5 has 40, 10, 90, 70, 30. What will this formula return?
    =MAX(A1:A5)-MIN(A1:A5)
    • A. 80
    • B. 90
    • C. 60
    • D. 100
    Show the answerA — 80. 90 minus 10 is 80.

Want to learn this? Read the Formulas & Functions lessons →
← More Formulas & Functions topics · All quiz categories