CONTENT-BASED ASSESSMENTS (MASTERY AND TRANSFER OF LEARNING
Mastering Excel Project 3E Revenue
Apply 3A skills from
1 Chart Data with a Pie
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
2 Format a Pie Chart
For Project 3E, you will need the following file:
3 Edit a Workbook and
Update a Chart
4 Use Goal Seek to
Perform What If
You will save your workbook as:
Lastname Firstname 3E_Revenue
City of Pacifica Bay
Projection for Ned Fiscal Yeue Budget
Projected Revenue of Tatal Projected
for Next Fiscal Year
Licenses and Permits
54,157,8735 55,956, 359
28,120,500 30, 254,907
Licenses and Permits
Excel 2016, Windows 10, Microsoft Corporation
(Project 3E Revenue continues on the next page)
Project 3E Revenue Excel
CONTENT-BASED ASSESSMENTS (MASTERY AND TRANSFER OF LEARNING)
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
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.
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
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
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.
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
END | You have completed Project 3E
Excel Chapter 3: ANALYZING DATA WITH PIE CHARTS, LINE CHARTS, AND WHAT-IF ANALYSIS TOOLS
Purchase answer to see full