• Foundation
  • About 13 min
  • 5 practice questions

Sorting, filtering and charts

Sort and filter a data list and pick a suitable chart for the story the numbers tell.

If something looks wrong, please tell us.

Once data is entered, you often need to arrange it, search through it and show it as a picture. Sorting, filtering and charts do these jobs.

Sorting

Sorting rearranges rows in order: ascending (A to Z, smallest to largest) or descending (Z to A, largest to smallest). When sorting, include all columns so each row stays together.

Filtering

Filtering hides rows that do not match a condition and shows only the ones you want, for example marks above 60. The hidden data is not deleted.

Charts

Choosing a chart
ChartBest for
Column / barComparing values between categories
LineShowing change over time
PieShowing parts of a whole
ScatterShowing how two measures relate

Worked examples

Example 1. Marks are 72, 55, 90, 63. Sorted descending they read 90, 72, 63, 55.

Example 2. Filter for marks above 60 from the same list. The rows with 72, 90 and 63 stay visible; 55 is hidden.

Example 3. Which chart suits monthly sales over a year? A line chart, because it shows change over time.

Example 4. Which chart shows the share of a family budget spent on food, rent and travel? A pie chart, since the parts make a whole.

Sort = reorder, Filter = show matching rows only, Pie = parts of a whole, Line = trend over time.

— Remember

Key takeaways

  • Sorting orders rows; filtering hides the rest.
  • Choose the chart by what you want to show.
  • Select the whole table before sorting.

Check your understanding

  1. 1. Marks 7, 3, 9 and 1 are sorted in descending order. What is the result?

    1. 1, 3, 7, 9
    2. 9, 7, 3, 1
    3. 7, 3, 9, 1
    4. 9, 3, 7, 1
    Show answer

    Answer: B. Descending means largest to smallest: 9, 7, 3, 1.

  2. 2. A filter is set to show marks above 60. What happens to the rows with lower marks?

    1. They are deleted permanently
    2. They are hidden but not deleted
    3. They are moved to a new worksheet
    4. They are sorted to the bottom of the list
    Show answer

    Answer: B. Filtering only hides rows that do not match the condition; the data is still there.

  3. 3. Which chart best shows the share of a family budget spent on food, rent and travel?

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

    Answer: C. A pie chart shows parts of a whole, such as each item's share of a budget.

  4. 4. Which chart best shows how the height of each student relates to the student's weight?

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

    Answer: B. A scatter chart shows how two measures relate to each other.

  5. 5. Why should all the columns of a table be selected before sorting it?

    1. So each row's data stays together
    2. So the sort runs faster
    3. So blank columns are deleted
    4. So a chart is created
    Show answer

    Answer: A. If only one column is sorted, its values move while the rest stay, and each name no longer matches its own marks.

Privacy · Terms · Refunds · Delivery