Exam 14: Excel Lesson 8: Working With Charts

You can use the Ribbon to select chart elements. Click the Format tab or the ____ tab on the Ribbon. In the Current Selection group, click the arrow next to the Chart Elements box.

____ charts are also used to illustrate a company's market share in comparison to its competitors.

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.

A selected chart element is surrounded by a ____.

A chart template formats the chart based on the colors, fonts, and effects associated with the workbook's theme.

To create a sparkline, in the Sparklines group on the ___________________ tab, click the button corresponding to the type of sparkline you want to create.

All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.

In Excel, the chart data, called the record source , is stored in a range of cells in the worksheet.

When you select the chart style, click a 3-D chart subtype to create a 3-D chart.

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace now has the Move Chart dialog box open and wants to name her new chart sheet. Where does she fill in the new name?

The chart element called ____ is the graphical representation of all of the data series.

You can keep a chart's height and width in the same proportion by pressing the Shift key as you drag a corner sizing handle.

A(n) ____________________ chart uses bars of varying heights to illustrate values in a worksheet.

To make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box.

You open the Insert Chart dialog box by clicking the Dialog Box Launcher in the ____ group on the Insert tab.

The chart types are available on the ____ tab in the Charts group.

When you select the data source for a chart, you should also include the text you want to use as labels in the chart.

You can delete a selected chart by pressing the F2 key.

To access the Format dialog box, select the chart you want to edit. Then, on the Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____ button.