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

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




McGraw-Hill/Irwin