SK16XLVOL1GRADERCAPAS_-_Budget_112_Instructions.docx -...

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.