Excel Chapter 3

Where does the primary axis display on a Combo chart? A) Left side B) Right side C) Top D) Bottom

Left Side

What does Excel not determine about the value axis when you create a chart? A) Average value B) End value C) Start value D) Incremental value

Average Value

Which chart type displays the data horizontally? A) Pie B) Column C) Bar D) Radar

Bar

Which chart type is preferable when the category names are long? A) Bar B) Column C) Stacked column D) Pie

Bar

Which chart type cannot be displayed as a sparkline? A) Line chart B) Column C) Bar chart D) Win/Loss

Bar Chart

If your chart is intended for presentation, as opposed to printing, you should use a(n) ________ background.

Black

What can you not do from the Select Data Source Dialog box? A)Add chart data series B)Delete a data series C)Change chart data range D)Change chart type

Change chart type

What icon is not displayed when you select a chart? A) Chart Types B) Chart Filters C) Chart Styles D) Chart Elements

Chart Types

Which of the following is not a chart element? A) Chart title B) Chart foreground C) Axis title D) Gridlines

Chart foreground

What is not found on the Chart Elements List? A) Chart Type B) Legend C) Gridlines D) Data Table

Chart type

Which of the following is not a chart type? A)Bar B)Pie C)Circle D)Line

Circle

What chart type can display two different chart types at the same time? A) Multiple B) Combination C) Combo D) Mixed

Combo

Which chart type is best when you want to chart two unrelated data types? A) Line chart B) Radar chart C) Combo chart D) Pie chart

Combo Chart

To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.

Ctrl

Which group on the Design tab would you select if you wanted to change the source information in the chart? A) Format B) Data C) Insert D) Series

Data

Which of the following is not a chart element? A)Chart Area B)Data Area C)Legend D)Plot Area

Data Area

A(n) ________ is a cell that contains a value used in a chart.

Data point

True or False:A chart sheet can hold, at most, two charts.

False

True or False:A parallel range is one that consists of the same starting point of another range, but can have a different end point.

False

True or False:A stacked column chart displays multiple columns for each category.

False

True or False:As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

False

True or False:Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.

False

True or False:The range used for a sparkline cannot include more than one row.

False

True or False:To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

False

True or False:To understand a chart you need to include the chart data.

False

True or False:When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

False

What group is not found on the Sparkline Tools Design tab? A) Format B) Type C) Style D) Show

Format

Which chart element cannot be chosen from the Chart Elements dialog box? A) Format Back Wall B) Error Bars C) Chart Title D) Axis Titles

Format back wall

A bar chart uses ________ bars.

Horizontal

Which tab displays the tools for creating charts? A) Insert B) View C) Chart D) Data

Insert

What is not true about an effective chart? A)It always contains more than one series B)It is useful C)It is easy to understand D)It is clear

It always contains more than one series

Which chart type is not listed in the All Charts window? A) Waterfall B) Sparkline C) Treemap D) Histogram

Sparkline

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline? A) Sparkline B) Show C) Style D) Type

Sparkline

In a pie chart which of the following is a good reason for using category data labels rather than the legend? A) They are easier to format. B) They take up less space. C) They are easier to read. D) They reveal more information.

They are easier to read

True or False: Sparklines do not include the normal chart labels.

True

True or False:Effective charts never overwhelm an audience.

True

True or False:Even after selecting a data source for a chart you can still apply various filters on one or more series.

True

True or False:Excel normally uses all the selected data in creating a chart.

True

True or False:It is important to select parallel ranges.

True

True or False:Pie charts can only display one data series.

True

True or False:You can link to a cell as the title of a chart.

True

True or False:You can switch the rows and columns in a chart to communicate a different perspective on your data.

True

True or False:You cannot enter data or formulas on a chart sheet.

True

True or False:You might want to avoid using 3-D charts because they can distort the appearance of the data.

True

Which axis in a chart displays incremental numbers for the data points? A)Data B)Category C)Value D)Series

Value

In a bar chart, which axis displays the categories? A) X B) Vertical C) Horizontal D) Z

Vertical

What should you not select when selecting data form charts? A)Worksheet Titles B)Column Labels C)Data D)Row Labels

Worksheet titles

________ charts are often used to represent data in educational, scientific, and medical experiments.

XY Scatter

The ________ axis helps measure data from top to bottom in a chart.

Y

The ________ axis is the vertical axis.

Y

In a column chart the horizontal axis displays the ________.

categories

Excel uses ________ to determine what categories are visible in a chart.

chart filters

In a(n) ________ column chart data appears as side by side columns.

clustered

If you wanted to show trends over set periods of time, you probably want to use a(n) ________ chart.

line

If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.

recommended

A data ________ is a group of related data points.

series

A group of data points used in a graph become a data ________.

series

A(n) ________ column chart displays the relationship of data points to the whole category.

stacked

Picking a chart ________ will allow you to change several formatting elements at the same time.

style

True or False:When you want to chart two related types of data, the Combo chart is perfect.

true

The ________ axis helps measure data from left to right in a graph.

x

Including what, distorts the effectiveness of charting data points? A)Too many data points B)Too many series C)Too much variance in the values of the data D)Aggregates

Aggregates

In the task pane, what does a diagonal black triangle next to a chart category indicate? A) Every option for this category have already been chosen. B) None of the category's options are displayed. C) There are no options for this category. D) All the category's options are displayed.

All of the category's options are displayed

Match the following terms with their description: I. Data label II. Data point III. Data series IV. Data table V. Legend A. A group of data points B. Shows the precise value of a data point C. Helps to distinguish between various data series D. A precise value in a chart E. A grid used to plot data in a chart

1.B 2.D 3.A 4.E 5.C

Match the following terms with their description: I. Parallel range II. Alt Text III. Exploded pie chart IV. Arrange V. Chart filter A. Text based interpretation B. Moves an object backward or forward C. Has the same starting and ending point D. Helps you to focus on particular data E. One or more pieces are separated from the others

1.C 2.A 3.E 4.B 5.D

Match the following terms with their description: I. Radar II. Histogram III. Area IV. X Y (scatter) chart V. Combo chart A. Often used in educational, scientific, and medical experiments B. Similar to a column chart C. Used for two different but related data types D. Spokes radiate from the center to the outer edges E. Similar to a line chart

1.D 2.B 3.E 4.A 5.C

Match the following terms with their description: I. Line chart II. Pie chart III. Bar chart IV. Column chart V. Sparkline A. Uses horizontal bars B. Chart resides in one cell C. Line connect data points D. Uses slices to display data points E. Uses vertical bars

1.c 2.d 3.a 4.e 5.b

Match the following terms with their description (since the options are very similar, pick the most complete, descriptive answer): I. Clustered column chart II. Stacked column chart III. Column chart IV. 100% stacked column chart V. 3-D chart A. Changes individual data points to percentages B. Adds an additional dimension to your chart C. Columns are set side by side D. Compares individual points to the whole category E. Compares values across categories

1.c 2.d 3.e 4.a 5.b

Match the following terms with their description: I. X-axis II. Y-axis III. Chart area IV. Plot area V. Legend A. Holds the entire chart B. Vertical border C. Uses color or patterns to identify each data series D. Horizontal border E. Both axes form a border for this

1.d 2.b 3.a 4.e 5.c

Match the following terms with their description: I. Data labels II. Quick Layout III. Accessibility Compliance IV. Alt Text V. Sparklines A. Applying features to make it easier on disabled users B. Can be read by various devices C. Helps you use predefined layouts D. Easier to read than a legend E. Examples include: line, column, win/loss.

1.d 2.c 3.a 4.b 5.e

Match the following terms with their description: I. Chart element II. Chart filter III. Chart sheet IV. Chart style V. Chart title A. Decides what is hidden or displayed in a chart B. Sets the formatting of the chart C. Contains no spreadsheet data D. Describes the entire chart E. This helps make a chart clearer.

1.e 2.a 3.c 4.b 5.d

How many variations of the stock chart does Excel have? A)1 B)2 C)3 D)4

4

As a general rule, Pie charts should be limited to how many slices? A) 9 B) 11 C) 5 D) 7

7

Column charts are the most effective when they have ________ or fewer categories.

7

How many sizing handle are found on embedded charts? A) 8 B) 6 C) 4 D) 10

8

In a stacked column chart the data must be ________.

Additive

In the task pane, what does a diagonal white triangle next to a chart category indicate? A) There are no options for this category. B) All the category's options are displayed. C) Every option for this category have already been chosen. D) None of the category's options are displayed.

None of the category's options are displayed

A 100% stacked column chart is similar to what other chart in that it converts values to percentages? A) Line B) Clustered column C) Radar D) Pie

Pie

What chart type represents data as spokes going from the center to the outer edge of the chart? A) Surface B) Histogram C) Radar D) Area

Radar

What is not a purpose of using an effective chart? A) Aids in making informed decisions B) Compares data C) Reveals even subtle errors in formulas D) Reveals trends and patterns

Reveals even subtle errors in formulas

When you point to a chart element Excel displays a(n) ________ with the name of the element.

Screen Tip

What is the disadvantage of a stacked column chart? A)There is a limit as to how many segments can be displayed B)Segments do no end at the same point C)This is only useful for one data series D)Segments do not start at the same point

Segments do not start at the same point

36) When you want to create a chart you first need to select a data ________.

Source

A(n) ________ is a type of chart which fits in one cell.

Sparkline

Which chart type is a visual "dashboard" of your data? A) Column chart B) Line chart C) Sparkline D) Bar chart

Sparkline