Description
There are 2 files word file is the instruction and excel file is where all work is done. All the instruction provided in the word should be done in excel. the excel file should be saved as mentioned in instruction. overall, everything should be exactly what the instruction file is asking you to do.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached is the complete solution.I have attached the same file by zip folder also (in case needed.)
Author:
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from t
SAM website.
New Perspectives Excel 2016 | Module 8: SAM Project 1a
Camp Bright Firewood
WORKING WITH ADVANCED FUNCTIONS
Anuja Kattel
edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the
SAM website.
Staff ID
1103
1055
1056
1035
1094
1066
1050
1054
1070
1040
1010
1073
1069
1060
1043
1034
1084
1078
1036
1074
1076
1009
1089
1022
1033
1065
1087
1048
1053
1064
Name
Adam Moriarty
Artie Jimenez
Bo Peterson
Claire Hunter
Eileen Randall
Flossie Frampton
Grace Richards
Hayley Jin
Hiro Marumi
Isaac Runyon
Isabella Thorne
James Gutierrez
Joey Stockton
Julio deSouza
Kira Weston
Liam Swanson
Maria Flatley
Melinda Masterson
Oscar Alberts
Philip Jones
Richard Tepper
Robert Miller
Sarah Winters
Sienna Shapiro
Stephanie Ito
Stephen McAllister
Sylvia Lee
Tanya Oldman
Tristan Reinholt
Walter Kaminsky
Age
Service Years
18
28
24
35
18
23
30
25
23
33
42
22
23
24
32
35
19
20
33
22
21
44
19
38
35
23
20
30
25
23
Base Salary
1
9
7
10
1
0
5
8
4
8
25
3
0
7
4
18
1
2
16
5
4
25
2
16
17
6
3
13
8
6
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
15,50
18,50
18,50
18,50
15,50
15,00
17,50
18,50
16,75
18,50
18,50
16,75
15,00
18,50
16,75
18,50
15,50
16,75
18,50
17,50
16,75
18,50
16,75
18,50
18,50
17,50
16,75
18,50
18,50
17,50
First Aid Certification Year
2017
2015
2013
2016
2013
2016
2017
2013
2013
2016
2017
2014
2015
2013
2015
2016
2017
2017
2015
2015
2014
2014
2015
2016
2016
2017
2013
2013
2014
2013
Years since First Aid
Certification
1
3
5
2
5
2
1
5
5
2
1
4
3
5
3
2
1
1
3
3
4
4
3
2
2
1
5
5
4
5
College
Graduate
No
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Ye...