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

Managing Worksheet Lists

Short Answer



1

In what situations would you use Excel to manage a list, versus other specialized database software?
2

Explain the difference between a data form and a criteria form.
3

What is the difference between data and information?
4

When might you use the SUMIF and COUNTIF functions?
5

What is subtotaling? Why would you use it?




McGraw-Hill/Irwin