CMIS1150: MS Integration Project - Report Writing - Management Assignment Help

Assignment Task

Overview

As an editor of the CST Publishing House, you are editing Chapter 6 of a book with the title of “Learning Excel”. Chapter 6 was written by Diane Shingledecker, Portland Community College. You will be adding new elements and formatting the entire document.

Detailed Instruction:

Open 2020 Integration Project Report. Save as →

1. 2020 Integration Project Report_FirstLastName.

1. Do not change the content but format the WHOLE DOCUMENT using the

 Student Paper JRSSB Style Guide.

1. Insert a Table of Contents with an appropriate heading.
2. On a separate page at the end of the document create an Index
   with a title using all the occurrences of the following key words:
   1. Formulas
   2. Sheets
   3. 3-D
   4. Summary
3. Create the following source and use the citation at the end of the second paragraph.

1. Above each figure replace the existing labels and numbering with captions using Insert Caption. The first figure uses the Shingledecker source.

1. Insert a List of Figures with a title after the table of contents.
2. Relabel the Backstage Properties for the Title to “Excel Spreadsheets Project”
3. Replace the cover page, and add page numbers (starting after the cover page) and a header and a footer.
   1. Cover Page: the Title, Author, Year ,Publisher, the copy right information
   2. Header: Title and a right aligned Page Number
   3. Footer: the author
4. Insert a bibliography.
5. Review the entire document for application of JRSSB formatting and proof your work.

Part II – MS Excel (55 points)

Detailed Instruction:

1. Open the data file and save the file to your computer as Income Statement-LastfirstName.
2. Replace the data in the September, October, and November sheets with the following:

1. Make a December sheet by copying the November sheet.

Make the following data changes in the December sheet:

• Lease: $5500
• Interest: $310
• Consulting: delete the amount

1. Group all the month sheets together, then enter the following

• Click in F11 in the January grouped sheet.
• Enter the formula=SUM (F5:F8).
• In F12, enter the formula=SUM (C5:C13).
• In F13, subtract Expenses from Income. In the January sheet. HINT: if your answer is negative, you subtracted Income from Expenses.
• Click on I5.
• Enter a formula that divides Expenses (F12) by Income (F11). Your answer will show as a percentage since this cell has already been formatted to do this. HINT: If your percentage is greater than 100%, you have your numbers reversed.

Now Group the October through December Sheets

• Take a look at the Notes in the September sheet. to eliminate Consulting Fees in October, November, and December.
• Click on C12 in October, November, and December sheets and change the amount to $0. Press Enter.

1. Add up all the monthly amounts in the Expenses Summary sheet using the 3-D formula:

• Click in C5 in the Expenses Summary sheet.
• Type=SUM(. (Make sure to type the open parentheses!)
• Click on the January sheet.
• Hold the SHIFT key down and click on the December sheet.
• Click on C5 again and press ENTER. Cell C5 should display the sum amount.
• Click on C5 in the Expenses Summary sheet. In the formula bar, you should see the following formula: =SUM(January:December!C5). This means SUM C5 in the sheets January through December.
• Let us try another 3-D SUM together. Click on C6.
• Type=SUM(. (Make sure to type the open parentheses!)
• Click on the January sheet.
• Hold the SHIFT key down and click on the December sheet.
• Click on C6 again and press ENTER. Cell C6 should now display the sum amount.
• Click on C6 in the Expenses Summary sheet. In the formula bar, you should see the following formula: =SUM(January:December!C6).

This Management has been solved by our Phd Experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.