Chapter 2 Simnet Guaranteed Success
Move the selected chart to a new chart ✔️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
Add column Sparkles to cells F2:F11 to represent the values in B2:E11 ✔️You clicked the Quick Analysis
Tool button, clicked the Sparklines tab header, and clicked the column button.
move the selected chart ti the empty area of the worksheet below the data ✔️you dragged the chart to
the left(by 4 columns) and down (by 4 rows)
filter the chart so the lines for Dr. Patella and John Patterson are hidden ✔️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
in 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
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 sparkles menu item
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.
hide the chart title ✔️you launched the chart elements menu. in the mini toolbar, you unchecked the
chart title check box
switch the rows and columns in the chart, so the data points are grouped into data series by year ✔️in
the design ribbon tab you clicked the switch row/column button
Move the selected chart to a new chart ✔️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
Add column Sparkles to cells F2:F11 to represent the values in B2:E11 ✔️You clicked the Quick Analysis
Tool button, clicked the Sparklines tab header, and clicked the column button.
move the selected chart ti the empty area of the worksheet below the data ✔️you dragged the chart to
the left(by 4 columns) and down (by 4 rows)
filter the chart so the lines for Dr. Patella and John Patterson are hidden ✔️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
in 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
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 sparkles menu item
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.
hide the chart title ✔️you launched the chart elements menu. in the mini toolbar, you unchecked the
chart title check box
switch the rows and columns in the chart, so the data points are grouped into data series by year ✔️in
the design ribbon tab you clicked the switch row/column button
