Ch. 3 Assessment Excel 2016 IP

9 September 2022
4.7 (114 reviews)
15 test answers

Unlock all answers in this set

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