Excel quiz 3

As the chart title, type Enterprise Fund Expenditures. On the Format tab, in the WordArt Styles group, click More. In the first row, click the last style. Change the Font Size of the chart title to 32 and then deselect the chart title.

easy

1. Display the Enterprise Fund Expenditures sheet, and then in C5, change the value to 18,121,067. 2. Display the Expenditures Chart sheet to view the change to the percentages.

- click on the enterprise fund expenditures, click cell C5 then type 18121967 - click the expenditures chart worksheet tab by clicking ... next to the other tab

1. Use Format Painter to copy the format of cell A2 to cell A8. 2. Copy the value in cell F5 to cell B13

1. right click cell A2, click format painter (bottom right), click cell A8 2. right click cell F5, copy, point to cell b13 right click, paste first option

1. Click in the Chart Area to display the Format Chart Area pane. Under Chart Options, under Fill, click the Gradient fill option button, click the Preset gradients arrow, and then in the fourth row, click the first gradient. 2. In the Format Chart Area pane, expand the Border section. Click Solid line, click the Color arrow, and then in the fourth column, click the first color. Change the Width to 5​. 3. Close the Format Chart Area pane.

- click chart area to display the format chart area pane which is in the top left corner, then click gradient fill, then present gradients - click fill to collapse the options, click border, solid line, click color, 4th column first color, in width box change to 5 - in the upper right corner of the format chart area pane click close (x)

1. Explode the Waterfront slice from the pie by 10%. 2. With the Waterfront slice still selected, in the Format Data Point pane, under Series Options, click Fill & Line, and then click Fill to expand its options. Click the Gradient fill option button, click the Preset gradients arrow, and then in the fourth row, click the last gradient.

- click the waterfront pie slice then change point explosion under angle of first slice and change to 10 - click first button now under series options, then click fill, then gradient fill then go to present gradients then go to the 6th column and 4th row

To the pie chart, apply the Perspective: Below preset shadow—under Perspective, in the first row, the third shadow style.

- in format data series click shadow then click presets window - click perspective first row, third style

Use the Format Data Series pane to apply the first bevel effect to the top of the pie chart with a width and height of 512 pt. Then apply the same effect to the bottom of the pie chart with a width and height of 512 pt. Change the surface material of the chart to Plastic, (under Standard, the third material).

- left double click on any pie - click second button under series options - click 3-D Format - click top bevel and the first bevel - change the height and width to what it want and then do it to the bottom bevel - then change the material

1. On the Enterprise Fund Expenditures sheet, select the range D5:D10, and then increase the number of decimal places to two. 2. Click cell C11. On the Data tab, in the Forecast group, click What-If Analysis, and then click Goal Seek. Use Goal Seek to set cell C11 to 100,000,000 by changing the Waterfront expenditures in cell C10.

- select the range D5:D10, on home tab in the number group click increase decimal two times - click cell 11 and then click data tab, in the forecast group click what- if analysis, and then click goal seek and then change to value box to 100,000,000 and the box below that to whatever it is

In the Format Data Series pane, under Series Options, click Series Options. Change the Angle of first slice to 250.

- under series pane click the third button - then change angle of first slice to 250

In cell D5 create a formula to divide the value in cell C5 by cell C11. Be sure to make the value in cell C11 absolute. Fill the formula from cell D5 down through cells D6:D10. Format cells D5:D10 with Percent Style (with zero decimal places) and then Center the selection.

-click cell D5 and then type =, click cell C5, then type /, click cell C11, press F4 function key, on formula bar click enter - you know how to do that - click percent style in the number group, click center in alignment group

1. In the range B4​:​F4​, use the fill handle to fill ​the years in one-year increments beginning with 2016 and ending with 2020​. 2. In cell C6, type the formula ​=(c5-b5)/b5​​ to calculate ​the rate of increase from the first year to the second year​.​ 3. Format ​cell​ C6 with Percent Style. 4. Copy the formula in ​​C6 across through cells ​D6​:​F6​.

1. click cell B4 and type 2016 then press tab, C4 type 2017 tab, select B4:C4, bottom right point to fill handle in C4 (hold down mouse button and drag to the right to cell F4 and release the mouse button) 2. click cell C6 and type =(c5-b5)/b5, enter 3. click cell c6, home type number group click percent style 4. click and drag the fill handle to F6 and release the mouse button

1. In cell C13, type the formula =b13*(100%+$b$10) to calculate the projected tourism spending after the forecasted increase in cell B10 is added to the first-year total. 2. Use Format Painter to copy the format from B13 to C13. 3. Copy the formula and formatting in cell C13 to the range D13:F13.

1. click cell C13 and type the formula, on formula bar click enter 2. right click cell B13 and click format painter, click cell C13 3. C13 selected, click and drag the fill handle

1. On the ​Enterprise Fund Expenditures​ sheet, insert a footer with the file name in the left section and center the worksheet horizontally on the page. Return to the worksheet and Normal view, if necessary. 2. On the ​Expenditures Chart​ sheet, use the Page Setup dialog box to insert a footer with the file name in the left section. 3. Group the worksheets. Click File, and then click Print. Below the Print Preview, click Next Page to view the next worksheet.

