Student Center
|
Instructor Center
|
Information Center
|
Home
Data Files
Buzz in IT
Updates
Choose one...
Lab 1
Lab 2
Lab 3
Lab 4
Lab 5
Lab 6
Lab 7
Lab 8
Lab 9
Working Together 1
Working Together 2
Working Together 3
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center
Office XP Excel 2002, 2/e
Timothy O'Leary, Arizona State University
Charting Worksheet Data
Multiple Choice Quiz
Click on the correct response for each question below.
1
This type of chart is useful for finding the best combination between sets of data.
A)
A. Radar
B)
B. Surface
C)
C. Scatter
D)
D. Bubble
2
This type of chart compares sets of three values.
A)
A. Bubble
B)
B. Radar
C)
C. Surface
D)
D. Scatter
3
Basic parts of this type of chart include a legend, chart title, plot area, category-axis title, and value-axis title.
A)
A. 3-D
B)
B. Bubble
C)
C. 2-dimensional
D)
D. Pie
4
When plotting this type of range in a chart, the selections must form a rectangular shape.
A)
A. Nonadjacent
B)
B. XY
C)
C. Plot
D)
D. Adjacent
5
When creating a chart, you can use the Chart Wizard or the menu equivalent, which is
A)
A. Insert/Chart.
B)
B. Format/Chart.
C)
C. Tools/Chart.
D)
D. View/Chart.
6
This is the default chart type in the Chart Type list box.
A)
A. Line
B)
B. Column
C)
C. Pie
D)
D. Bar
7
The default column sub-type in the Chart Sub-type section of the Chart Type list box is a
A)
A. Stacked column.
B)
B. Single column.
C)
C. Clustered column.
D)
D. 3-D column.
8
In the second Chart Wizard dialog box, you specify the
A)
A. Chart style you want to use.
B)
B. Chart options you want to use.
C)
C. Data series on the worksheet.
D)
D. Data range on the worksheet you want to plot.
9
When using the Chart Wizard, the worksheet data range that has the greater number of rows or columns appears along the X-axis and the smaller number is charted as the
A)
A. data series.
B)
B. data range.
C)
C. data labels.
D)
D. Y-axis.
10
Which of the following is not a chart option of the Chart Wizard?
A)
A. Titles
B)
B. Data Table
C)
C. Axes
D)
D. Data Range
11
Pressing this key after typing the title text for a chart is the same as clicking the Next key.
A)
A. Shift
B)
B. Tab
C)
C. Enter
D)
D. Spacebar
2002 McGraw-Hill Higher Education
Any use is subject to the
Terms of Use
and
Privacy Policy
.
McGraw-Hill Higher Education
is one of the many fine businesses of
The McGraw-Hill Companies
.