Spreadsheet and Monthly Worksheets

tonic PERSPECTIVES EXCEL 2010 TUTORIAL 6 ASSIGNMENT WINTER CREEK APARTMENTS bemuse OVERVIEW W inter Creek Apartments manages large apartment complexes in quadruple cities in the Midwest Kansas City, Des Moines, Omaha, and St. Louis. At the corporate level, Gordon Rockwell uses Excel to tally monthly alimony expenses submitted by each complex manager. He asks you to descend the maintenance costs of each apartment complex for each month, and and then format each worksheet. Gordon also needs you to add another worksheet to organize summary costs for each city and maintenance category.STUDENT START record Download Excel_T6_Data_File. xlsx from Moodle. Instructions 1. Open the file Excel_T6_Data_File. xlsx and save the file as T6_LastName_FirstName. xlsx before you move to the next step. Enter your name in cellphone B4 of the enfranchisement sheet. 2. Group the three monthly worksheets. For each month, calculate the maintenance category tots in the range B9F9 and calculate th e apartment complex totals in the range G5G8. In cell G9, enter a grand total that adds up the amounts in range G5G8. 3.Improve the look of the monthly worksheets by formatting the ranges A4G4 and A8G8 to have a bottom border. Format the range B5G9 to Accounting identification 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, rename the new worksheet as abstract, and then position the Summary sheet between the Documentation and Jan worksheets. 5. In the Summary worksheet, in the range B5F8, delete the existing value and insert formulas that add the sales in the corresponding 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. Each worksheet should a) be centered horizontally, b) fit on one page, c) display the name of the worksheet centere d in the header, d) and contain a custom footer that displays Winter Creek Apartments and the date on specialise lines in the right section of the footer. Save your changes, close the workbooks and exit Excel. twist your completed assignment on Moodle. 1