Excel Assignment 3
Functions and Conditional Formatting
Create the table below in Excel and respond to the provided questions.
Employee ID Name Department Salary
1 Nuwan Sales 50000
2 Sandali HR 45000
3 Malith IT 60000
4 Nadeesha Sales 55000
5 Tharindu IT 62000
6 Ishara HR 47000
7 Sampath Sales 48000
8 Dinesh IT 58000
9 Thilini HR 49000
10 Chamara Sales 51000
Type your function here
Calculate the total number of employees in the Sales department
Find the average salary of employees in the HR department.
Determine the total salary of employees whose salary is greater than 50000
Count the number of employees with a salary less than or equal to 48000
Calculate the average salary of employees whose names start with the letter 'N'
Find the sum of salaries for employees in the IT department.
Count the number of employees whose salary is exactly 55000
Determine the total salary of employees in the Sales department.
Calculate the average salary of employees with an ID greater than 5.
Find the sum of salaries for employees whose names end with the letter 'a'
Conditional Formatting
Fill the cell color with red for salaries above 55000
Fill the cell color with orange for salaries below 47000
MS-EXCEL Assignment 3
LPEC
Mr. Hasala Sithum
