Deck 9: Excel 4: Working With Charts

Question 1

The area inside the horizontal and vertical axes is the legend . _________________________

Answer 1

False

Question 2

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

Answer 2

True

Question 3

A bar chart and column chart are equivalent chart types in Excel.

Answer 3

False

Question 4

The Chart Elements button makes it eas y to add, remove, and modify individual chart objects.​

Question 5

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

Question 6

You can print a chart by itself or as part of the worksheet.

Question 7

The horizontal axis is also called the value axis.

Question 8

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

Question 9

The z-axis of 3-D charts is used for comparing data across both categories and values. _________________________

Question 10

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

Question 11

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

Question 12

WordArt can be created using the Chart Tools Format tab.

Question 13

You can use the Quick Analysis tool to create a sparkline.​

Question 14

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

Question 15

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

Question 16

You can create multiple charts based on the same worksheet data.  ____________________

Question 17

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

Question 18

You can use buttons on the Insert tab of the Ribbon to create a chart.

Question 19

Tick marks appear on the horizontal axis of a chart. ____________________​

Question 20

Chart annotations are labels  that further describe your data.​ ____________________

Question 21

Excel includes three kinds of 3-D chart types. ____________________​

Question 22

Which chart type do you use to compare distinct objects over time using horizontal bars?

A) area
B) bar
C) column
D) line

Question 23

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

A) x-axis
B) y-axis
C) data marker
D) legend

Question 24

Each value in a cell selected for a chart is called a ____.

A) data marker
B) tick mark
C) data point
D) data series

Question 25

A collection of related data points is called a ____.

A) data marker
B) tick mark
C) data point
D) data series

Question 26

Sub gridlines show the values between the tick marks in a chart. _________________________

Question 27

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

A) inner
B) embedded
C) sub
D) interactive

Question 28

A(n) ____ identifies each data series in a chart, generally with a different color.

A) axis
B) data point
C) data marker
D) legend

Question 29

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

Question 30

Which chart type is the best candidate for emphasizing sales trends over a period of 6 months?

A) line
B) pie
C) area
D) scatter

Question 31

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

A) horizontal and vertical axes
B) data series and gridlines
C) tick markers and data series
D) vertical and horizontal axes

Question 32

Which chart type is the best candidate for spotting trends and extrapolating information based on research data?

A) pie
B) area
C) scatter
D) hi-low

Question 33

A pie chart ____.

A) compares distinct, unrelated objects over time using a horizontal format
B) compares trends over even time intervals
C) compares trends over uneven time or measurement intervals
D) compares sizes of pieces as part of a whole

Question 34

A scatter chart ____.

A) compares distinct, unrelated objects over time using a horizontal format
B) compares trends over even time intervals
C) compares trends over uneven time or measurement intervals
D) combines a column and line chart to compare data requiring different scales of measure

Question 35

To show how individual volume changes over time in relation to total volume, use a(n) ____.

A) area chart
B) bar chart
C) column chart
D) line chart

Question 36

Which two charts compare trends over time intervals?

A) bar and pie
B) pie and area
C) area and line
D) line and scatter

Question 37

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

A) x-axis
B) y-axis
C) data marker
D) legend

Question 38

____ marks indicate the scale of measure for each value on the y-axis.

A) Datapoint
B) Tick
C) Axis
D) Legend

Question 39

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

A) line
B) area
C) column
D) pie

Question 40

In a pie chart, you can emphasize one data point by plotting , or pulling that slice away from, the pie chart. _________________________

Question 41

You can change a column chart to a clustered bar chart using the ____ dialog box.

A) New Chart Type
B) Chart Category
C) Adjust Type
D) Change Chart Type

Question 42

You can ____ the chart title text to select it.

A) click
B) double-click
C) triple-click
D) right-click

Question 43

Which one of the following is NOT one of the new chart types in Excel 2016?​

A) ​Treemap
B) ​Waterfall
C) ​Sunburst
D) ​Surface

