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

Learning Objectives

After completing this chapter, you will be able to:

1.

Construct nested formula expressions

2.

Use the logical IF function to make decisions

3.

Use Goal Seek to perform basic what-if analysis

4.

Use date and time functions, including DATE, DAY, MONTH, YEAR, WEEKDAY, and TIME

5.

Use mathematical and statistical functions, including ROUND, RAND, and INT

6.

Use text functions to convert, extract, and manipulate labels and other character strings

7.

Use financial functions, including PV, FV, and PMT




McGraw-Hill/Irwin




Copyright2002 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.