Introduction to Algorithms
3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
720 solutions
Introduction to the Theory of Computation
3rd EditionMichael Sipser
389 solutions
Starting Out with C++ from Control Structures to Objects
9th EditionTony Gaddis
1,098 solutions
C++ Programming: Program Design Including Data Structures
7th EditionD. S. Malik
867 solutions
A chart
is a visual representation of worksheet data
A chart object
is a selectable item or element in a worksheet
A chart sheet
is an Excel chart on its own tab in the workbook
Source data
the cells with values and labels used to build a chart
Which of the following is a requirement or condition that identifies which data is shown and which is hidden?
filter
A tick mark is a small line or marker on an axis to guide in reading values.
TRUE
Which of the following is a horizontal or vertical line that extends across the plot area to help in identifying values?
GRIDLINE
In a pie chart, a data series is a slice of a pie, T/F?
False; In a pie chart, a data point is a slice of a pie.
Which of the following displays averages in your data and can be used to forecast data?
trendline
Once you have selected the appropriate data, which of the following keyboard shortcuts creates a default chart object?
Alt+F1
Which of the following chart types displays the distribution of data with minimum, mean, maximum, and outlier values?
Box and Whisker
Which of the following is a rectangular area bounded by the horizontal and vertical axes?
Plot area
Clicking a chart element opens its Format pane, T/F?
False; Double-clicking a chart element opens its Format pane.
Which of the following is a small line or marker on an axis to guide in reading values?
Tick mark
The Funnel chart type plots each element in a running total and displays negative and positive effects of each on the total, T/F?
False; The Funnel chart plots values that progressively decrease from one stage or process to the next.
What can pie charts graph?
a single data series
Which of the following statements is not True?
a. In a combination chart, you can display two sets of values, two vertical axes.
b. You can create a combination chart from the Home tab.
c. The axis on the left is the primary axis; the one on the right is secondary.
d. Some chart types cannot be combined.
b. You can create a combination chart from the Home tab.
**You can create a combination chart from the Charts group on the Insert tab.
Which of the following is not a True statement?
a. The outline for a shape is the border that surrounds or encircles it.
b. Not all chart elements are suited to an outline.
c. Elements such as the chart or plot area do not usually benefit from the use of an outline.
d. When you add an outline to a chart element, you can select a weight for the line.
C. Elements such as the chart or plot area do not usually benefit from the use of an outline.
Elements such as the chart or plot area often benefit from the use of an outline.
Which of the following can you apply after you select a chart element?
a. fill color
b. outline width
c. special effect
d. all of the above
d. all of the above
Which of the following charts displays relationships among numeric values in two or more data series?
XY charts display relationships among numeric values in two or more data series.
The Chart Tools Design tab includes commands for selecting a chart layout, choosing a chart style, and changing the color scheme, T/F?
True
Which of the following chart elements provides a vertical background for a 3D chart?
Chart Wall
A chart object is a selectable item surrounded by a square border that is separate from worksheet data, T/F?
TRUE
Elements such as the chart or plot area rarely benefit from the use of an outline, True/False?
False;
Which of the following could you add to a chart to predict future values?
You can add a trendline to a chart to help predict future values.
Which of the following chart types displays comparisons among individual items or values at a specific period of time?
Bar chart
Data tables are located just below a chart, T/F?
True
Exploding a pie slice emphasizes that slice, because it moves the slice away from the rest of the pie, T/F?
TRUE
Which of the following enables you to begin editing a chart title?
To edit the chart title, triple-click the Chart Title placeholder, type the title, and click the chart background to deselect the element.
Which of the following chart types displays the frequency of mutiple data series relative to a center point?
The Radar chart type displays the frequency of multiple data series relative to a center point.
Which of the following chart types displays a hierarchical view of data with different sized and colored rectangles and sub-rectangles to compare the sizes of groups?
The TreeMap chart type displays a hierarchical view of data with different sized and colored rectangles and sub-rectangles to compare the sizes of groups.
Which of the following chart types illustrates data changes over a period of time or shows comparisons among items?
Column charts illustrate data changes over a period of time or show comparisons among items.
The cells used to build a chart are its source data, T/F?
TRUE
Which of the following is a text box with a preset font style, fill, and text effect?
WordArt is a text box with a preset font style, fill, and text effect.
The Chart Tools Design tab includes commands for selecting a chart layout, choosing a chart style, and changing the color scheme, T/F?
TRUE
Which of the following terms refers to a group of data points or values?
data series
If the cell range you want to use in a chart contains non-adjacent cells, hold down the Alt key to select each range, T/F?
If the cell range you want to use in a chart contains non-adjacent cells, hold down the Ctrl key to select each range.
A combination chart includes?
at least two chart types such as a line chart and a column chart
Which of the following charts displays relationships among numeric values in two or more data series?
XY
Which of the following is not a True statement?
a. Exploding a pie slice emphasizes that slice.
b. Exploding a pie slice moves the slice away from the rest of the pie.
c. You set explosion as a percentage.
d. Pie charts do not have Quick Layouts and Quick Styles.
d. Pie charts do not have Quick Layouts and Quick Styles.
A marker for a sparkline is the data point value, T/F?
TRUE
Which of the following charts displays three series of data to show fluctuations in stock prices from high to low to close?
Stock Chart
Which of the following lets you select a chart element?
None of the above; To select a chart element, simply click on it.
What is the thickness of an outline measured in?
points
What do trendlines demonstrate?
averages
Which of the following shapes can you use to highlight important parts of a chart?
circle
Which of the following are miniature charts displayed in a cell or cell range with your data?
Sparklines
Which of the following is another word for a variegated blend of color?
gradient
Which of the following encompasses all of the other items?
A shape style is a predesigned set of borders, fill colors, and effects for a chart element.
You can easily create a default chart object by selecting the appropriate data and pressing F1.
FALSE
It is possible to replace a chart title box with WordArt.?
T; It is possible to replace a chart title box with WordArt.
There are two sparkline types: pie and area?
False; There are three sparkline types: Line, Column, and Win/Loss.
In a chart, which of the following can you fill with pictures?
bars, Columns, pie slices
Which of the following terms refers to the text label that describes each data series?
category label
Which of the following statements is not True?
a. it is possible to change chart type.
b. It is possible to change some bar charts into column charts, but not all.
c. It is possible to change a 3-D pie chart into a 2-D pie chart.
d. Excel 3-D charts add the perception of depth to a chart.
b. It is possible to change some bar charts into column charts, but not all.
**It is possible to change bar charts into column charts.
What would you call a table added to the bottom of your chart that contains the values of each data series?
data table
Each group of data points or values used in a graph is a data series, T/F?
TRUE
Each group of data points or values used in a graph is a data series.
TRUE
Which of the following is True about data tables?
a. By default, Excel adds a data table to the right side of column and bar charts.
b. By default, Excel adds a data table to the bottom of line charts.
c. By default, Excel adds a data table to the right of all charts.
d. By default, Excel does not include data tables with charts.
d. By default, Excel does not include data tables with charts.
A chart object is a selectable item surrounded by a square border that is separate from worksheet data.
TRUE