[go: up one dir, main page]
Scribd
Upload
7 views3 pages

Excel Basic Practice Tasks

The document outlines employee data including their ID, name, department, city, salary, score, and result. It provides instructions for various Excel tasks such as adding a new employee, calculating total and average salaries, sorting, filtering, and applying conditional formatting. Additionally, it includes a bonus task for converting the data range into an Excel Table and using structured references.

Uploaded by

Sanika Narvekar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
7 views3 pages

Excel Basic Practice Tasks

The document outlines employee data including their ID, name, department, city, salary, score, and result. It provides instructions for various Excel tasks such as adding a new employee, calculating total and average salaries, sorting, filtering, and applying conditional formatting. Additionally, it includes a bonus task for converting the data range into an Excel Table and using structured references.

Uploaded by

Sanika Narvekar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

EmpID Name Dept City Salary Score Result

101 Amit Sales Pune 22000 55 Pass


102 Bhavna HR Mumbai 25000 48 Fail
103 Chirag Sales Pune 27000 62 Pass
104 Deepa IT Pune 30000 40 Fail
105 Esha Finance Delhi 26000 73 Pass
106 Farhan IT Pune 28000 51 Pass
107 Gauri HR Mumbai 24000 67 Pass
108 Harsh Sales Pune 32000 59 Pass
Instructions
READ ME - Excel Practice Tasks

Instructions: Use data on Sheet1 (Employees) to perform the following live-interview style tasks.

Task 1: Add a new employee row (EmpID 109, Name=Isha, Dept=IT, City=Pune, Salary=29000, Score=64).
Task 2: Calculate Total Salary at bottom using =SUM().
Task 3: Calculate Average Salary overall and by Department (hint: AVERAGE, AVERAGEIF).
Task 4: In a new column (Result), show Pass if Score >=50 else Fail using IF.
Task 5: Sort data by Salary (Largest to Smallest).
Task 6: Filter to show only City = Pune.
Task 7: Apply Conditional Formatting to highlight Salary > 25000.
Task 8: Insert a Pie Chart showing % employees by Dept.
Task 9: Create a Data Validation drop-down for Dept values referencing a unique Dept list.
Task10: Add 10% bonus column (Salary*10%) & copy formula down.

Bonus: Convert range to an Excel Table (Ctrl+T) and try structured references.
Dept AvgSalary
Finance 26000
HR 24500
IT 29000
Sales 27000

You might also like