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


Office XP Access 2002
Office XP Access 2002, 2/e
Timothy O'Leary, Arizona State University
Analyzing Data over the Web

Multiple Choice Quiz



1

A PivotTable looks like a
A)Report
B)Spreadsheet
C)Query
D)Chart
2

PivotCharts
A)Enable users to select subsets of data to be displayed
B)Enable users to interactively select attributes
C)Both A and B
D)Neither A nor B
3

PivotCharts are easy to read if
A)Two attributes are displayed
B)One attribute is displayed as a category
C)One attribute is displayed as a series
D)All of the above
4

An interactive tool that allows users to reorganize tables is called a
A)PivotTable
B)PivotChart
C)Field
D)Query
5

PivotTables can retrieve data from several tables
A)Creating a report
B)Finding Columns
C)Using Windows
D)Creating a query
6

When users choose which attributes appear as rows or columns, the PivotTable will
A)Expand the query
B)Create a new query
C)Sum one field
D)Recalculate the totals
7

To create a PivotChart, begin with
A)A report
B)The PivotTable
C)A query
D)The final calculations
8

A graph that displays subsets of data is called a
A)PivotTable
B)PivotChart
C)Chart
D)Graphic File
9

To display the Legend
A)Click PivotTable in the Toolbox
B)Click Show/Hide Legend in the toolbar
C)Click Field List/Display Legend
D)None of the above








Copyright2002 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.