Module 5

• 1. D reference


  A reference to the same cell or range in multiple worksheets in the same workbook
• Broken link


  A reference to a file that has been moved since the link was created
• Custom template


  A workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting and labels
• Destination file


  The workbook that receives data from another workbook when two workbooks are linked; sometimes referred to as the dependent file
• External reference


  A reference to cells or ranges in a worksheet from another workbook
• Hyperlink


  A link in a file, such as a workbook, to information within that file or another file
• Link


  A connection between files that allows data to be transferred from one file to another
• Source file


  A workbook that contains data to be used in the destination file when two or more workbooks are linked
• Screen Tip


  • Updating a link
  • Breaking a Link
• Worksheet group


  A collection of two or more selected worksheets
• 1. D Reference


  Formulas with references to cells on the same sheet can be thought of as 2-D (or 2-dimensional) references because they involve only the row address and the column address
• Named Range/Defined Names


  Range references are replaced with descriptive names. A named range can refer to any cell or cell range within the workbook
• Grouped worksheets


  You can edit several worksheets simultaneously by grouping the worksheets. In a worksheet group, any changes made to one worksheet are automatically applied to all sheets in the group, including entering formulas and data, changing row heights and widths, applying conditional formats, inserting or deleting rows and columns, defining page layouts, and setting view options. Worksheet groups save time and improve consistency because identical actions are performed within several sheets at the same time