Excel 2016 module 8 review assignment

BCIS2610 The University of Texas at Arlington Excel Module 8 SAM Project 1
Subject
Business Finance

Course
BCIS2610

School
The University of Texas at Arlington

Question Description
Instructions upon how to save the file is there below in the folder. Thank you

Open the file NP_EX16_8a_FirstLastName_1.xlsx, available for download from the SAM website.
Save the file as NP_EX16_8a_FirstLastName_2.xlsx by changing the “1” to a “2”.
If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
With the file NP_EX16_8a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
Thank youAuthor: 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 Samikshya Adhikari 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 1053 1056 1035 1094 1066 1050 1054 1070 1040 1010 1073 1069 1060 1043 1034 1084 1078 1036 1074 1076 1009 1089 1022 1033 1065 1078 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 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 College Graduate No Yes Yes No No Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No No Yes No No Yes No Yes Yes No No Yes Yes Yes Leadership Training No Yes No Yes No No Yes No Yes No Yes No No Yes No Yes No Yes Yes No Yes Yes No Yes Yes Yes Yes Yes Yes Yes Transportation Group Leader Bunk Leader Candidate for Leadership Training Staff ID Staff Name Service Years 1036 Oscar Alberts Total Staff Leadership Trained Staff All Staff Service Years Base Salary Average Service Years 0 $ 0 15.00 $ 1 15.50 $ 2 16.75 $ 5 17.50 $ 7 18.50 New Perspectives Excel 2016 | Module 8: SAM Project 1a Camp Bright Firewood WORKING WITH ADVANCED FUNCTIONS GETTING STARTED • Open the file NP_EX16_8a_FirstLastName_1.xlsx, available for download from the SAM website. • Save the file as NP_EX16_8a_FirstLastName_2.xlsx by changing the “1” to a “2”. o • If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX16_8a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. o If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. Dean Hilson is the director of Camp Bright Firewood. He started planning the camp staffing assignments for next year in an Excel table, and needs your help completing the table. First, he’d like to confirm that all the staff data was entered correctly into the worksheet. Go to the Staff Listing worksheet and complete the following steps: a. Apply a conditional formatting Highlight Cells Rule to the range A2:A31 that formats any duplicate values with Light Red Fill with Dark Red Text. b. Correct the duplicate values by updating the Staff ID for Artie Jimenez to 1055 and the Staff ID for Sylvia Lee to 1087. (Hint: When this sub-step is completed,