Site MapHelpFeedbackUsing Solver, Creating Templates, and Evaluation Scenarios
Using Solver, Creating Templates, and Evaluation Scenarios

The following concepts will be introduced in this lab:
  1. Solver: Solver is a tool used to perform what-if analysis to determine the effect of changing values in two 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. Protection: The protection feature controls what information can be changed in a workbook.
  4. Window Arrangement: The window arrangement feature displays all open workbook files in separate windows on the screen, making it easy to view and work with information in different workbooks.
  5. Link: A link creates a connection between files that automatically updates the data in one file whenever the data in the other file changes.
  6. Diagram: A diagram is a graphic object that can be used to illustrate concepts and to enhance the workbook.
  7. 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.







To learn more about the book this website supports, please visit its Information Center.
(c)2004 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.


The O'Leary Series Office 2003Online Learning Center

Home > Excel 2 > Intro Lab 4