McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Glossary
Data Files
Buzz in IT
Learning Objectives
Chapter Outline
Prerequisites
Multiple Choice Quiz
Short Answer
True or False
Case Problems
Hands-On Exercises
Feedback
Help Center


Advantage Series MS Office XP Excel 2002
Advantage Series: Microsoft® Excel 2002
Sarah Hutchinson-Clifford
Glen Coulthard

Analyzing Your Data

Multiple Choice Quiz

Click on the correct response for each question below.



1

While entering a formula, how many times must you press the F4 key to make a mixed reference that locks in only the column?
A)1
B)2
C)3
D)4
2

What is the name of the dialog box that helps you to enter functions correctly?
A)Paste Function
B)Status Bar
C)Insert Function
D)Formula Editor
3

The four steps in the chart wizard, in order are:
A)Chart Type, Chart Source Data, Chart Options, and Chart Location
B)Type, Data, Options, Location
C)Chart Options, Chart Type, Chart Location, and Chart Source Data
D)Bar Chart, Pie Chart, Line Chart, and Scatter Chart
4

Which function returns only the date from the system’s internal clock:
A)=NOW()
B)=TODAY()
C)=CLOCK()
D)=TIME()
5

The correct syntax for a function is:
A)=Function “argument”
B)=Formula(argument)
C)=Argument(function)
D)=Function(argument)




McGraw-Hill/Irwin