Multiple Choice Questions

You clicked the Quick Analysis Tool button, clicked the Charts tab header, and clicked the Line button.
  • Insert a Waterfall chart based on cells A1:B10.
  • Display the data labels on this chart above the data markers.
  • Move the selected chart to the empty area of the worksheet below the data.
  • Insert a Line chart based on the first recommended chart type.
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.
  • Apply the Colored Fill - Green, Accent 6 Quick Style to the shape. It is the last option in the second row of the gallery.
  • Apply the Style 7 Quick Style to the chart.
  • Create a 3-D pie chart from the selected data.
  • Insert a Waterfall chart based on cells A1:B10.
In the Mini Toolbar, you clicked the Fill button. In the Shape Fill menu, you selected the Green, Accent 6 color 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).
  • Apply the Colored Fill - Green, Accent 6 Quick Style to the shape. It is the last option in the second row of the gallery.
  • The 2019 data point in the Gross Profit data series has been selected. Change the outline width to 2 1/4 pt.
  • 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 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.
  • 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.
  • The 2019 data point in the Gross Profit data series has been selected. Change the outline width to 2 1/4 pt.
  • Change the shape outline color to Orange, Accent 2. It is the sixth option in the first row of the color palette.
  • 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 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.
  • Insert a Waterfall chart based on cells A1:B10.
  • Add column Sparklines to cells F2:F11 to represent the values in B2:E11.
  • Apply the Style 7 Quick Style to the chart.
  • Create a 3-D pie chart from the selected data.
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.
  • Change the shape outline color to Orange, Accent 2. It is the sixth option in the first row of the color palette.
  • The 2019 data point in the Gross Profit data series has been selected. Change the outline width to 2 1/4 pt.
  • 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.
  • 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 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.
  • Change the shape outline color to Orange, Accent 2. It is the sixth option in the first row of the color palette.
  • The 2019 data point in the Gross Profit data series has been selected. Change the outline width to 2 1/4 pt.
  • Add column Sparklines to cells F2:F11 to represent the values in B2:E11.
  • Create a 3-D pie chart from the selected data.
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.
  • Apply the Colored Fill - Green, Accent 6 Quick Style to the shape. It is the last option in the second row of the gallery.
  • 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).
  • Change the shape outline color to Orange, Accent 2. It is the sixth option in the first row of the color palette.
  • The 2019 data point in the Gross Profit data series has been selected. Change the outline width to 2 1/4 pt.
You launched the Chart Elements menu. In the Mini Toolbar in the Data Labels menu, you clicked the Above menu item.
  • Insert a Line chart based on the first recommended chart type.
  • Move the selected chart to the empty area of the worksheet below the data.
  • Change the gridlines to use the Dash (dash style).
  • Display the data labels on this chart above the data markers.
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0