ACIS 2504 Study Guide - Midterm Guide: Regression Analysis, Financial Analysis, Data Integrity
Document Summary
Chapter 7 ranges across worksheets: = worksheet name!cell reference merged together for a final product. Group worksheets column labels worksheets in a workbook, cannot be named in the name box. A workbook containing multiple worksheets, may be summarized. Data used in a worksheet is not just limited to data on the worksheet. Data used in a workbook is not just limited to the data on its worksheets. Workbook can contain hundreds of worksheets and is 3 dimensional. Fill across worksheet copy cell contents, formats, or both to worksheets in a. Consolidate by position aggregates data in the same position in multiple. Consolidate by category aggregates data in cells with matching row and/or. 3-d references allow formulas and functions to use data from cells and cell. 3-d named range references the same cell or range of cells across multiple. Collaboration allows workbooks to be shared among different users and then: multiple users can collaborate by sharing a workbook.