Project 3 D Housing Permits

Start Excel. From your student data files, open e03D_Housing_Permits. Using your own name, save the file in your Excel Chapter 3 folder as Lastname_Firstname_3D_Housing_Permits a. In cell B4, type 2010 and then press . In cell C4, type 2011 and then press . b. Use the fill handle to fill the remaining years through column F so that the last year that displays is 2014. 2 Click cell C6. Being sure to include the parentheses, type =(c5-b5)/b5 and then press . Select cell C6, and then apply Percent Style. a. With cell C6 selected, drag the fill handle to the right through cell F6. b. In cell A8, type Projected Future Housing Permit Revenue and then press . Point to cell A2, rightclick, on the mini toolbar, click Format Painter, and then click cell A8. In cell A10, type Forecasted Increase and then click cell A12. Type Year c. In cell A13, type Projected Permit Revenue and then in cell B12, type 2014 and press . In cell C12, type 2015 and then press . Select the range B12:C12, and then drag the fill handle through cell F12 to extend the pattern of years to 2018. Apply Bold to the selection. d. Right-click cell F5, and then click Copy. Right-click over cell B13, and then click Paste. e. In cell B10, type 7% which is the percent of increase from 2013 to 2014. Select the range A10:B10, and then from the mini toolbar, apply Bold and Italic. 3 Click cell C13. Type =b13*(100%+$b$10) and then on the Formula Bar, click Enter to keep the cell active. With cell C13 as the active cell, drag the fill handle to copy the formula to the range D13:F13. a. Point to cell B13, right-click, click Format Painter, and then select the range C13:F13. b. Click cell A15. Type Forecasted Revenue Estimates 2014 to 2018 and then press . Use Format Painter to copy the format from cell A8 to cell A15. c. In the range A17:A19, type the following row titles:

4 Select the range B12:F12, right-click over the selection, and then on the shortcut menu, click Copy. Paste the selection to the range B17:F17. a. Select the range B13:F13, right-click over the selection, and then on the shortcut menu, click Copy. Point to cell B18, right-click, and then from the shortcut menu, point to Paste Special. Under Paste Values, click the second button—Values & Number Formatting. Press to cancel the moving border. b. Click cell B10. Type 8 and then press . Copy the new values in the range B13:F13. Point to cell B19, right-click, and then point to Paste Special. Under Paste Values, click Values & Number Formatting. Save your workbook. 5 In the row header area, point to row 8 to display the pointer, and then drag down to select rows 8:24. Right-click over the selection, and then click Insert to insert the same number of blank rows as you selected. Under the selection area near cell A25, click Insert Options, and then click the Clear Formatting option button to clear any formatting from these rows. a. On the Page Layout tab, in the Themes group, click the Colors arrow, and then click Yellow. Select the range A5:F5. On the Insert tab, in the Charts group, click Insert Line or Area Chart. In the displayed gallery of line charts, click the Line with Markers chart type to create the chart. b. Point to the border of the chart to display the pointer, and then drag the chart so that its upper left corner is positioned in cell A9, aligned approximately under the c in the word Projected above. c. Point to the Chart Title Permit Revenue and rightclick. On the shortcut menu, click Edit Text. Type Pacifica Bay Housing and then press . Press and then press to create a second line. Type 2010 to 2014 d. Click the dashed border around the chart title to change it to a solid border, right-click over the title, and then on the shortcut menu, click Font. In the Font dialog box, change the Font style to Bold, change the Size to 16, and change the Font color to White, Background 1, Darker 5%—in the first column, the second color. Click OK.

6 At the bottom of the chart, point to any of the numbers 1 through 5, and then right-click. On the shortcut menu, click Select Data. On the right side of the Select Data Source dialog box, click Edit. In the worksheet, select the years in the range B4:F4, and then click OK two times to enter the years as the category labels. a. With the Horizontal (Category) Axis still selected, click Chart Elements, point to Axes, click the arrow, and then click More Options. In the Format Axis pane, under Axis Options, click Fill & Line. If necessary, click Line to expand the options. Click the No line option button, and then close the Format Axis pane. b. On the left side of the chart, point to any of the dollar values, right-click, and then click Format Axis. In the Format Axis pane, under Bounds, select the text in the Minimum box, and then type 1900000 c. Under Units, in the Major box, select the existing text, and then type 50000 d. Near the top of the Format Axis pane, click the Axis Options arrow, and then click Chart Area to display the Format Chart Area pane. Click Fill & Line. e. In the Format Chart Area pane, click Fill to expand the options, and then click the Picture or texture fill option button. Under Insert picture from, click File. In the Insert Picture dialog box, navigate to the student data files, and then click e03D_Housing. Click Insert. f. In the Format Chart Area pane, click Fill to collapse the options, and then if necessary click Border to expand the Border section. Click the Solid line option button, click the Color arrow, and then under Theme Colors, in the fifth column, click the first color—Gold, Accent 1. Set the Width to 4 pt Scroll to the bottom of the pane, and then select the Rounded corners check box.

7 To the right of the chart, click Chart Elements, point to Gridlines, click the arrow, and then click More Options to display the Format Major Gridlines pane. a. Under Line, click the Solid line option button. Click the Color arrow, and be sure that Gold, Accent 1 is the selected color. Set the Width to 1 pt b. In the chart, point to any of the dollar values on the Vertical (Value) Axis, right-click, and then click Font. In the Font dialog box, change the Font style to Bold, and then change the Font color to White, Background 1—in the first column, the first color. Click OK. c. By using the same technique, format the Font of the Horizontal (Category) Axis to Bold with White, Background 1 as the font color. d. Close the Format Axis pane, and then click cell A1 to deselect the chart. Click the Page Layout tab. In the Page Setup group, click Margins, and then click Custom Margins. On the Margins tab, select the Horizontally check box. Click the Header/Footer tab, click Custom Footer, and then in the Left section, insert the file name. Click OK two times. e. Click the File tab, and then click Show All Properties. As the Tags, type housing permit revenue In the Subject box, 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