CGS-2060 Lecture 9: CGS 9
Document Summary
A collection of two or more selected worksheets. function: to make edits, overall input to all at the same time without having to go into each one individually. 3d reference a reference to the same cell in all or some of the worksheets in a workbook. External reference a reference to cells or ranges in a worksheet from another workbook. destination file also called dependent file, the workbook that receives data from another workbook. Arrange all button displays all of the open workbooks in a title configuration within the program window. Switch windows button lists each open workbook so you can change which workbook is active. Workspace an excel file that saves information about all of the currently opened workbooks, such as their locations, window sizes, zoom level, and other settings. Source file when two or more workbooks are linked, this is a workbook that contains data to be used in the destination file.
