20.2

Topic 20

Manipulate data

  • IGCSE I.C.T 0417
  • 1 min read
  • Syllabus 2026, 2027 and 2028

Objectives

  1. 1

    Sort data

    • aUsing a single criterion, or multiple criteria sort data into ascending or descending order
  2. 2

    Search and select data

    • aUsing a single criterion, or multiple criteria, select subsets of data
    • bPerform searches using a variety of operators including AND, OR, NOT, >, <, =, >=, <=, <>
    • cPerform searches using wildcards

Cambridge IGCSE ICT 0417 syllabus 2026-2028, 20.2 Manipulate data (copied for internal use as permitted by Cambridge)

Detailed · Deep study

1Sorting and searching

  • Select all the data (including every column), so that rows stay together when sorting.
  • Sort on a single criterion (e.g. Surname A–Z) or multiple criteria (e.g. Form, then Surname).
  • Use a filter (autofilter or advanced filter) to show only rows that meet the criteria; hidden rows are not deleted.
CriterionShows rows where…
>100the value is more than 100
<>"Kenya"the value is anything except Kenya
>=10 AND <=20the value is from 10 to 20
"A" OR "B"the value is A or B
K*the text starts with K (* = any characters)
?atthree letters ending in "at" (? = one character)

2Exam focus

Key words: sort; ascending; descending; filter; criteria; wildcard.

Quick self-check

Answer in your head first, then reveal.

  1. So that each row stays together and data is not mismatched (1).

  2. >=5 AND <=10 (2).

Finished this subtopic? Track it on your subject page.