# Cleaning and validation

> Reordering rows according to selected values while preserving row relationships.

Course: [Spreadsheet skills](https://studybrix.com/en/courses/spreadsheets/index.md)
Level: university
Prerequisites: Basic arithmetic and computer literacy.

## Notes

### 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.

## Practice questions

### 1. Which term best matches this description: Reordering rows according to selected values while preserving row relationships.

A. Sort
B. Data validation
C. Filter
D. Duplicate

Answer: Sort

Explanation: Sort is the matching concept in this lesson.

### 2. Which term best matches this description: Temporarily showing only rows meeting stated criteria.

A. Sort
B. Filter
C. Duplicate
D. Data validation

Answer: Filter

Explanation: Filter is the matching concept in this lesson.

### 3. Which concept would you apply first in a situation where rules restricting or checking allowed cell entries.

A. Sort
B. Duplicate
C. Data validation
D. Filter

Answer: Data validation

Explanation: The scenario directly calls for Data validation.

### 4. Name the concept described as: A repeated record that may be legitimate or an error depending on context.

Answer: Duplicate

Explanation: The intended concept is Duplicate.

### 5. Which statement about Sort is most accurate?

A. Reordering rows according to selected values while preserving row relationships.
B. A repeated record that may be legitimate or an error depending on context.
C. Rules restricting or checking allowed cell entries.
D. Temporarily showing only rows meeting stated criteria.

Answer: Reordering rows according to selected values while preserving row relationships.

Explanation: The definition in the lesson notes gives the required condition.

### 6. Explain one important difference between Sort and Filter.

Sample answer / marking guidance: Sort: Reordering rows according to selected values while preserving row relationships. Filter: Temporarily showing only rows meeting stated criteria.

Explanation: Credit a clear distinction using both definitions and an appropriate example if supplied.

### 7. Give a short example showing how Data validation would be used in practice.

Sample answer / marking guidance: A valid example should demonstrate this idea: Rules restricting or checking allowed cell entries.

Explanation: Credit a relevant scenario that applies the concept rather than merely naming it.

### 8. Summarize why Duplicate matters in the lesson “Cleaning and validation”.

Sample answer / marking guidance: Duplicate matters because A repeated record that may be legitimate or an error depending on context.

Explanation: Credit the core purpose, scope and any important limitation from the notes.

## Further reading

- https://support.microsoft.com/excel

Original AI-assisted educational draft; not independently teacher-reviewed. References support further study, not copied exercises, affiliation or curriculum accreditation.