Learn Excel EasyDaily One Lesson

Quiz › Sorting, Filtering & Lists › Sort and filter

Sort and filter: Excel Quiz

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

  1. Column A has 30, 5, 100, 12. You sort Smallest to Largest. What is in the first cell?
    • A. 12
    • B. 30
    • C. 100
    • D. 5
    Show the answerD — 5. Smallest to Largest puts 5 first, then 12, 30, 100.
  2. Column A has Mango, apple, Banana. You sort A to Z. Which comes first?
    • A. apple
    • B. Mango
    • C. Banana
    Show the answerA — apple. Sorting ignores capital letters. apple, Banana, Mango.
  3. A list has 100 rows. You filter it to show only Delhi (20 rows). How many rows are deleted?
    • A. 0
    • B. 80
    • C. 100
    • D. 20
    Show the answerA — 0. A filter only hides rows. Nothing is deleted.
  4. A2:A6 has 10, 20, 30, 40, 50. A filter shows only 10 and 50. What will this formula return?
    =SUM(A2:A6)
    • A. 90
    • B. 0
    • C. 60
    • D. 150
    Show the answerD — 150. SUM adds hidden rows too: 150.
  5. A2:A6 has 10, 20, 30, 40, 50. A filter shows only 10 and 50. What will this formula return?
    =SUBTOTAL(109,A2:A6)
    • A. 60
    • B. 2
    • C. 90
    • D. 150
    Show the answerA — 60. SUBTOTAL adds only the rows you can see: 10+50 is 60.

Want to learn this? Read the Sorting, Filtering & Lists lessons →
← More Sorting, Filtering & Lists topics · All quiz categories