1. click page layout tab, click margins in setup group, custom margins, horizontally check box, header/footer tab, custom footer, inset file name on the 7 box, click ok 2. click expenditures chart sheet tab, page layout, page setup dialog box launcher, header/footer, custom footer, file name (7), ok 3. right click worksheet tab, select all sheets, file, print, below print preview click next page (arrow)

1. Change the Fill of the Chart Area to the picture 3B_Surfers.jpg and then collapse the Fill options. 2. If necessary, expand the Border section. Click the Solid line option button. Set the Width to ​4 pt and then apply Rounded corners.

1. format axis click axis options, chart area, chart options click the first button (fill and line), fill, picture or texture fill, insert picture from click file, click the file 3B_surfers, insert, click fill again 2. border, solid line, width type 4, click rounded corners at bottom

1. Modify the labels of the Horizontal (Category) Axis labels in the line chart so that the years in the range B4:F4 display. 2. Modify the Vertical (Value) Axis so that Minimum bound is 4000000. 3. Modify the Vertical (Value) Axis so that the Major unit is 2000000.

1. horizontal (category) axis, right click, select data, edit in Horizontal axis labels, select range B4:F4, ok 2. right click vertical axis, format axis, minimum type number, enter 3. type number, enter in major

1. On the Page Layout tab, in the Themes group, click Colors, and then click Orange. 2. In the row header area, select rows 8:24, right-click over the selection, and then click Insert to insert the same number of blank rows as you selected. 3. Select the range A5:F5. On the Insert tab, in the Charts group, click Insert Line or Area Chart. Under 2-D Line , click Line with Markers. 4. Point to the chart title and right-click. Click Font and then format the chart title with Bold. Change the title Font Color to Black, Text 1​— in the second column, the first color.

1. page layout, click colors, click orange 2. in row header (far left) select 8-24, right click, click insert 3. select the range and then click the insert tab, charts group click line or area chart, under 2-D line click line with markers 4. right click title, font, font style bold, font color arrow black text 1, click ok

1. Format the Major Gridlines with a 1 pt Solid line using the default color. 2. Format the font of the ​Vertical (Value) Axis​ with a Font style of ​Bold​ and a Font color of ​Black, Text 1.​ 3. Format the font of the ​Horizontal (Category) Axis​ with a Font style of ​Bold​ and a Font color of ​Black, Text 1​.

1. right of chart click chart elements, point to gridlines, click the arrow and then click more options, click solid line, width 1 2. vertical axis, right click, font, font style bold, font color black text 1, ok 3. horizontal axis, right click, font, font style bold, font color black text 1, ok

1. Select the range A15:B17, and then on the Insert tab, in the Charts group, click Insert Waterfall, Funnel, Stock, Surface, or Radar Chart. Click Funnel to insert a funnel chart. 2. Change the Height of the chart to 2.5 inches and the Width to 4 inches. 3. Add Promotional Event as the chart title.

1. select range A15:B17, insert, charts group click insert waterfall, then click funnel 2. chart tools format tab, size group click shape height box, type 2.5, and press enter shape width box type 4, and then press enter 3. chart title change

1. In the Advertising sheet, select the range A3:B8, and then on the Insert tab, in the Charts group, click Maps, and then click Filled Map. 2. Add Tourism Advertising by State as the chart title. 3. Change the Height of the chart to 2 inches and the Width to 4 inches.

1. select range, insert tab, charts group click maps, filled map 2. literally just type in the title 3. format tab, size group click shape height box, type 2, enter, shape width box type 4, enter

1. Copy ​the range​ ​B13:F13​ and then paste the ​Values & Number Formatting​ to ​B18. 2. Change the value in cell B10 to 21%. 3. Copy ​the range​ ​B13:F13​, and then paste the ​Values & Number Formatting​ to cell ​B19​. Cancel the moving border.

1. select the range, right click and then click copy, click B18, right click, paste special, click the second button (values and number formatting) under paste value 2. just type 21 in the cell 3. select the range, right click, copy, click B19, right click, paste special, paste value click values and number formatting then press ESC

Select the range A5:A10, hold down CTRL and select the range C5:C10. With both ranges selected, on the Insert tab, in the Charts group, click Insert Pie or Doughnut Chart. Under 3-D Pie, click the 3-D Pie. On the Design tab, in the Location group, click Move Chart. In the Move Chart dialog box, click the New sheet option button. Type Expenditures Chart and click OK.

easy

To the right of the chart, click Chart Elements, and then click Legend to clear the check box and remove the legend from the chart. Point to Data Labels, and then click the arrow to display a menu. Click More Options. In the Format Data Labels pane, under Label Options, click to select the Category Name and Percentage check boxes. Click to clear any other check boxes in this group. Under Label Position, click the Center option button.Close the task pane, if necessary. With the data labels selected, point to one of the data labels,right-click, and then click Font. Apply Bold Italic and change the Font Size to 11.

right click on any of them for the last step, click font, font style to whatever it's asking and same for size