File Name
Review_Tab_Practice.xlsx
Employee Salary Sheet
|
Employee ID |
Employee Name |
Department |
Basic Salary |
HRA |
Total Salary |
|
EMP001 |
Amit Kumar |
IT |
35000 |
5000 |
|
|
EMP002 |
Neha Sharma |
HR |
42000 |
6000 |
|
|
EMP003 |
Rahul Singh |
Sales |
40000 |
5500 |
|
|
EMP004 |
Priya Gupta |
Finance |
48000 |
7000 |
|
|
EMP005 |
Simran Kaur |
Marketing |
32000 |
4500 |
Tasks
Task 1 — Spelling
Intentionally add some spelling mistakes to the worksheet and check them using:
Review → Spelling / F7
Task 2 — Accessibility
Go to:
Review → Check Accessibility
Review the issues that appear.
Task 3 — Comments
Add review comments to at least 3 cells.
Task 4 — Notes
Add useful Notes to the Salary and Employee ID cells.
Task 5 — Formula
Total Salary:
=D2+E2
Task 6 — Allow Users to Edit Ranges
Keep these editable:
- Employee Name
- Department
- Basic Salary
- HRA
Protect:
- Total Salary
Task 7 — Protect Sheet
Protect the worksheet with a password.
Task 8 — Protect Workbook
Protect the workbook structure.
Task 9 — Collaboration & Review
Create a review workflow:
Employee Entry → Manager Review → Correction → Final Approval
Final Challenge
Create a Professional Protected Employee Workbook containing:
- Spelling check
- Accessibility check
- Comments
- Notes
- Editable input cells
- Protected formula cells
- Protected worksheet
- Protected workbook structure
- Language tools exploration
- Review/collaboration workflow
Final Structure
Input Area → Formula Area → Review → Protection → Final Report