McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Excel 2002
Office XP Excel 2002, 2/e
Timothy O'Leary, Arizona State University

Using Solver, Creating Workbook Templates, Linking Workbooks, and Creating Scenarios

Concepts

The following concepts will be introduced in this lab:
  1. Solver: Solver is a tool used to perform what-if analyses to determine the effect of changing values in tow or more cells on another cell.
  2. Workbook Template: A workbook template is a workbook file that contains predesigned worksheets that can be used as a pattern for creating similar worksheets in new workbooks.
  3. Worksheet Protection: Worksheet protection prevents users from changing a worksheet's contents by protecting the entire worksheet or specified areas of it.
  4. Arrange Windows: The Arrange Windows feature displays all open workbook files in separate windows on the screen, in a tiles, horizontal, vertical, or cascade arrangement.
  5. Link Workbooks: A link creates a connection between files that automatically updates the data in one file whenever the data in the other file changes.
  6. Scenario: A scenario is a named set of input values that you can substitute in a worksheet to see the effects of a possible alternative course of action. Scenarios are designed to help forecast the outcome of various possible actions.




McGraw-Hill/Irwin