Project C Parks

Start Excel. From your student data files, open the file e03C_Parks. Save the file in your Excel Chapter 3 folder as Lastname_Firstname_3C_Parks a. Click cell D5, and then type = to begin a formula. Click cell C5, type / and then click cell C11. Press to make the reference to the value in cell C11 absolute. On the Formula Bar, click Enter, and then fill the formula down through cell D10. b. With the range D5:D10 selected, right-click over the selection, and then on the mini toolbar, click Percent Style and Center. 2 Select the nonadjacent ranges A5:A10 and C5:C10 to select the park names and the projected revenue. Click the Insert tab, and then in the Charts group, click Insert Pie or Doughnut Chart. Under 3-D Pie, click the chart type 3-D Pie. a. On the Design tab, in the Location group, click Move Chart. In the Move Chart dialog box, click the New sheet option button. In the New sheet box, replace the highlighted text Chart1 by typing Projected Park Revenue Chart and then click OK. b. Click the text Chart Title. Type Projected Park Revenue and then press to create the new chart title. c. With the title selected, on the Format tab, in the WordArt Styles group, click More to display the gallery. In the second row, select the fifth style— Fill – Olive Green, Accent 3, Sharp Bevel. Drag to select the chart title text, and then on the mini toolbar, change the Font Size to 32. d. Click in a white area of the chart to deselect the chart title. Click Chart Elements, and then click the Legend check box to remove the legend. e. In the list of Chart Elements, point to Data Labels, click the arrow that displays, and then click More Options. In the Format Data Labels pane on the right, under Label Options, select the Category Name and Percentage check boxes, and clear all other check boxes. Under Label Position, click Center. f. Point to any of the selected labels, right-click to display a shortcut menu, and then click Font. In the Font dialog box, on the Font tab, change the Font style to Bold Italic and change the Size to 11 Click OK.

In any pie slice, point anywhere outside the selected label, and then double-click to display the Format Data Series pane. Under Series Options, click Effects, and then click 3-D Format. a. Click the Top bevel arrow, and then under Bevel, click the first button—Circle. Apply the Circle bevel to the Bottom bevel. b. Set the Width and Height of both the Top bevel and the Bottom bevel to 512 pt c. Scroll down, click the Material arrow, and then under Standard, click the third material—Plastic. d. Scroll to the top of the Format Data Series pane, click Shadow, and then click the Presets arrow. Scroll down, and then under Perspective, in the first row, click the third effect—Below. e. In the Format Data Series pane, under Series Options, click the third button—Series Options. Set the Angle of first slice to 50 f. On the pie chart, click the Diamond League Fields slice to select only that slice, and then in the Format Data Point pane, set the Point Explosion to 10% g. With the Diamond League Fields slice still selected, in the Format Data Point pane, under Series Options, click Fill & Line, and then click Fill to expand the options. h. Click the Gradient fill option button, click the Preset gradients arrow, and then in the fourth row, click the third gradient—Bottom Spotlight – Accent 3. 4 Point to the white area just inside the border of the chart to display the ScreenTip Chart Area, and then click one time to display the Format Chart Area pane. a. Under Chart Options, click Fill & Line, and be sure the Fill options are still displayed. b. Click the Gradient fill option button, click the Preset gradients arrow, and then in the first row, click the fifth gradient—Light Gradient – Accent 5. c. In the Format Chart Area pane, click Fill to collapse the options, and then click Border to expand the options. d. Click the Solid line option button, click the Color arrow, and then in the fifth column, click the last color—Ice Blue, Accent 1, Darker 50%. Set the Width of the border to 5 pt Close the pane, and then Save your workbook.

In the sheet tab area at the bottom of the workbook, click the Sheet1 tab. a. Click cell C11. On the Data tab, in the Forecast group, click What-If Analysis, and then click Goal Seek. In the Goal Seek dialog box, press to move to the To value box, and then type 17,800,000 b. Press to move the insertion point to the By changing cell box, and then click cell C10. Click OK. In the displayed Goal Seek Status dialog box, click OK to set the total projected revenue to $17,800,000 by changing the projected revenue for the Community Center. 6 With your worksheet displayed, in the sheet tab area, double-click Sheet1 to select the text, and then type Projected Park Revenue Data and press . a. Click the Page Layout tab. In the Page Setup Group, click Margins, click Custom Margins, and then in the Page Setup dialog box, on the Margins tab, under Center on page, select the Horizontally check box. b. Click the Header/Footer tab, click Custom Footer, and then with your insertion point in the Left section, on the row of buttons, click Insert File Name. Click OK two times. c. Display the Projected Park Revenue Chart, and then display the Page Setup dialog box. d. Click the Header/Footer tab, click Custom Footer, and then in the Left section, click the Insert File Name button. Click OK two times. e. Click the File tab, and then click Show All Properties. As the Tags, type park revenue As the Subject, type your course name and section number. Be sure your name displays as the Author. f. 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.