Spreadsheet and Monthly Worksheets

NEW PERSPECTIVES EXCEL 2010 TUTORIAL 6: ASSIGNMENT WINTER CREEK APARTMENTS PROJECT OVERVIEW W bury Creek Apartments oversees enormous high rises in four urban areas in the Midwest: Kansas City, Des Moines, Omaha, and St. Louis. At the corporate level, Gordon Rockwell utilizes Excel to sum up month to month support costs presented by every mind boggling supervisor. He requests that you all out the support expenses of every loft complex’ for every month, and afterward position every worksheet. Gordon likewise needs you to add another worksheet to figure rundown costs for every city and support category.STUDENT START FILE Download Excel_T6_Data_File. xlsx from Moodle. Guidelines 1. Open the record Excel_T6_Data_File. xlsx and spare the record as T6_LastName_FirstName. xlsx before you move to the following stage. Enter your name in cell B4 of the Documentation sheet. 2. Gathering the three month to month worksheets. For every month, figure the upkeep class sums in the range B9:F9 and ascertain the high rise sums in the range G5:G8. In cell G9, enter a stupendous absolute that includes the sums in run G5:G8. 3.Improve the vibe of the month to month worksheets by organizing the extents A4:G4 and A8:G8 to have a base fringe. Configuration the range B5:G9 to Accounting Number Format, and afterward Decrease Decimal so no decimal spots are appeared. Ungroup the worksheets. 4. Cause a duplicate of one of the quarterly worksheets, to rename the new worksheet as Summary, and afterward position the Summary sheet between the Documentation and Jan worksheets. 5. In the Summary worksheet, in the range B5:F8, erase the current qualities and supplement equations that include the deals in the comparing cells of the three month to month worksheets.Use 3-D references in the recipes. (Clue: Reapply the base fringe to cells B8:G8 if necessary. ) 6. Set up the Summary and three month to month worksheets for printing. Every worksheet should: a) be focused on a level plane, b) fit on one page, c) show the name of the worksheet focused in the header, d) and contain a custom footer that presentations Winter Creek Apartments and the date on discrete lines in the correct area of the footer. Spare your changes, close the exercise manuals and exit Excel. Present your finished task on Moodle. 1