Kids Excel 2 – Assignment

Assignment Instructions

1. Remove Duplicates

Check if any student record is repeated and remove duplicates using the Remove Duplicates tool.

2. Standardise Gender

Replace “M” with “Male” and “F” with “Female” using Find & Replace.

3. Sort Data

Sort students by Age in ascending order.

4. Filter Data

Apply a filter to show only Female students above 18 years old.

5. Conditional Formatting

Highlight any subject score below 70 in red.

Highlight top scores in each subject in green.

6. Formulas

Add a new column Total = SUM(Maths, English, Science).

Add a new column Average = AVERAGE(Maths, English, Science).