BAT Chapter 5

Question 1

Consolidated Worksheet

Answer 1

Summarizes data from multiple worksheets using a mathematical or statistical function

Question 2

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

Answer 2

Delete the Contents

Question 3

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

Answer 3

Consolidate Command

Question 4

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

Answer 4

Dynamic Consolidation

Question 5

Consolidation by category can be what 2 things?

Answer 5

Static

Dynamic

Question 6

What cannot be performed when worksheets are grouped?

Answer 6

Inserting a graphic

Question 7

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

Answer 7

Ctrl

Question 8

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

Answer 8

Workbook Name
Worksheet Name
Cell Range

Question 9

What is not true about Smart Graphics?

Answer 9

A Smart Graphic is linked to worksheet data

Question 10

Linking Workbooks

Answer 10

The system of alluding to data in a different workbook

Question 11

External Reference Formula

Answer 11

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

Question 12

Hyperlink

Answer 12

A shortcut assigned to an object or data

Question 13

What is 1 thing a hyperlink can be used for?

Answer 13

Take data from other locations