⏱️ Exercise 1: Basic Data Entry (Time Limit: 5 Minutes)

? Task:

Create the following table using keyboard only:

? Rules:

• Use Tab / Enter for navigation
• Avoid mouse

? Skills Tested:

✔ Typing speed
✔ Navigation

⚡ Exercise 2: Formatting Speed (Time Limit: 5 Minutes)

? Task:

• Bold header → Ctrl + B
• Apply borders
• Center text
• Adjust column width

? Skills Tested:

✔ Formatting shortcuts
✔ Speed accuracy

? Exercise 3: Formula Speed (Time Limit: 5 Minutes)

? Task:

• Calculate total:

=SUM(C2:C5)

• Calculate average:

=AVERAGE(C2:C5)

? Skills Tested:

✔ Formula writing
✔ AutoSum (Alt + =)

? Exercise 4: AutoFill Practice (Time Limit: 3 Minutes)

? Task:

• Enter:

1
2

• Use AutoFill to complete up to 20

? Skills Tested:

✔ AutoFill speed

? Exercise 5: Find & Replace (Time Limit: 3 Minutes)

? Task:

• Replace ICT → Computer Science

Use:

• Ctrl + H

? Skills Tested:

✔ Quick editing

? Exercise 6: Sorting & Filtering (Time Limit: 5 Minutes)

? Task:

• Sort marks (highest to lowest)
• Apply filter → show marks > 80

? Skills Tested:

✔ Data handling

? Exercise 7: Conditional Formatting (Time Limit: 5 Minutes)

? Task:

• Highlight marks ≥ 80 → Green
• Highlight marks < 50 → Red

? Skills Tested:

✔ Visual formatting

? Exercise 8: Chart Creation (Time Limit: 5 Minutes)

? Task:

• Create column chart for marks
• Add title

? Skills Tested:

✔ Quick visualization

? Exercise 9: Advanced Shortcut Challenge (Time Limit: 5 Minutes)

? Task:

Perform using shortcuts only:

• Select entire table → Ctrl + A
• Copy → Ctrl + C
• Paste → Ctrl + V
• Create table → Ctrl + T
• Apply filter → Ctrl + Shift + L

? Skills Tested:

✔ Shortcut mastery

? Final Speed Challenge (10 Minutes)

? Task:

Create a complete sheet:

✅ Enter data
✅ Format table
✅ Apply formulas
✅ Apply conditional formatting
✅ Create chart

? Performance Evaluation

? Best Practice Tips

✅ Do’s

• Practice daily
• Focus on accuracy first, then speed
• Use shortcuts regularly

❌ Don’ts

• Do not rush without understanding
• Avoid relying only on mouse
• Avoid skipping practice

?‍? Instructor Guidelines

• Set timer for each exercise
• Observe student performance
• Encourage competition
• Provide feedback

? Conclusion

These exercises help students become fast, efficient, and confident Excel users, ready for academic and professional tasks.