NIU OMIS 259 Excel Chapter 3
Which of the following options is sorted Z to A
Karen; Doug; Barb
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
Where does the primary axis display on a Combo chart? A) Left side B) Right side C) Top D) Bottom
Left Side
Where does the primary axis display on a combo chart?
Left side
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
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
Where does Excel display the Total row in a table?
Below the last row in the table
If your chart is intended for presentation, as opposed to printing, you should use a(n) ________ background.
Black
What font color does excel use by default for many of its elements
Black, text 1, lighter 35%
In a structured reference, what do you use to indicate a column heading or field name?
Brackets []
Using the data bars conditional formatting, how is the highest value represented?
By the longest bar
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
Which of the following is not a freeze option
Freeze Section
Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers
Highlight Cells Rules
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
What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?
January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015
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
Which of the following is not a conditional formatting option?
Table Format
The filter "Begins With..." option is found on which type of filter
Text Filter
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
In the Insert Chart dialog box, after you pick a chart type where rare the subtypes listed?
Top Right
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
in a bar chart, which axis displays the categories
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
What is true about adding a new field to the right side of an existing data table?
You can add it to the right of the data table and Excel will extend the table to include the new field.
data table
a grid used to plot data in a chart
data series
a group of data points
data point
a precise value in a chart
task pane
a window of options
3-D chart
adds an additional dimension to your chart
including what, distorts the effectiveness of charting data points?
aggregates
in the task pane, what does a diagonal black triangle next to a chart category indicate?
all the category's options are displayed
accessibility compliance
applying features to make it easier on disabled users
what does excel NOT determine about the value axis when you create a chart?
average value
Which chart type displays the data horizontally?
bar
which chart type is preferable when the category names are long?
bar
which chart type cannot be displayed as a sparkline?
bar chart
plot area
both axes form a border for this
Where does excel display the Quick Analysis tool?
bottom-right corner
Alt Text
can be read by various devices
In a column chart the horizontal axis displays the ________.
categories
Which axis in a chart displays the descriptive labels for the data points?
category
what can you NOT do from the select data source dialog box?
change chart type
100% stacked column chart
changes individual data points to percentages
Excel uses ________ to determine what categories are visible in a chart.
chart filters
Which of the following is NOT a chart element?
chart foreground
sparkline
chart resides in one cell
what is not found on the chart elements list?
chart type
what icon is not displayed when you select a chart?
chart types
which of the following is not a chart type?
circle
In a(n) ________ column chart data appears as side by side columns.
clustered
area chart
colors are used between the lines
which chart types displays the data vertically?
column
clustered column chart
columns are set side by side
combo chart
combines two chart types
what chart type can display two different chart types at the same time?
combo
Which chart type is best when you want to chart two unrelated data types?
combo chart
stacked column chart
compares individual points to the whole category
column chart
compares values across categories
Rules used to emphasize cells are referred to as _____________.
conditional formatting
chart sheet
contains no spreadsheet data
which group on the design tab would you select if you wanted to change the source information in the chart?
data
which of the following is NOT a chart element?
data area
chart filter
decides what is hidden or displayed in a chart
chart title
describes the entire chart
data labels
easier to read than a legend
sparklines
examples include: line, column, win/loss
Excel uses solid blue lines to indicate automatic page breaks.
false
Locking is the process of making sure that certain rows or columns are visible at all times
false
a parallel range is one that consists of the same starting point of another range, but can have a different end point.
false
a stacked column chart displays multiple columns for each category
false
as long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold
false
in rare cases you can chart text entries
false
including the column and row labels in a chart makes the chart harder to understand
false
to switch to a different chart type after the chart has been created you use the switch chart type tool
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?
format
Which chart element cannot be chosen from the chart elements dialog box?
format back wall
_____________ keeps certain rows or columns on the screen at all times
freezing
parallel range
has the same starting and ending point
chart filter
helps you to focus on particular data
quick layout
helps you use predefined layouts
chart area
holds the entire chart
X-axis
horizontal border
which tab displays the tools for creating charts?
insert
What is NOT true about an effective chart?
it always contains more than one series
If you wanted to show trends over set periods of time, you probably want to use a(n) ________ chart.
line
line chart
line connect data points
arrange
moves an object backward or forward
in the take pane, what does a diagonal which triangle next to a chart category indicate?
none of the category's options are displayed
exploding pie chart
one or more pieces are separated from the other
X Y (scatter) chart
one variable is plotted on the horizontal axis and the other on the vertical axis
Where data will print on the next page is referred to as __________.
page break
The range of cells that will be printed is referred to as __________.
print area
_____________ is the sequence of printed pages
print order
what chart type represents data as spokes going from the center to the outer edge of the chart?
radar
If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.
recommended
sizing handles
seen as 8 circles
what is a disadvantage of a stacked column chart?
segments do not start at the same point
A data ________ is a group of related data points.
series
A group of data points used in a graph become a data ________.
series
chart style
sets the formatting of the chart
data label
shows the precise value of a data pint
histogram
similar to a column chart
area
similar to a line chart
which chart type is NOT listed in the All Charts window?
sparkline
which chart type is a visual "dashboard" of your data?
sparkline
which group on the sparkline tools design tab would you choose is you wanted to change the data source of the sparkline?
sparkline
radar
spokes radiate from the center to the outer edges
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
stock chart
subtypes include: High-Low-Close, Open-High-Close, Volume-High-Low-Close and Volume-open-high-low-close
Alt Text
text based interpretation
chart font color
the default is black, text 1, lighter 35%
in a pie chart which of the following is a good reason for using category data labels rather than the legend?
they are easier to read
chart element
this helps make a chart clearer
In a data table calculated columns will copy down the table automatically
true
It is a good practice to print column and row labels on each page
true
True or False:When you want to chart two related types of data, the Combo chart is perfect.
true
When you use the Freeze Panes option you are freezing both columns and rows
true
effective charts never overwhelm an audience
true
it is good practice to delete any blank rows or columns before creating a chart
true
it is important to select parallel ranges
true
pie charts can only display one data series
true
when you want to chart two related types of data, the combo chart is perfect
true
you cannot enter data or formulas on a chart sheet
true
you might want to avoid using 3-D charts because they can distort the appearance of the data
true
combo chart
used for two different but related data types
triangle with a white fill
used to show that all chart category options are not visible
diagonal black triangles
used to show that all chart category options are visible
legend
uses color or patterns to identify each data series
bar chart
uses horizontal bars
pie chart
uses slices to display data points
surface chart
uses two dimensions and a continuous curve
column chart
uses vertical bars
Which axis in a chart displays incremental numbers for the data points?
value
Y-axis
vertical border
What should you NOT select when selecting data for a chart?
worksheet titles
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
Which chart type is not listed in the All Charts window? A) Waterfall B) Sparkline C) Treemap D) Histogram
Sparkline
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
Which of the following is sorted Oldest to Newest
1/16/1957; 12/26/1959; 1/7/87
Which of the following is sorted Newest to Oldeset
11/20/2015; 8/20/2015; 5/25/91
How many variations of the stock chart does Excel have? A)1 B)2 C)3 D)4
4
how many variations of the stock chart does Excel have?
4
Which of the following is sorted Largest to Smallest
58; 29; 27
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
as a general rule, Pie charts should be limited to how many slices?
7
How many sizing handle are found on embedded charts? A) 8 B) 6 C) 4 D) 10
8
how many sizing handle are found on embedded charts?
8
In a stacked column chart the data must be ________.
Additive
Which of the following is sorted A to Z?
Number; Othniel; Psychology
X Y (scatter) chart
Often used in educational, scientific, and medical experiments
On which tab will you find options if you have to print a large dataset
Page Layout
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
a 100% stacked column chart is similar to what other chart in that it converts values to percentages?
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
what is NOT a purpose of using an effective chart?
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
