CIS_108_MS_Excel_Final_Performance_Test_Instructions.docx -...

Office 2016 – myitlab:grader – Instructions
Excel Project
CIS 108 MS Excel Final Performance Test
Project Description:
Quarter End Final Performance Test - MS Excel
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions
Points
Possible
1
Start Excel 2016, and remember to save your worksheet frequently.
Open the file EXL_Final . Save As the file with the file name Last_First_EXL_Final. (Note: Please
replace Last_First with your name i.e. Fieldsend_Laurie_EXL_Final)
0.000
2
Group the WinterSports and SummerSports worksheets.
0.000
3
Make sure your sheets are grouped and in cell A5 , enter Sport
1.000
4
In cells B5:E5 , enter/type the years 2015 2016 2017 and 2018
In cell F5 , type Total
In cell A10 , type the word Total
5.000
5 Format the four Year labels and the Total label as Text. 2.000
6
Center B5:F5 ,
1.000
7 Apply bold and the cell style 20% - Accent4 to cells B 5:F5 . 1.000
8 With the sheets still grouped, in cell F6 , enter a formula to total the row for Swimming. 2.000
9