You are developing a worksheet to analyze employee data for an environmentally-friendly grocery supplies company. Bonuses are paid to employees based on the results of their performance evaluations, while parking fees are charged to the employees based o

User Generated

Greelu1997

Writing

Description

Starting File: Project 5 – Student – GreenGrocers.xlsx
You are developing a worksheet to analyze employee data for an environmentally-friendly grocery supplies company. Bonuses are paid to employees based on the results of their performance evaluations, while parking fees are charged to the employees based on their base salary. Follow the steps to produce the results shown in Figure 1 at the end of this document.
Notes:
This workbook has 4 worksheets: the Documentation worksheet (for the history of this workbook), the EmpData worksheet with employee details, the Reference worksheet with reference tables, and the Analysis worksheet for summary information. Be sure to work on the correct worksheet as indicated in the instructions.
You should use cell references, table column names, and/or defined names in all formulas – do not re-enter data. Use absolute cell references where appropriate.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

GreenGrocers - Salary Data
Author:
Creation Date:

Purpose:

Data
Terry
22/03/2019

This worksheet's purpose is to analyze employee data for a grocery supplies company.

sp19

GreenGrocers - Salary Data
Emp ID

Terry

396399
736552
213157
395636
331485
397926
411058
514244
570001
254488
283415
400978
325947
368341
400215
402504
474062
679934
570001
340616
355433
419293
417767
418530
417004
416240
415477
414714
413951
413188
401741

Emp Last Name
Alderson
Allman
Alvarez
Andrews
Artenson
Barker
Barker
Bridgewater
Camacho
salas
Charmette
Del Rio
Dos Santos
Estez
Fisher
Flores
Fouche
Garcia
Garmen
Gaudette
Gilman
Glaser
Gonzalez
Gonzalez
Hawkins
Jacques
Lopez
Louis
Macias
Martine
McMillan

Emp First Name
Connie
Carla
Julia
Sandra
Robert
Marguerite
Shondra
Marta
Felix
Diana
Alvin
Clarissa
Isidro
Ashlin
Jared
Valeria
Carlos
Samantha
Katherine
Shara
Marlene
Sheral
Maria
Richard
Michelle
Savanah
Ronaldo
Daniel
Stephanie
Andrea
Marie

Job Code
E425
E...


Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags