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

Short Answer



1

What are the functions for changing the case of a string? What does each do?
2

What is the syntax to calculate a monthly payment for a loan where the principle is $28,000, the annual interest rate is 7.875%, and the term of the loan is 5 years?
3

Describe the "Goal Seeking" feature.
4

For what might you use the DATE function?
5

Explain how to join the text labels in two cells, B5 and C5, with a comma and a space separating the two labels.




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.