Flashcards in BAT Chapter 5 Deck (13):
Summarizes data from multiple worksheets using a mathematical or statistical function
When creating a consolidation worksheet, what must you do to the range of cells to be consolidated?
Delete the Contents
If values are edited in source worksheets used in a static consolidation, which of the following commands will update the results?
Which of the following should be used when data on source worksheets might be edited after you have created the consolidation worksheets?
Consolidation by category can be what 2 things?
What cannot be performed when worksheets are grouped?
Inserting a graphic
Which of the following key is used to select non adjacent sheets?
What is an example of an external reference with all of its identifiers? (Say in Order)
What is not true about Smart Graphics?
A Smart Graphic is linked to worksheet data
The system of alluding to data in a different workbook
External Reference Formula
Makes a link to the source workbook which is a data connection
A shortcut assigned to an object or data