Lesson 12

Which chart type shows values as parts of a whole?

• Pie

• Area

• Bar

• Column

Which chart type appears on a worksheet with other data?

• Mixed

• Custom

• Embedded

• Chart sheet

Which part of a chart do you click when you want to select the entire chart?

• Chart title

• Chart area

• Legend

• Plot area

Which of the following happens to a chart when the source data is deleted?

• Nothing

• The chart will move to the area where the data was located

• The data in the chart is deleted

• You will be asked if you want to delete the chart

Which of the following is the first step that should be taken when creating a chart?

• Provide a name for the chart

• Choose the data labels that will be used in the chart

• Select the chart type

• Selecting the range of cells that contain the data the chart will use

When you want to print only the chart in a worksheet, which of the following steps should be taken before printing?

• You cannot print only the chart if it is part of a larger worksheet

• Move the chart to a new sheet by itself and then print that sheet

• Select the Print chart only option in the Page Setup dialog box

• Click the chart to select it and then print

A bar chart represents values as which of the following?

• Vertical lines

• Horizontal bars

• Horizontal lines

• Vertical bars

A column chart represents values as which of the following?

• Vertical bars

• Horizontal bars

• Horizontal lines

• Vertical lines

Which of the following steps should be performed to move a chart from a worksheet to a chart sheet?

• You cannot move the chart after it has been created

• Cut the chart from the worksheet and paste it to a new workbook sheet

• Use the Move Chart button on the Design tab

• Use the move handles and drag it to the new location

Which of the following statements is not true?

• When a chart sheet is created, the chart no longer appears on the worksheet containing the data series

• You must delete an existing chart in order to have the data displayed in a different chart type

• You can use the sizing handles to change the height and width of a chart

• You can change both the height and width of a chart with commands on the Format tab