Exam 9: Excel 4: Working With Charts

A chart must be located in a specific cell or at a specific address range.

You can format the text in a chart object using the Home tab or the Mini toolbar.​

The Quick Chart tool recommends charts based on the selected data.​ ____________________

To base a chart on data in nonadjacent ranges, press and hold [Ctrl] while selecting each range.​

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

You can add a text box using the Chart Tools ____ tab.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

On a chart created in Excel, the vertical axis is also called the ____.

The x-axis and y-axis are, respectively, the ____.

A collection of related data points is called a ____.

Discuss the guidelines that you should use for planning a chart.

Any data changed in the worksheet is automatically updated in the chart.

In a pie chart, slices that are pulled away are said to be ____.

Which two charts compare trends over time intervals?

You can resize a chart to improve its appearance by dragging its sizing handles . _________________________

To add a shadow to an object, click the ____ button in the Format Chart Title pane, click Shadow, and make the desired selections.

Moving a chart to a different sheet in the workbook will not change the original data reflected in the chart.​

Which of the following will NOT be affected or rearranged by choosing a new layout on the Chart Tools Design tab?