Excel Capstone - Office 2013 myitlab:grader Instructions Excel Project SKL EVOL1 CAP Toms Appliance Stores 1.2 Project Description In this project you

Excel Capstone - Office 2013 myitlab:grader Instructions...

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

Office 2013 – myitlab:grader – InstructionsExcel ProjectSKL EVOL1 CAP - Tom’s Appliance Stores 1.2Project Description: In this project, you will unhide a worksheet, work with grouped worksheets, insert a worksheet, rename a worksheet, color a worksheet tab, insert summary functions, insert logical functions, insert a date function, insert conditional formatting, and construct formulas that refer to cells in other worksheets. Additionally, you will create and modify a clustered column chart.Instructions: For the purpose of grading the project you are required to perform the following tasks: StepInstructionsPointsPossible1Start Excel 2013, and then open the downloaded file skills_exl_grader_cap.xlsx.0.0002Unhide the Downtown worksheet.5.0003Group the worksheets. Adjust the column width of B:F to 9.00. Center the text in the range B3:F3. In cell F4, insert a function that will sum row 4. AutoFill F4 down through F11. Insert a function in B12:F12 to total each column. Format the range B12:F12 with the Total cell style.
Background image
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '15
  • Alan Imhoff
  • Summary sheet

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture