| Office XP Excel 2002, 2/e Timothy O'Leary,
Arizona State University
Using Solver, Creating Workbook Templates, Linking Workbooks, and Creating Scenarios
ConceptsThe following concepts will be introduced in this lab:
- 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.
- 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.
- Worksheet Protection: Worksheet protection prevents users from changing a worksheet's contents by protecting the entire worksheet or specified areas of it.
- 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.
- 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.
- 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.
|
|