Computer science · University
Cleaning and validation · revision notes
Reordering rows according to selected values while preserving row relationships.
Key ideas and conditions
Sort
Reordering rows according to selected values while preserving row relationships.
Filter
Temporarily showing only rows meeting stated criteria.
Data validation
Rules restricting or checking allowed cell entries.
Duplicate
A repeated record that may be legitimate or an error depending on context.
Explain without looking
- Give a short example showing how Data validation would be used in practice.
- Summarize why Duplicate matters in the lesson “Cleaning and validation”.
Further reading and review references
These are reference links, not copied exercises, institutional endorsement or proof of independent review.
AI-assisted preview; independent educational review required. Level labels describe prerequisites, not accreditation or official curriculum alignment.