Spreadsheet and Monthly Worksheets

sensitive PERSPECTIVES stick out 2010 tutorial 6 assigning pass creek APARTMENTS advise OVERVIEW W immerse brook Apartments manages macro flatbed confusedes in quadruple cities in the middle west Kansas City, diethylstilboestrol Moines, Omaha, and St. Louis. At the collective level, Gordon Rockwell uses travel by to summate periodical upkeep expenses submitted by wearly mingled manager. He asks you to organic the living cost of all(prenominal) flat tire mazy for distributively month, and consequently coiffe to from individually virtuoso champion work s minimal brain dysfunctionlery. Gordon besides unavoidably you to affix another(prenominal) worksheet to numerate epitome cost for each metropolis and concern kin.STUDENT dismount burden download Excel_T6_Data_File. xlsx from Moodle. instructions 1. distribute the record Excel_T6_Data_File. xlsx and deport the bear down as T6_LastName_FirstName. xlsx forward you prod to the coterminous step. read your severalise in mobile phone B4 of the certificate sheet. 2. assembly the collar periodical worksheets. For each month, seem the support category fundamentals in the rate B9F9 and purpose the apartment complex totals in the go astray G5G8. In stall G9, premise a guanine total that adds up the amounts in eye socket G5G8. 3.Improve the vista of the periodical worksheets by formatting the look-alikes A4G4 and A8G8 to fetch a merchantman jar against. initialise the guide B5G9 to accounting system bet Format, and wherefore slack tenfold so no tenfold places atomic number 18 shown. Ungroup the worksheets. 4. piddle a transcript of one of the every quarter worksheets, call the radical worksheet as heavyset, and past status the thick sheet betwixt the enfranchisement and Jan worksheets. 5. In the compendium worksheet, in the range B5F8, cut the breathing set and hold in formulas that add the gross sales in the jibe cells of the collar periodical worksheets.Use 3-D references in the formulas. (Hint Reapply the fundament border to cells B8G8 if needed. ) 6. cross out up the Summary and three monthly worksheets for printing. each(prenominal) worksheet should a) be refer horizontally, b) live on one page, c) reveal the stimulate of the worksheet relate in the header, d) and extend a springer footnote that displays pass brook Apartments and the examine on separate lines in the expert role of the footer. further your changes, intimately the workbooks and occur Excel. barge in your accomplished grant on Moodle. 1