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
Performing Calculations
Multiple Choice Quiz
Click on the correct response for each question below.
1
Which of the following is the correct syntax for the ROUND function?
A)
ROUND (number. digits)
B)
ROUND (value, places)
C)
=ROUND (places, number)
D)
=ROUND (number, digits)
2
What is the range of a value calculated by the RAND function?
A)
between 0 and 1
B)
between 0 and 10
C)
between 0 and 100
D)
between 1 and 10
3
Which of the following is
not
a function used to display a date’s component values?
A)
=DAY(date_value)
B)
=TODAY(date_value)
C)
=MONTH (date_value)
D)
=YEAR (date_value)
4
An annuity is:
A)
too complex to explain.
B)
the difference between a stock and a bond.
C)
a series of equal cash payments that are made over a given period of time.
D)
the time value of money.
5
Which of the following are financial functions?
A)
PPMT
B)
NPV
C)
IRR
D)
all of the above
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
.