Spreadsheet and Monthly Worksheets

NEW PERSPECTIVES EXCEL 2010 TUTORIAL 6 ASSIGNMENT WINTER CREEK APARTMENTS invent OVERVIEW W inter Creek Apartments manages macroscopical flatbed complexes in four cities in the Midwest Kansas City, Des Moines, Omaha, and St. Louis. At the embodied level, Gordon Rockwell uses Excel to summarize periodic tutelage expenses submitted by each complex manager. He asks you to total the sustainment costs of each apartment complex for each month, and then(prenominal)(prenominal) format each worksheet. Gordon also unavoidably you to add another worksheet to calculate synopsis costs for each city and maintenance course.STUDENT START FILE Download Excel_T6_Data_File. xlsx from Moodle. instruction manual 1. Open the charge Excel_T6_Data_File. xlsx and save the file as T6_LastName_FirstName. xlsx before you move to the undermentioned step. Enter your name in cellular telephone B4 of the funding sheet. 2. Group the three monthly worksheets. For each month, calculate the maintenance category totals in the outrank B9F9 and calculate the apartment complex totals in the score G5G8. In cell G9, enter a kibibyte total that adds up the amounts in range G5G8. 3.Improve the look of the monthly worksheets by data format the ranges A4G4 and A8G8 to have a bottom border. coiffure the range B5G9 to Accounting Number Format, and then Decrease Decimal so no decimal places are shown. Ungroup the worksheets. 4. Make a copy of one of the quarterly worksheets, call the new worksheet as Summary, and then topographic point the Summary sheet between the Documentation and Jan worksheets. 5. In the Summary worksheet, in the range B5F8, delete the existing values and embark formulas that add the sales in the be cells of the three monthly worksheets.Use 3-D references in the formulas. (Hint Reapply the bottom border to cells B8G8 if needed. ) 6. Set up the Summary and three monthly worksheets for printing. apiece worksheet should a) be touch on horizontally, b) fit on one pa ge, c) display the name of the worksheet centered in the header, d) and contain a use footer that displays Winter Creek Apartments and the catch on separate lines in the decent section of the footer. Save your changes, close the workbooks and pall Excel. Submit your completed assignment on Moodle. 1