[go: up one dir, main page]
Scribd
Upload
20 views5 pages

SUMIF Function Practice Sheet 1

The document lists employee details including department, first name, last name, and salary. It includes various departments such as HR, Accounts, Marketing, and Sales, with salaries ranging from 18,000.00 to 120,000.00. Additionally, it mentions the use of SUM and IF functions to calculate salary expenses for each department.

Uploaded by

SAMRAT CHOWDHURY
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
20 views5 pages

SUMIF Function Practice Sheet 1

The document lists employee details including department, first name, last name, and salary. It includes various departments such as HR, Accounts, Marketing, and Sales, with salaries ranging from 18,000.00 to 120,000.00. Additionally, it mentions the use of SUM and IF functions to calculate salary expenses for each department.

Uploaded by

SAMRAT CHOWDHURY
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/ 5

Department First Name Last Name Salary

HR Aaradhya Gupta 20,000.00


Accounts Mishka Singh 30,000.00
Marketing Vivaan Singla 35,000.00
Sales Taarush Mehta 25,000.00
Accounts Saisha Jain 50,000.00
HR Mirai Rai 52,000.00
Sales Mohammad Asif 35,000.00
Sales Alisha Jain 22,000.00
Accounts Prisha Sharma 18,000.00
HR Ananya Verma 30,000.00
Marketing Zuber Ahmed 32,000.00
Sales Ranbir Singh 28,000.00
Accounts Naksh Assi 36,000.00
HR Atiksh Khan 41,000.00
Marketing Kabir Khan 39,000.00
Sales Anant Jain 28,000.00
Sales Laksh Singh 32,000.00
Sales Rohan Kumar 32,000.00
Sales Nirav Modi 28,000.00
Marketing Taarush Gupta 56,000.00
Accounts John Smith 66,000.00
HR Emily Johnson 59,000.00
Sales Michael Brown 65,000.00
Accounts Sarah Davis 48,000.00
Sales William Wilson 36,000.00
Accounts Olivia Lee 28,000.00
HR James White 36,000.00
Sales Sophia Martin 33,000.00
Accounts David Harris 48,000.00
HR Emma Clark 39,000.00
Sales Benjamin Turner 44,000.00
Accounts Emma Anderson 36,000.00
HR William Walker 26,000.00
Sales Charlotte Hall 51,000.00
Accounts Oliver Baker 37,000.00
Sales Sophia Turner 42,000.00
Sales Samuel Moore 39,000.00
Accounts Ava Taylor 21,000.00
HR Alexander Robinson 36,000.00
Marketing Ella Davis 52,000.00
Sales Liam Johnson 36,000.00
Marketing Mia Williams 40,000.00
Sales Ethan Jackson 50,000.00
Marketing Harper Thomas 60,000.00
HR Noah Harris 100,000.00
Marketing Amelia Lewis 120,000.00
Accounts Benjamin Adams 38,000.00
HR Sofia Mitchell 36,000.00
Marketing Logan Scott 49,000.00
Sales Ava Martinez 67,000.00
Designed By

Department SUM
HR USE SUM IF FUNCTION T
Accounts
Marketing
Sales
M IF FUNCTION TO DETERMINE SALARY EXPENSE FOR EVERY DEPARTMENT
NT

You might also like