Student Center
|
Instructor Center
|
Information Center
|
Home
Glossary
Data Files
Buzz in IT
Choose a Chapter
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Learning Objectives
Chapter Outline
Prerequisites
Multiple Choice Quiz
Short Answer
True or False
Case Problems
Hands-On Exercises
Feedback
Help Center
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)
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
.