Advanced Microcomputer Applications, programming homework help

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. 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