Site MapHelpFeedbackManaging and Analyzing a Workbook
Managing and Analyzing a Workbook

The following concepts will be introduced in this lab:
  1. Absolute Reference: An absolute reference is a cell or range reference in a formula whose location does not change when the formula is copied.
  2. Sheet Name: Each sheet in a workbook can be assigned a descriptive name to identify the contents of the sheet.
  3. AutoFill: The AutoFill feature makes entering long or complicated headings easier by logically repeating and extending the series.
  4. Sheet and 3-D References: A formula containing sheet and 3-D references to cells in different worksheets in a workbook allows you to use data from other worksheets and to calculate new values based on this data.
  5. Split Windows: The split window feature allows you to divide a worksheet window into sections, making it easier to view different parts of the worksheet at the same time.
  6. Freeze Panes: Freezing panes prevents the data in the panes from scrolling as you move to different areas in the worksheet.
  7. What-If Analysis: What-if analysis is a technique used to evaluate the effects of changing selected factors in a worksheet.
  8. Goal Seek: Goal Seek is a tool that is used to find the value needed in one cell to attain a result you want in another cell.







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 > Lab 3