OL 211 FINAL PROJECT PRACTICE TEST 2026
QUESTIONS WITH ANSWERS GRADED A+
◉ Apply the Colored Fill Green, Accent 6 Quick Styles to the shape...
Answer: On the Drawing tools Format tab, in the Shape Styles group,
click the More button to display the gallery. Click the Colored Fill -
Green, Accent 6 Quick Style.
◉ Add column Sparklines to cells F2:F11 to represent the values in.
Answer: Click the Quick Analysis Tool button and click the
Sparklines tab. Click Column.
◉ The Anne Cole data point has been selected for you. Rotate.
Answer: On the Charts Tools Format tab, in the Current Selection
group, click the Format Selection button to open the Format Data
Point task pane. In the Angle of first slice box, type the 200 and press
Enter.
◉ Change the shape fill color to Green, Accent 6, Lighter 40%.
Answer: On the Drawing Tools Format tab, in the Shape Styles group,
click the Shape Fill button. Click Green, Accent 6, Lighter 40%
◉ Apply the Monochromatic Palette 1 color scheme... Answer: Click
the Chart Tools Design tab. In the Chart Styles group, click the
,Change Colors button. Click the Monochromatic Palette 1, it is the
first option in the Monochromatic section.
◉ Insert a Line chart based on the first recommended chart type.
Answer: Click the Quick Analysis tool button, and then click the
Charts tab. Click Line.
◉ Add a liner trendline to this chart. Use the default trendline
formatting. Answer: Click the Chart Elements button that appears
near the upper right corner of the chart. Click the Trendline check
box to add a checkmark.
◉ Add another data series to the chart to represent gross profit.
Answer: On the Charts Tools Design tab, in the Data group, click the
Select Data button. In the Select Data Source dialog, click the Add
button. Click cell A2 to enter it in the Series name box. Click in the
series values box and delete the default entry. Click and drag cells
B2:D2. Click OK to add the new series. Click OK to accept the change
to the chart data source.
◉ Resize the selected chart so it is approximately 11 rows tall.
Answer: Click and drag a resize handle up or down toward the
center of the chart to make it smaller.
,◉ Insert a clustered column-line combination chart based on the
selector... Answer: On the Insert tab, in the Charts group, click the
Combo Chart button. Click the first chart type in the gallery.
◉ The 2019 data point in the Gross Profit data series has been
selected... Answer: On the Chart Tools Format tab, Shape Styles
group, click the Shape Fill button, and select Green, Accent 6.
◉ Change the gridliness to use the Dash style. Answer: On the Chart
Tools Format tab, in the Shape Styles group, click the Shape Outline
button. Point to Dashes, and select the fourth dash style in the
gallery. (Dash)
◉ The 2019 data point in the Gross Profit data series has been
selected... Answer: On the Chart Tools Format tab, Shape Styles
group, click the Shape Outline button, point to Weight, and select 2
1/4 pt.
◉ Insert a Waterfall chart based on cells A1:B10 Answer: On the
Insert tab, in the Charts group, click the Insert Waterfall or Stock
Chart button. Select Waterfall.
◉ Create a 3-D pie chart from the selected data Answer: Click the
Insert tab. In the Charts group, click the Insert Pie Chart button.
Select the 3-D Pie chart type.
, ◉ The Anne Cole data point has been selected for you. Explode the
Annie Cole.. Answer: On the Chart Tools Format tab, in the Current
Selection group, click the Format Selection button to open the
Format Data Point task pane. In the Point Explosion box, type 50 and
press Enter.
◉ Filter the chart so the lines for Dr.Patella and John Patterson are
hidden. Answer: Click the Chart Filters button. Click the checkboxes
in front of Dr.Patella and John Patterson to remove the check marks.
Click Apply.
◉ Display the data table, including the legend keys. Answer: Click
the Chart Elements button and click the Data Tables check box.
◉ Display the data labels on this chart above the data markers.
Answer: Click the Chart Elements button. Click the Data Labels
arrow and select Above.
◉ Change the shape outline color to Orange, Accent 2. Answer: On
the Drawing Tools Format tab, in the Shapes Styles group, click the
Shape Outline button. Click Orange, Accent 2.
◉ Change the chart typw to the first stacked bar option.. Answer:
Click the Chart Tools Design tab. In the Type group, click the Change
QUESTIONS WITH ANSWERS GRADED A+
◉ Apply the Colored Fill Green, Accent 6 Quick Styles to the shape...
Answer: On the Drawing tools Format tab, in the Shape Styles group,
click the More button to display the gallery. Click the Colored Fill -
Green, Accent 6 Quick Style.
◉ Add column Sparklines to cells F2:F11 to represent the values in.
Answer: Click the Quick Analysis Tool button and click the
Sparklines tab. Click Column.
◉ The Anne Cole data point has been selected for you. Rotate.
Answer: On the Charts Tools Format tab, in the Current Selection
group, click the Format Selection button to open the Format Data
Point task pane. In the Angle of first slice box, type the 200 and press
Enter.
◉ Change the shape fill color to Green, Accent 6, Lighter 40%.
Answer: On the Drawing Tools Format tab, in the Shape Styles group,
click the Shape Fill button. Click Green, Accent 6, Lighter 40%
◉ Apply the Monochromatic Palette 1 color scheme... Answer: Click
the Chart Tools Design tab. In the Chart Styles group, click the
,Change Colors button. Click the Monochromatic Palette 1, it is the
first option in the Monochromatic section.
◉ Insert a Line chart based on the first recommended chart type.
Answer: Click the Quick Analysis tool button, and then click the
Charts tab. Click Line.
◉ Add a liner trendline to this chart. Use the default trendline
formatting. Answer: Click the Chart Elements button that appears
near the upper right corner of the chart. Click the Trendline check
box to add a checkmark.
◉ Add another data series to the chart to represent gross profit.
Answer: On the Charts Tools Design tab, in the Data group, click the
Select Data button. In the Select Data Source dialog, click the Add
button. Click cell A2 to enter it in the Series name box. Click in the
series values box and delete the default entry. Click and drag cells
B2:D2. Click OK to add the new series. Click OK to accept the change
to the chart data source.
◉ Resize the selected chart so it is approximately 11 rows tall.
Answer: Click and drag a resize handle up or down toward the
center of the chart to make it smaller.
,◉ Insert a clustered column-line combination chart based on the
selector... Answer: On the Insert tab, in the Charts group, click the
Combo Chart button. Click the first chart type in the gallery.
◉ The 2019 data point in the Gross Profit data series has been
selected... Answer: On the Chart Tools Format tab, Shape Styles
group, click the Shape Fill button, and select Green, Accent 6.
◉ Change the gridliness to use the Dash style. Answer: On the Chart
Tools Format tab, in the Shape Styles group, click the Shape Outline
button. Point to Dashes, and select the fourth dash style in the
gallery. (Dash)
◉ The 2019 data point in the Gross Profit data series has been
selected... Answer: On the Chart Tools Format tab, Shape Styles
group, click the Shape Outline button, point to Weight, and select 2
1/4 pt.
◉ Insert a Waterfall chart based on cells A1:B10 Answer: On the
Insert tab, in the Charts group, click the Insert Waterfall or Stock
Chart button. Select Waterfall.
◉ Create a 3-D pie chart from the selected data Answer: Click the
Insert tab. In the Charts group, click the Insert Pie Chart button.
Select the 3-D Pie chart type.
, ◉ The Anne Cole data point has been selected for you. Explode the
Annie Cole.. Answer: On the Chart Tools Format tab, in the Current
Selection group, click the Format Selection button to open the
Format Data Point task pane. In the Point Explosion box, type 50 and
press Enter.
◉ Filter the chart so the lines for Dr.Patella and John Patterson are
hidden. Answer: Click the Chart Filters button. Click the checkboxes
in front of Dr.Patella and John Patterson to remove the check marks.
Click Apply.
◉ Display the data table, including the legend keys. Answer: Click
the Chart Elements button and click the Data Tables check box.
◉ Display the data labels on this chart above the data markers.
Answer: Click the Chart Elements button. Click the Data Labels
arrow and select Above.
◉ Change the shape outline color to Orange, Accent 2. Answer: On
the Drawing Tools Format tab, in the Shapes Styles group, click the
Shape Outline button. Click Orange, Accent 2.
◉ Change the chart typw to the first stacked bar option.. Answer:
Click the Chart Tools Design tab. In the Type group, click the Change