Question 44

The default border color around a chart title is ____.

A) red
B) green
C) black
D) blue

Question 45

An example of a(n) ____ chart is a column chart with a line chart.

A) nested
B) combo
C) complex
D) exploded

Question 46

Text annotations are ____ that you can add to further describe the data in your chart.

A) arrows
B) titles
C) labels
D) notes

Question 47

Acombo  chart can add a(n) ____ axis to chart related data.

A) combo
B) secondary
C) tertiary
D) clustered

Question 48

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

A) Design
B) Layout
C) Format
D) Text

Question 49

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

A) Options
B) Effects
C) Tools
D) Shadow Format

Question 50

In a true 3-D chart, a third axis, called the _____, lets you compare data points across both categories and values.​

A) ​d-axis
B) ​tertiary-axis
C) ​z-axis
D) ​dimensional-axis

Question 51

The chart's ____________________ handles, the small series of dots at the corners and sides of the chart's border, indicate that the chart is selected.

Question 52

To create a combo chart, select the data you want to plot, and click the Combo chart button in the Charts group on the _____ tab.​

A) ​Format
B) ​Insert
C) ​Chart Tools Design
D) ​Format

Question 53

To switch a chart's columns and rows, click the ____________________ button in the Data group on the Chart Tools Design tab.

Question 54

You can quickly create a miniature chart called a(n) ____________________ that serves as a visual indicator of data trends directly within a cell.

Question 55

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

A) data
B) legend
C) titles
D) gridlines

Question 56

Shape ____ make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click.

A) text annotations
B) gridlines
C) markers
D) styles

Question 57

To delete a selected sparkline from a cell, click the _____ button in the Group group on the Sparkline Tools Design tab.​

A) ​Clear
B) ​Remove
C) ​Delete
D) ​Erase

Question 58

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

A) identified
B) exploded
C) opened
D) extracted

Question 59

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

A) SmartArt
B) WordArt
C) ClipArt
D) 3-DArt

Question 60

Which of the following is not an option that the Data Labels can produce?

A) series name
B) category name
C) value of the data point
D) legend name

Question 62

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. You decide to annotate the chart using a callout. What button do you click to do this?
A. the Callout button in the Annotations group on the Insert tab
B. the Notes button in the Annotations group on the Insert  tab
C. the Shapes button in the Annotations group on the Insert  tab
D. the Shapes button in the Illustrations group on the Insert  tab

Question 63

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. You want to use a shape style to change the look of your chart, but first you want see a Live Preview of how it will look. What do you do with the pointer to see a Live Preview?
A. Hover the pointer over the shape style.
B. Double-click the shape style.
C. Right-click the shape style.
D. Triple-click the shape style.

Question 64

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

Question 65

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. In the chart, you want to change the fill of one of the data series in your worksheet. To do this, what list arrow do you use?
A. Shape Fill list arrow in the Shape Styles group on the Chart Tools Format tab
B. Series Fill list arrow in the Series group on the Chart Tools Format tab
C. Fill list arrow in the Data group on the Chart Tools Format tab
D. Series Fill list arrow in the Data group on the Chart Tools Format tab

Question 66

Data ____________________ appear next to data markers in a chart and can indicate the series name, category name, and/or the value of one or more data points.​

Question 67

When the mouse pointer hovers over any chart object, the name of the selected object appears on screen as a(n) ____________________.

Question 69

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. You want to preview just the chart before you print the chart sheet. What command do you use?
A. Preview on the Print tab
B. Print on the File tab
C. Sneak Peek on the Print tab
D. Display on the File tab

Question 70

Describe four commonly used Excel chart types.

Question 72

Critical Thinking Questions Case 1-1 You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. If you want to reposition the chart by changing a page's margins, where do you find the Show Margins button to display the margins in preview?
A. Margins tab
B. File tab
C. Print tab
D. Display tab

Question 74

Explain what a combination chart is and how you can create one.