NEW PERSPECTIVES EXCEL 2010 TUTORIAL 6: ASSIGNMENT WINTER CREEK APARTMENTS PROJECT OVERVIEW W inter Creek Apartments manages large apartment complexes in four cities in the Midwest: Kansas City, Des Moines, Omaha, and St. Louis. At the corporate level, Gordon Rockwell uses Excel to summarize monthly maintenance expenses submitted by each complex manager. He asks you to total the maintenance costs of each apartment complex’ for each month, and then format each worksheet. Gordon also needs you to add another worksheet to calculate summary costs for each city and maintenance category.
STUDENT START FILE 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 cell B4 of the Documentation sheet. 2. Group the three monthly worksheets. For each month, calculate the maintenance category totals in the range B9:F9 and calculate the apartment complex totals in the range G5:G8. In cell G9, enter a grand total that adds up the amounts in range G5:G8. 3.
Improve the look of the monthly worksheets by formatting the ranges A4:G4 and A8:G8 to have a bottom border. Format the range B5:G9 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, rename the new worksheet as Summary, and then position the Summary sheet between the Documentation and Jan worksheets. 5. In the Summary worksheet, in the range B5:F8, delete the existing values 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 B8:G8 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 centered in the header, d) and contain a custom footer that displays Winter Creek Apartments and the date on separate lines in the right section of the footer. Save your changes, close the workbooks and exit Excel. Submit your completed assignment on Moodle. 1
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more