Advanced Microcomputer Applications, programming homework help

User Generated




W5 Microsoft Excel Assignment - "Revenue"

Do Project 3E Revenue that begins on page 527 of your textbook. Submit the document by clicking the Attachments button to attach the file. Do not paste the document in the Message area.

You will need to download and use the following data file to complete your assignment:

Revenue Report

In addition to the assignment file, answer the following question with your submission. This can be answered directly in your Submission comment area, or as a separate Word attachment file:

In this Week’s reading and prep work, In this week’s chapter, you utilized the “What-If Analysis” feature. Explain what this is and how you feel you might be able to use it in a personal finance worksheet of your own? Please look to answer this in at least 3 complete sentences in order to address it adequately.

Unformatted Attachment Preview

CONTENT-BASED ASSESSMENTS (MASTERY AND TRANSFER OF LEARNING MyITLab Mastering Excel Project 3E Revenue grader EL Apply 3A skills from these Objectives: 1 Chart Data with a Pie Chart In the following project, you will edit a worksheet that summarizes the revenue budget for the City of Pacifica Bay. Your completed worksheets will look similar to Figure 3.47. PROJECT FILES 2 Format a Pie Chart For Project 3E, you will need the following file: 3 Edit a Workbook and Update a Chart e03E Revenue 4 Use Goal Seek to Perform What If Analysis You will save your workbook as: Lastname Firstname 3E_Revenue PROJECT RESULTS City of Pacifica Bay Revenue Sources Projection for Ned Fiscal Yeue Budget Revenue Projected Revenue Projected Revenue of Tatal Projected for Next Fiscal Year Current Year Revenud 37 2146 223 JOM Taves Licenses and Permits Intergovernmental Services 54,157,8735 55,956, 359 28,120,500 30, 254,907 11,786400 13,212,614 14,007,745 15,741,040 8,694,563 11,858,025 136,762,0815 150,125.000 s Other Total Intergovernmental 22% Services 1 Licenses and Permits 21 Other 9% Excel 2016, Windows 10, Microsoft Corporation Lastname_Firstname_3E_Revenue Lastname_Firstname_DE_Revenue FIGURE 3.47 (Project 3E Revenue continues on the next page) 527 Project 3E Revenue Excel CONTENT-BASED ASSESSMENTS (MASTERY AND TRANSFER OF LEARNING) Mastering Excel Project 3E Revenue (continued) 1 Start Excel. From your student data files, locate and open e03E_Revenue. Save the file in your Excel Chapter 3 folder as Lastname_Firstname_3E_Revenue vo 2 In cell D5, construct a formula to calculate the % of Total Projected Revenue from Taxes by dividing the Projected Revenue for Next Fiscal Year for Taxes by the Total Projected Revenue for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell D9. 8 Select the Services slice, and then explode the slice 10%. Change the Fill Color of the Services slice to a Solid fill using Gray-50%, Accent 4—in the eighth column, the first color. 9 Format the Chart Area by applying a Gradient fill using the Preset gradients Light Gradient – Accent 4. Format the Border of the Chart Area by applying a Solid line border using Gray-50%, Accent 4 and a 5 pt Width. Close any panes that are open on the right. 10 Display the Page Setup dialog box, and then for this chart sheet, insert a Custom Footer in the left section with the file name. 3 Select the nonadjacent ranges A5:A9 and C5:C9 as the data for a pie chart, and then insert a 3-D Pie chart. Move the chart to a New sheet named Projected Revenue Chart 4 As the text for the Chart Title element, type Projected Revenue Format the Chart Title using the WordArt Style Fill – Aqua, Accent 1, Shadow in the first row, the second style and a Font Size of 32. 5 Remove the Legend chart element, and then add the Data Labels chart element formatted so that only the Category Name and Percentage display positioned in the Center. Format the data labels with a Font style of Bold and a Font Size of 14. 11 Display the Revenue Sources sheet. Click cell C10, and then use Goal Seek to determine the projected amount of Other revenue in cell C9 if the value in C10 is 150,125,000 12 Display the Page Setup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name. 13 Show all the properties, and then as the Tags, type revenue sources As the Subject, type your course name and section number. Be sure your name displays as the Author. Save your workbook. If directed by your instructor to do so, submit your paper printout, your electronic image of your document that looks like a printed document, or your original Excel file. If required by your instructor, print or create an electronic version of your worksheet with formulas displayed. In the upper right corner of the Excel window, click Close. 6 Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to Art Deco. Set the Top bevel Width and Height to 350 pt and then set the Bottom bevel Width and Height to O pt Change the Material to the second Special Effect-Soft Edge. 7 Display the Series Options, and then set the Angle of first slice to 115 so that the Taxes slice is in the front of the pie. WYPT END | You have completed Project 3E Excel Chapter 3: ANALYZING DATA WITH PIE CHARTS, LINE CHARTS, AND WHAT-IF ANALYSIS TOOLS 528
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

I Am hopeful I will get your detail...

Really helpful material, saved me a great deal of time.