McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Excel 2002
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




McGraw-Hill/Irwin