Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
true
|
The chart area is a rectangular area that contains the charts and other chart elements.
|
|
false
|
Charts may not be resized once they are created.
|
|
false
|
The line chart is considered the most commonly used chart type.
|
|
false
|
Chart pages are entire sheets that contain only chart information.
|
|
true
|
Data labels are used in charts to associate data values with the charted infor mation.
|
|
b
|
. Which of the following is not a component of a data series?
A. Series name B. Series labels C. Series values D. Category values |
|
c
|
_____ is a graphical representation of a set of data.
A. picture B. label C. chart D. diagram |
|
c
|
Which of the following is not an Excel Chart type?
A. Column B. Line C. Row D. Pie |
|
d
|
_____ is a chart this is display on the same worksheet as the source data.
A. Included Chart B. Employed Chart C. Inserted Chart D. Embedded Chart |
|
a
|
_____ is an area that labels the data used in a chart.
A. Legend B. Definition C. Map D. Appendix |
|
a
|
. Excel creates an associated PivotTable with each PivotChart.
|
|
a
|
A PivotTable is an interactive table that enables data grouping
|
|
b
|
Information does not need to be defined as an Excel table prior to creating a PivotTable.
|
|
a
|
Excel Tables enable the user to filter data easily.
|
|
a
|
Items on a PivotTable may be expanded or collapsed based upon the desirable view
|
|
b
|
The data in a PivotTable is ____ directly to worksheet cells.
A. linked B. not linked C. copied D. imported |
|
a
|
PivotTables are useful because they show _____ among data.
A. relationships B. links C. changes D. values |
|
c
|
Which button will update the PivotTable and PivotChart information?
A. update B. recalculate C. Refresh D. Link |
|
b
|
_____ is a graphic representation of the data in a PivotTable.
A. Option Chart B. PivotChart C. Inserted Chart D. Embedded Chart |
|
a
|
_____ is one way to manipulate data in a PivotChart environment.
A. Filter B. Embed C. Map D. Alphabetize |