Excel Practice Assignment – Employee Sales Data
🧮 Basic Formula Questions
1. Find the total Sales for all employees.
2. Find the highest Sales value in the dataset.
3. Find the lowest Sales value recorded.
4. Find the total number of employees listed.
5. Count how many rows have numeric Sales values.
6. Find the average Sales value.
📊 Sorting, Flash Fill, and Cleaning
7. Sort the data by Department (A–Z) and then by Sales (Largest to Smallest).
8. Use Flash Fill to create a new column that contains only the first name initials of
employees.
9. Use Flash Fill to extract Month abbreviations into a new column.
10. Remove duplicates where both Employee and Month are the same.
⚙️Logical & Conditional Functions
11. Create a new column named “Performance” showing “Excellent” if Sales ≥ Target,
otherwise “Needs Improvement.”
12. Count how many employees achieved their target.
13. Find total Sales where Status is “Achieved.”
14. Find the average Sales of employees who achieved their target.
15. Count how many employees belong to the IT department.
💰 Combination & Advanced Practice
16. Calculate total Bonus given to Sales department employees only.
17. Create a column showing “Bonus Applicable” if Status = “Achieved” else “No Bonus.”
18. Find the average Sales of HR department employees who achieved their target.
19. Create a new column to show how much each employee exceeded or fell short of their
Target.
20. Highlight cells using Conditional Formatting where Sales are greater than 55,000.
