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

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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

A) Chart Tools Design
B) Chart Tools Style
C) Chart Tools Layout
D) Chart Tools Format

Answer 3

B

Question 4

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

Question 5

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

Question 6

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

Question 7

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

A) data marker
B) legend
C) title
D) gridlines

Question 8

Charts and graphics add visual impact to worksheets and help convey the meaning of worksheet data.

Question 9

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

Question 10

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

A) data marker
B) data series
C) vertical axis
D) horizontal axis

Question 11

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

Question 12

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

Question 13

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

Question 14

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

A) data marker
B) data series
C) data source
D) data area

Question 15

When you click a button on the Charts group of the ____ tab, the subtypes available for that type of chart are displayed.

A) Home
B) Insert
C) Page Layout
D) Review

Question 16

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

Question 17

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

Question 18

The data marker in a chart is a list that identifies the patterns or colors of the data series or categories in a chart.

Question 19

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

Question 20

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

Question 21

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.

A) Home
B) Insert
C) Page Layout
D) Review

Question 22

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?

A) Move the chart to another worksheet
B) Sesize the chart
C) Change the type of chart
D) Apply a quick layout

Question 23

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

A) Remove
B) Delete
C) Undo
D) Clear

Question 24

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

A) title
B) data source
C) border
D) legend

Question 25

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 ____.

A) which chart type is selected
B) the overall layout of the chart
C) which theme is applied to the workbook
D) whether WordArt has been added

Question 26

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

A) color-coded
B) hidden
C) surrounded by a rotating border
D) saved

Question 27

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

A) Pictures
B) Clip art
C) Drawing objects
D) SmartArt graphics

Question 28

How many types of sparklines are there?

A) One
B) Two
C) Three
D) Four

Question 29

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

A) ScreenTip
B) Text Pane
C) drawing object
D) blank line

Question 30

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

A) WordArt
B) drawing objects
C) clip art
D) SmartArt

Question 31

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

A) chart sheet
B) drawing object
C) SmartArt graphic
D) embedded chart

Question 32

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

A) Change Location
B) Move Chart
C) Chart Sheet
D) Move Location

Question 33

To resize a chart proportionally, press and hold ____ while dragging a corner handle.

A) Ctrl
B) Alt
C) Shift
D) Tab

Question 34

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

Question 35

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 ____.

A) clip art
B) WordArt
C) SmartArt graphics
D) sparklines

Question 36

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

A) Pictures
B) Graphics
C) Illustrations
D) Visual

Question 37

When you select the chart title, the text is also displayed in the ____.

A) formula bar
B) legend
C) plot area
D) data source

Question 38

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

A) Current Selection
B) Insert
C) Labels
D) Background

Question 39

When you position the pointer on a chart element, a ____ appears.

A) shortcut menu
B) ScreenTip
C) data series
D) color-coded rectangle

Question 40

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

A) Chart Area
B) Plot Area
C) Data Series
D) Axis Titles

Question 42

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

Question 43

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.

Question 44

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

Question 45

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.

Question 46

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