Chapter 2 Simnet

9 September 2022
4.7 (114 reviews)
12 test answers

Unlock all answers in this set

Unlock answers (8)
question
Move the selected chart to a new chart
answer
you right clicked the underlined chart. In the Chart Right-Click menu, you clicked the Move Chart menu item. Inside the Move Chart dialog, you selected the New Sheet: Radio Button, clicked OK button
question
Add column Sparkles to cells F2:F11 to represent the values in B2:E11
answer
You clicked the Quick Analysis Tool button, clicked the Sparklines tab header, and clicked the column button.
question
move the selected chart ti 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
filter the chart so the lines for Dr. Patella and John Patterson are hidden
answer
you launched the Chart Filter menu. in the Mini Toolbar, you unchecked the Dr.Patella check box, unchecked the John Patterson check box. You clicked the apply button
question
in 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
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 sparkles menu item
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
hide the chart title
answer
you launched the chart elements menu. in the mini toolbar, you unchecked the chart title check box
question
switch the rows and columns in the chart, so the data points are grouped into data series by year
answer
in the design ribbon tab you clicked the switch row/column button
question
change the chart type to the first stacked bar option (the second option along the top of the right pane)
answer
in the design ribbon tab in the type ribbon group, you clicked the change chart type button, inside the cage chart type dialog from the chart type list, you selected bar. inside the change chart type dialog from the bar chart list, you clicked the stacked bar item, inside that change chart type dialog, you clicked the ok button
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
display the data table, including the legend keys
answer
you launched the chart elements menu. In the mini toolbar in the data take menu, you clicked the with legend keys menu item