Rename sheet1 as revenue

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.xlsxPreview the document.

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.