Ch. 3 Creating and Editing Charts Flashcards
A chart style is a preset combination of colors and effects for a chart, its background, and its elements.
True or False
True
Which of the following keys creates an automatic column chart sheet for selected data?
F5
F7
F9
F11
F11
Which of the following is not true about filters?
-A filter is a requirement or condition that specifies which data are shown
-A filter identifies which data are hidden
-By default, a chart displays all categories and all the data series for the selected cells
-Filters change the underlying cell range for a chart
Filters change the underlying cell range for a chart
It is not possible to change which data series is plotted on the x-axis and which is plotted on the y-axis.
True or False
False
A tree-map chart illustrates hierarchical data using circles of various sizes and colors to represent the divisions and subdivisions.
True or False
False
Which of the following is a set of elements and the location of those elements.
-Chart Layout
-Chart Style
-Quick Layout
-Chart Sheet
Chart Layout
Which of the following displays the number represented by a column, pie slice, bar, or other marker on the chart?
-Trendline
-Data Label
-Data Table
-Source Data
Data Label
Another name for the base or bottom of a 3D chart is a chart floor?
True or False
False
Which of the following statements is not true for printing?
-A chart object can be printed on the page with worksheet data
-You can print a chart object on a separate sheet
-To print a chart with the data, deselect the current object by clicking a worksheet cell, size and position the chart, and scale the sheet to fit the printed page
-By default, a chart sheet prints in portrait orientation
By default, a chart sheet prints in portrait orientation
The funnel chart type plots each element in a running total and displays negative and positive effect of each on the totals.
True or False
False
The cells used to build a chart are its source data.
True or False
True
