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

To modify a specific element of a chart, you must first select it.

Which of the following would you use if you wanted to create a basic block arrow?

A(n) ____________________ is a graphical representation of worksheet data.

All the elements of a chart are contained in every chart, regardless of the type.

When you click the Charts group dialog box launcher, the New Chart dialog box opens.

An embedded chart allows you to view or print the chart along with its source data.

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. When changing the chart style using the Chart Tools Design tab, the color options Billie Ruth has available depend on ____.

You can move a chart to a(n) ____________________, which is a separate sheet in the workbook.

FIGURE EX 4-1 As shown in Figure EX 4-1 above, which chart element is currently selected?

Which of the following extends from the vertical or horizontal axes across the plot area of a chart?

To remove a sparkline from a cell, click the ____ button in the Group group on the Sparkline Tools Design tab.

FIGURE EX 4-1 In Figure EX 4-1 above, which group contains options for displaying, hiding, and specifying the location of chart elements?

The legend on a chart is in a fixed position and cannot be moved.

By default, a newly created chart is placed in the worksheet as a(n) ____.

The commands used to insert graphics such as pictures and clip art are located on the Insert tab in the ____ group.

The options available in the Format dialog box depend on which chart element you have selected.

If the worksheet data is changed, Excel automatically updates the chart.

When you insert a SmartArt graphic, a ____ is also displayed to help simplify the process of entering text.

You can use ____ to easily create interesting text effects in a variety of shapes and unusual alignments.

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. The easiest way for Trey to create an organization chart would be to use ____.