Exam 6: Excel Lesson 4: Working With Charts and Graphics

You can resize a chart by selecting it and then dragging one of the dotted sizing handles.

The Change Chart Type button is located in the Type group on the Chart Tools Layout tab.

You can choose to display horizontal or vertical gridlines across the plot area of a chart by clicking the Gridlines button in the Axes group on the Chart Tools ____________________ tab.

A ____ is a dot, bar, or a symbol used to represent one number from the worksheet.

What is the purpose of a chart title? Name as many ways as you can think of to format or modify a chart title, including the location of the options or the process.

When you select a chart, the corresponding data on the worksheet is ____.

To change the location of a chart, you can click the ____ button in the Location group of the Chart Tools Design tab.

____________________ are miniature charts that are embedded in the background of a single cell.

To move a selected chart within a worksheet, you can click its ____ and drag it to a new location.

____________________ is a drawing tool that turns words into a graphics image.

SmartArt is a predesigned diagram made up of shapes containing text that illustrates a concept or idea.

How many types of sparklines are there?

Case EX 4-1 Billie Ruth created a bar chart using sales data from last quarter. Now she wants to modify the chart using the Chart Tools Design tab. Which of the following tasks can Billie Ruth not perform using the Chart Tools Design tab?

When you select one data point on a chart, the entire data series is selected.

Case EX 4-2 The small company that Trey works for has just hired several new employees. His supervisor asks Trey to create an organization chart for the company using Excel. When creating an organization chart, Trey would begin by using the ____ tab on the Ribbon.

The first step in creating a chart is to select the ____.

Sparklines refer to shapes, curves, and lines that you create in the worksheet by selecting a shape and then clicking and dragging.

To make any chart with axes easier to read, you can choose to display gridlines .

Which of the following is not a contextual tab that is displayed after you create a chart?