Ch. 3 Assessment Excel 2016 IP

Apply the Style 7 Quick Style to the chart.

In the Design Ribbon Tab in the Chart Styles Ribbon Group, you expanded the Chart Styles Gallery. In the Design Ribbon Tab in the Chart Styles Ribbon Group in the Chart Styles menu, you clicked the Style 7 gallery option.

Clear the selected Sparklines from the worksheet.

In the Design Ribbon Tab in the Group Ribbon Group, you clicked the Clear button arrow. In the Clear menu, you clicked the Clear Selected Sparklines menu item.

The Anne Cole data point has been selected for you. Explode the Anne Cole data point by exactly 50% to move it away from the rest of the pie chart.

In the Format Ribbon Tab in the Current Selection Ribbon Group, you clicked the Format Selection button. Inside the Format Data Point dialog from the Trendline options list, you clicked the Series Options list item, typed 50 in the Point Explosion input, and pressed the Enter key.

The 2019 data point in the Gross Profit data series has been selected. Change the outline width to 2 1/4 pt.

In the Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Outline button arrow. In the Shape Outline menu in the Weight menu, you selected the 2 1/4 pt option.

Change the shape outline color to Orange, Accent 2. It is the sixth option in the first row of the color palette.

In the Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Outline button arrow. In the Shape Outline menu, you selected the Orange, Accent 2 color option.

The chart title is selected. Apply the Fill: Blue, Accent color 1; Shadow WordArt quick style (the second style in the first row of the WordArt Quick Styles gallery).

In the Format Ribbon Tab in the WordArt Styles Ribbon Group in the WordArt Styles menu, you selected the Fill: Blue, Accent color 1; Shadow option.

Insert a Waterfall chart based on cells A1:B10.

In the Insert Ribbon Tab in the Charts Ribbon Group, you clicked the Insert Charts Group Dialog Launcher dialog launcher. You clicked the All Charts tab. Inside the Insert Chart dialog from the Chart Type list, you selected Waterfall. Inside the Insert Chart dialog, you clicked the OK button.

Create a 3-D pie chart from the selected data.

In the Insert Ribbon Tab in the Charts Ribbon Group, you clicked the Insert Pie or Doughnut Chart button. In the Insert Pie or Doughnut Chart menu, you selected the 3-D Pie option.

Add column Sparklines to cells F2:F11 to represent the values in B2:E11.

In the Insert Ribbon Tab in the Sparklines Ribbon Group, you clicked the Column button. Inside the Create Sparklines dialog, you typed F2:F11 in the Location Range input, clicked the OK button.

Apply the Colored Fill - Green, Accent 6 Quick Style to the shape. It is the last option in the second row of the gallery.

In the Mini Toolbar, you clicked the Fill button, clicked the Style button. In the Shape Styles Gallery menu, you selected the Colored Fill - Green, Accent 6 option.

The 2019 data point in the Gross Profit data series has been selected. Change the fill color to Green, Accent 6 (it is the last option in the first row under Theme Colors).

In the Mini Toolbar, you clicked the Fill button. In the Shape Fill menu, you selected the Green, Accent 6 color option.

Change the gridlines to use the Dash (dash style).

Right-clicked the Chart Element chart element. In the Gridlines Right-Click menu, you clicked the Format Gridlines... menu item. Inside the Format Major Gridlines dialog from the Format Gridlines list, you clicked the Dash type item. In the chart Gridlines Dashes menu, you selected the Dash option.

Insert a Line chart based on the first recommended chart type.

You clicked the Quick Analysis Tool button, clicked the Charts tab header, and clicked the Line button.

Move the selected chart to the empty area of the worksheet below the data.

You dragged the chart to the left (by 4 columns) and down (by 4 rows).

Display the data labels on this chart above the data markers.

You launched the Chart Elements menu. In the Mini Toolbar in the Data Labels menu, you clicked the Above menu item.