• Practice
  • About 13 min
  • 5 practice questions

Sorting, filtering, charts and data tools

Choose between sort, filter and chart types, and answer questions on the order and meaning of results.

If something looks wrong, please tell us.

Spreadsheets are also used to organise and show data. Questions here are about choosing the right tool for the job.

Sorting and filtering

  • Sort rearranges rows in ascending (smallest to largest, A to Z) or descending order.
  • Filter hides rows that do not meet a condition, without deleting them.
  • Find and Replace locate and change values in the sheet.

Chart types

Which chart?
ChartBest for
Column or barComparing values across categories
LineShowing change over time
PieShowing parts of a whole
ScatterShowing the relationship between two numbers

Worked examples

Example 1. Marks are 72, 45, 90 and 61. Sort in descending order. Largest first: 90, 72, 61, 45.

Example 2. A shop wants to show how its monthly sales changed over twelve months. Which chart? A line chart, because it shows change over time. To show each product's share of total sales, a pie chart would be better.

Sort rearranges, filter hides. Line = time, pie = parts of a whole, column = comparison.

— Rule to remember

Key takeaways: sort arranges, filter hides, and the chart type must suit the story in the data.

Check your understanding

  1. 1. Which tool shows only the rows that meet a condition and hides the others?

    1. Sort
    2. Filter
    3. Find
    4. Merge
    Show answer

    Answer: B. A filter hides rows that do not meet the condition without deleting them. Sort only changes the order.

  2. 2. A shop wants to show how its monthly sales changed over twelve months. Which chart is best?

    1. Pie chart
    2. Line chart
    3. Scatter chart
    4. Doughnut chart
    Show answer

    Answer: B. A line chart shows change over time. Pie and doughnut charts show parts of a whole; a scatter chart relates two numbers.

  3. 3. Marks 38, 91, 64 and 70 are sorted in descending order. What is the result?

    1. 38, 64, 70, 91
    2. 91, 64, 70, 38
    3. 91, 70, 64, 38
    4. 38, 91, 64, 70
    Show answer

    Answer: C. Descending means largest to smallest: 91, 70, 64, 38.

  4. 4. Which chart is best for comparing the marks of five students?

    1. Line chart
    2. Column chart
    3. Pie chart
    4. Scatter chart
    Show answer

    Answer: B. Column (or bar) charts compare values across separate categories, here the students.

  5. 5. What do Find and Replace do in a spreadsheet?

    1. Hide rows that do not match
    2. Locate values and change them
    3. Put rows in ascending order
    4. Turn data into a chart
    Show answer

    Answer: B. Find locates a value and Replace changes it. Hiding rows is filtering and ordering rows is sorting.

Sign in to keep track of the lessons you finish.

Next lesson → Spreadsheets mixed practice

Privacy · Terms · Refunds · Delivery