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

Formula Auditing, Data Validation, Pivot Tables and Charts

Multiple Choice

Click on the correct response for each question below.



1

To access the Formula Auditing toolbar, choose
A)View/Toolbars/Formula Auditing.
B)Tools/Auditing/Formula Auditing.
C)Data/Formula Auditing.
D)View/Auditing/Formula Auditing
2

If a cell contains an error, you can access the Trace Error functions by
A)right-clicking the cell and choosing Trace Error.
B)clicking the cell and choosing Tools/Trace Error.
C)clicking the cell and choosing Help/Error Help.
D)clicking the cell and then clicking the Trace Error smart tag.
3

The warning style that displays Retry and Cancel buttons is
A)Warning.
B)Error.
C)Stop.
D)Information.
4

You can check for faulty data that was entered before Data Validation rules were in place by
A)reapplying the Data Validation rule.
B)choosing Data/Validation.
C)clicking the Circle Invalid Data button on the Formula Auditing toolbar.
D)choosing Format/Conditional Formatting.
5

When a formula is inconsistent with formulas above and below it, the cell will display what error?
A)#IF!
B)#I/F!
C)#FORM!
D)No error message will display, but the cell will be flagged
6

The keyboard shortcut for opening the Paste Name dialog box is
A)F1.
B)F2.
C)F3.
D)F4.
7

To remove all of the groupings created by AutoOutline, choose
A)Data/Ungroup.
B)Data/Group and Outline/Clear Outline.
C)Data/Group and Outline/Ungroup.
D)Data/Group and Outline/AutoOutline.
8

Which of the following is not an available function when using automatic subtotals?
A)SUM
B)RND
C)MIN
D)COUNT NUMS
9

Which of the following list of column headings would produce faulty data in a PivotTable?
A)Egg sales quarterly, Egg sales yearly, Egg cost quarterly, Egg cost yearly
B)Egg sales, Quarterly, Yearly, Egg cost, Quarterly, Yearly
C)January, February, March, April
D)Quarterly sales, Quarterly cost
10

Which of the following chart types cannot be used for a PivotChart?
A)bar
B)line
C)bubble
D)column
11

In a PivotChart, to show only certain items from a field, you must first
A)alter the underlying PivotChart.
B)sort the PivotChart.
C)start the Chart Wizard.
D)uncheck the (Show All) option.




McGraw-Hill/Irwin