Chapter 5 MGSC Study Guide Test.
Chapter 5 MGSC Study Guide Test. summarizes data from more than one worksheet using mathematical or statistical excel function - CORRECT ANSWER consolidated worksheet separate summary worksheet in the same workbook - CORRECT ANSWER consolidation worksheet existing worksheet that contains a range that will be included in consolidation worksheet - CORRECT ANSWER source worksheet summarizes the data and displays a result that does not update on the consolidated sheet; source data is final and will not be edited - CORRECT ANSWER static consolidation places formulas on your consolidated sheet and formats that sheet as an outline; use when source documents may be edited - CORRECT ANSWER dynamic consolidation workbook that includes data from another workbook; may simply display this data or it may reference it in a formula - CORRECT ANSWER dependent workbook includes data that is referenced in a dependent workbook - CORRECT ANSWER source workbook formula that refers to cells in another workbook - CORRECT ANSWER external reference character such as exclamation point that marks or signifies a component of the reference - CORRECT ANSWER identifier
Información del documento
- Subido en
- 13 de junio de 2024
- Número de páginas
- 2
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
