BAT Chapter 5 Flashcards Preview

jeremy harmon > BAT Chapter 5 > Flashcards

Flashcards in BAT Chapter 5 Deck (13):
1

Consolidated Worksheet

Summarizes data from multiple worksheets using a mathematical or statistical function

2

When creating a consolidation worksheet, what must you do to the range of cells to be consolidated?

Delete the Contents

3

If values are edited in source worksheets used in a static consolidation, which of the following commands will update the results?

Consolidate Command

4

Which of the following should be used when data on source worksheets might be edited after you have created the consolidation worksheets?

Dynamic Consolidation

5

Consolidation by category can be what 2 things?

Static
Dynamic

6

What cannot be performed when worksheets are grouped?

Inserting a graphic

7

Which of the following key is used to select non adjacent sheets?

Ctrl

8

What is an example of an external reference with all of its identifiers? (Say in Order)

Workbook Name
Worksheet Name
Cell Range

9

What is not true about Smart Graphics?

A Smart Graphic is linked to worksheet data

10

Linking Workbooks

The system of alluding to data in a different workbook

11

External Reference Formula

Makes a link to the source workbook which is a data connection

12

Hyperlink

A shortcut assigned to an object or data

13

What is 1 thing a hyperlink can be used for?

Take data from other locations

Decks in jeremy harmon Class (107):