SK16XLVOL1GRADERCAPAS_-_Budget_112_Instructions.docx - Office 2016 myitlab:grader Instructions Excel Project SK16_XL_VOL1_GRADER_CAP_AS Budget 1.12

SK16XLVOL1GRADERCAPAS_-_Budget_112_Instructions.docx -...

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

Office 2016 – myitlab:grader – Instructions Excel Project SK16_XL_VOL1_GRADER_CAP_AS - Budget 1.12 Project Description: In this project, you will unhide a worksheet, work with grouped worksheets, insert and rename worksheets, insert summary, logical, date, statistical and Date functions, and refer to cells in other worksheets. Additionally, you will apply conditional formatting, create and modify charts, and create, sort, and filter Excel tables. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel 2016. Download and open the file sk16_xl_ch1-4_grader_cap_as.xlsx . Save the file as Last_First_sk16_xl_ch1-4_grader_cap_as . 0 2 Unhide the Downtown worksheet. 2 3 Group the worksheets. Adjust the column width of B:E to 8.5. Center and Wrap the text in the range B3:F3. 3.75 4 Ungroup the worksheets, and then group the four location sheets, except for Inventory. In the Item Total column, insert a function that will sum Quarters 1 - 4. Insert a function in the Quarter Total row to total each column. Apply the Total Cell style to the Quarter Total results. 4 5 With the four sheets grouped, apply the Currency [0] cell style, to the range B4:F4 and B13:F13. Save the file.
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 3 pages?

  • Winter '20

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture