Scribd
Upload
52 views5 pages

Test

This document contains an employee data table with columns for employee ID, name, monthly salary, and department. It asks 5 questions: 1. Summarize the total monthly salaries and employee counts by department. 2. Summarize the same metrics but only including salaries under $2500. 3. Split the employee full names into separate first and last name columns. 4. Extract the 4-digit numeric ID from the employee IDs. 5. Add a "Grade D" label to employees in Payroll or IT departments earning over $2500. The summary provides a high-level overview of the key details and questions asked in the document in 3 sentences. It does not include

Uploaded by

Vinay Bansal
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
52 views5 pages

Test

This document contains an employee data table with columns for employee ID, name, monthly salary, and department. It asks 5 questions: 1. Summarize the total monthly salaries and employee counts by department. 2. Summarize the same metrics but only including salaries under $2500. 3. Split the employee full names into separate first and last name columns. 4. Extract the 4-digit numeric ID from the employee IDs. 5. Add a "Grade D" label to employees in Payroll or IT departments earning over $2500. The summary provides a high-level overview of the key details and questions asked in the document in 3 sentences. It does not include

Uploaded by

Vinay Bansal
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

ID First and last Name Monthly Salary Departement First name Last name Numeric ID

df(2546) Jack pierre 1800 Payroll


ghg(1284) Paul denis 1300 IT
(5649) Math diamon 2000 Workforce
(1254) Von antonio 1900 Operations
gh(1279) kan beron 2000 Payroll
(1323) kant bernard 2100 Payroll
(1348) paul terrien 2200 IT
gh(1392) fan liam 2300 IT
(1417) dany kom 2400 Operations
gh(1461) fanny man 2500 Operations
(1486) john mam 2600 Payroll
j(1530) jeff dart 2700 Payroll
(1555) barry tony 2800 Workforce
d(1599) Charo khan 2900 Workforce
aa(1624) khoda gawar 3000 Payroll
aa(1668) mahapat raj 1500 Operations
(1693) raj komar 3200 Payroll
ju(1737) komar delhi 3300 IT
(1762) sam dali 2500 Operations
j(1806) navpreet mahraj 1700 Operations
Grade

Departement Total Monthly Salary


Payroll 5900
IT
Workforce
Operations
Total Employes
1- sum of salaries per department and count of employees?

Departement Total Monthly Salary


Payroll 17400
IT 9100
Workforce 7700
Operations 12500

2- sum of salaries per department and count of employees if the salary is less than 2500?

Departement Total Monthly Salary


Payroll
IT
Workforce
Operations

Move now to the data tab answer the below questions

3- in the same table in data tab split the full name to first and last name in column E and F?
4- Extract the numeric ID to column G from Column A (just 4 didgits) in data tab ?
5- In the H column add the word "Grade D" if the salary is more than 2500 and if the department is Payroll or IT?
Total Employes
7
4
3
6

00?

Total Employes

nd F?

department is Payroll or IT?

You might also like