CIS_108_MS_Excel_Final_Performance_Test_Instructions.docx - Office 2016 \u2013 myitlab:grader \u2013 Instructions Excel Project CIS 108 MS Excel Final

CIS_108_MS_Excel_Final_Performance_Test_Instructions.docx -...

This preview shows page 1 - 2 out of 2 pages.

Office 2016 – myitlab:grader – InstructionsExcel ProjectCIS 108 MS Excel Final Performance TestProject Description: Quarter End Final Performance Test - MS ExcelInstructions: For the purpose of grading the project you are required to perform the following tasks: StepInstructionsPointsPossible1Start 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.0002Groupthe WinterSports and SummerSports worksheets.0.0003Make sure your sheets are grouped and in cell A5, enter Sport1.0004In cells B5:E5, enter/type the years 201520162017and 2018In cell F5, type TotalIn cell A10, type the word Total5.0005Format the four Year labels and the Total label as Text. 2.0006Center B5:F5,1.0007Apply bold and the cell style 20% - Accent4 to cells B5:F5.1.0008With the sheets still grouped, in cell F6, enter a formula to total the row for Swimming. 2.0009
Background image
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '19
  • Cell A5

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture