Microsoft Excel

Anonymous
timer Asked: Sep 21st, 2018
account_balance_wallet $15

Question Description

For the purpose of grading the assignment you are required to perform the following tasks:

Step

Instructions

Points Possible

1

Start Excel. Download and open the file named Challenging assignment3.xlsx.

0.000

2

In cells B10 and C10, enter formulas to calculate totals for each column.

10.000

3

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.

10.000

4

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

10.000

5

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.

8.000

6

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.

8.000

7

Change the Font Size of the data labels to 14, and then apply Bold.

4.000

8

Format the Data Series using a 3-D Format effect. Change the Top bevel and Bottom bevel to the last bevel style—Art Deco. Set the Top bevel Width and Height to 350 pt and then set the Bottom bevel Width and Height to 0. Change the Material to the second Special Effect—Soft Edge. Display the Series Options, and then set the Angle of the first slice to 115 so that the Taxes slice is in the front of the pie.

2.000

9

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.

5.000

10

Format the Chart Area by applying a Gradient fill using the Preset gradients Light Gradient – Accent 4—in the fourth column, the first gradient.

5.000

11

Format the Border of the Chart Area by adding a Solid line border using Gray-50%, Accent 4—in the eighth column, the first color—and a 5 pt Width.

6.000

12

Display the Page Setup dialog box, and then for this chart sheet, insert a custom footer in the left section with the file name.

6.000

13

Display Sheet1 and rename the sheet as Revenue Sources Click in any blank cell to cancel any selections. In cell A12, type Goal: Increase Intergovernmental Revenue and then Merge & Center the text across the range A12:D12. Apply the Heading 3 cell style. In cell A13, type Goal Amount.

10.000

14

Copy the range C7:D7 to cell B13. Click cell C13, and then use Goal Seek to determine the projected amount of Intergovernmental Revenue in cell B13 if the value in C13 is 25%

8.000

15

Select the range A13:C13, and then apply the 20% - Accent4 cell style. In B13, from the Cell Styles gallery, apply the Currency [0] cell style.

4.000

16

From the Page Setup dialog box, center the worksheet Horizontally, and then insert a custom footer in the left section with the file name.

4.000

17

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Projected Revenue Chart, Revenue Sources. Save and close the document. Exit Excel. Submit the file as directed.

0.00

Unformatted Attachment Preview

City of Pacifica Bay Revenue Sources Projection for Next Fiscal Year Budget Current Year Revenue Taxes Licenses and Permits Intergovernmental Services Other Total $ Projected Revenue % of Total Projected for Next Fiscal Year Revenue 54,152,873 $ 28,120,500 31,786,400 14,007,745 8,694,563 55,956,359 30,854,962 33,712,614 15,743,040 13,987,550 ...
Purchase answer to see full attachment

Tutor Answer

criss53
School: New York University

If the work is l...

flag Report DMCA
Review

Anonymous
Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors