Excel Chapter 12 Charts

Which chart type shows values as parts of a whole?

• Column

• Bar

• Area

• Pie

Which tab is selected to build a chart?

• File

• Insert

• Page Layout

• Data

In order to delete a chart, what do you do?

• Click on a label and press the Delete key.

• Click on the white space and press the Delete key.

• Click on the chart graphic and press the Delete key.

• Click on the title of the chart and press the Delete key.

What is a graphical representation of numbers called?

How do you move a chart to a separate worksheet?

• Go to the Page Layout tab, click Move Chart button, click New sheet box, and add the name.

• Drag the chart to the new sheet tab.

• Go to the Insert tab, click New Chart, and add the name.

• Go to the Design tab, click the Move Chart button, click New sheet box, and add the name.

Which chart is useful for comparing values across categories or a time period?

• column

• line

• pie

• scatter

How do you change the orientation of the rows and columns in a chart?

• Go to the Design tab, then Switch Row/Column button.

• Go to the Insert tab, then Switch Row/Column button.

• Go to the Page Layout tab, then Effects.

• Go to the Format tab, then Quick Styles.

What is the box on the side of a chart that identifies patterns and colors that are assigned to data or categories?

• Axis title

• Chart title

• Data Labels

• Legend

How do you adjust the data series in a chart from Chart Tools?

• Go to the Format tab and Format Selection.

• Go to the Design tab and Add Chart Elements.

• Go to the Design tab and Change Chart Type.

• Go to the Design tab and Select Data.

What is the button called that allows you to adjust the data series in a chart on a worksheet?