[go: up one dir, main page]
Scribd
Upload
2K views6 pages

Sample Employee Data

This document contains an employee data sheet with columns for name, joining date, email address, department, monthly salary, and job status. The task is to fill in the missing data by generating emails based on names, selecting departments from a reference table, looking up salaries based on department, and marking employees as permanent if they joined over 180 days ago. Formulas and data validation will be used to automatically populate the fields.

Uploaded by

Vignesh Veeramani
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
2K views6 pages

Sample Employee Data

This document contains an employee data sheet with columns for name, joining date, email address, department, monthly salary, and job status. The task is to fill in the missing data by generating emails based on names, selecting departments from a reference table, looking up salaries based on department, and marking employees as permanent if they joined over 180 days ago. Formulas and data validation will be used to automatically populate the fields.

Uploaded by

Vignesh Veeramani
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/ 6

Sample Excel File with Employee Data for Practice

Name Joining Date Email Address Department Monthly Salary


Mark 31-Dec-21
Brian 31-Dec-21
Alan 14-Jan-22
Tony 14-Jan-22
Agatha 01-Feb-22
Lana 01-Feb-22
Heather 04-Aug-22
Ben 04-Aug-22
Caitlyn 01-Mar-22
Gibbs 01-Mar-22
Anderson 01-Mar-22
Michael 01-Mar-22
David 15-Mar-22
Jacob 15-Mar-22
John 01-Apr-22
Leonardo 01-Apr-22
Matthew 17-Apr-22
Joana 01-Jun-22
Ross 02-Jul-22
Joey 15-Jul-22
Jack 03-Jan-22

Today's Date
29-Aug-22
ce

Job Status

Objectives
Your task is to fill the data of the four columns -

1. Email Address - Fill the email addresses that have the same dom
"@demomail.com". The format will be "Name@demomail.com". T
need to know how to join two strings in Excel.
2. Department - You will need to create a Data Validation in this co
feature helps us to restrict data entry. The source for Data Validati
"Reference Table" Sheet (Range B5:B11).
3. Salary - There is a Lookup Table in the "Reference Table" Sheet.
to match the department name and return the monthly salary in t
any lookup function to do so.

4. Job Status - If an employee joined more than 180 days ago, then
a permanent employee of the company. You need to use condition
s-

at have the same domain of


e@demomail.com". To solve this you
.
a Validation in this column. This Excel
urce for Data Validation is on the

erence Table" Sheet. Your task will be


e monthly salary in that. You can use

an 180 days ago, then he or she will be


need to use conditionals to solve this.
Salary Structure

Department Salary
Human Resources $5,830
Sales $3,450
Legal $4,920
Retail $2,785
Accounting $3,125
Support $2,500
Business Development $3,100
Sample Excel File with Employee Data for Practice

Name Joining Date Email Address Department


Mark 31-Dec-21 Mark@demomail.com Human Resources
Brian 31-Dec-21 Brian@demomail.com Sales
Alan 14-Jan-22 Alan@demomail.com Legal
Tony 14-Jan-22 Tony@demomail.com Retail
Agatha 01-Feb-22 Agatha@demomail.com Sales
Lana 01-Feb-22 Lana@demomail.com Accounting
Heather 04-Aug-22 Heather@demomail.com Accounting
Ben 04-Aug-22 Ben@demomail.com Sales
Caitlyn 01-Mar-22 Caitlyn@demomail.com Retail
Gibbs 01-Mar-22 Gibbs@demomail.com Retail
Anderson 01-Mar-22 Anderson@demomail.com Sales
Michael 01-Mar-22 Michael@demomail.com Retail
David 15-Mar-22 David@demomail.com Sales
Jacob 15-Mar-22 Jacob@demomail.com Support
John 01-Apr-22 John@demomail.com Business Development
Leonardo 01-Apr-22 Leonardo@demomail.com Business Development
Matthew 17-Apr-22 Matthew@demomail.com Human Resources
Joana 01-Jun-22 Joana@demomail.com Business Development
Ross 02-Jul-22 Ross@demomail.com Legal
Joey 15-Jul-22 Joey@demomail.com Business Development
Jack 03-Jan-22 Jack@demomail.com Support

Today's Date
29-Aug-22
Data for Practice

Monthly Salary Job Status


$5,830 Permanent
$3,450 Permanent
$4,920 Permanent
$2,785 Permanent
$3,450 Permanent
$3,125 Permanent
$3,125
$3,450
$2,785 Permanent
$2,785 Permanent
$3,450 Permanent
$2,785 Permanent
$3,450
$2,500
$3,100
$3,100
$5,830
$3,100
$4,920
$3,100
$2,500 Permanent

You might also like