Question 1

A(n)$\underline { \text { asterisk }   }$separates the worksheet reference from the cell or range reference._________________________

Accepted Answer

A) True 
 B)False

Question 2

Formulas created using the point-and-click method contain ____ references.

Accepted Answer

A) absolute 
B) mixed 
C) relative 
D) relational 
A) absolute 
B) mixed 
C) relative 
D) relational

Question 3

If you receive a destination workbook but the source files are not included,click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

Accepted Answer

A) Fix 
B) Break 
C) Update 
D) Check 
A) Fix 
B) Break 
C) Update 
D) Check

Question 4

You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.

Accepted Answer

A) mixed 
B) absolute 
C) relative 
D) indexed 
A) mixed 
B) absolute 
C) relative 
D) indexed

Question 5

The ____ caption indicates a worksheet group.

Accepted Answer

A) [Worksheets] 
B) [Selected Sheets] 
C) [Group] 
D) [Workgroup] 
A) [Worksheets] 
B) [Selected Sheets] 
C) [Group] 
D) [Workgroup]

Question 6

You can use the ____________________ dialog box to break links between workbooks.

Accepted Answer

The answer of You can use the ____________________ dialog box...

Question 7

If you trust the provider of source files,you can choose to ____ the content,which allows the external reference formulas to function and updates the links in the destination workbook.

Accepted Answer

A) enable 
B) embed 
C) concatenate 
D) consolidate 
A) enable 
B) embed 
C) concatenate 
D) consolidate

Question 8

To move a worksheet or worksheet group to another location in the same workbook,select the worksheets and then drag and drop them by the selected sheet ____.

Accepted Answer

A) tabs 
B) indices 
C) keys 
D) icons 
A) tabs 
B) indices 
C) keys 
D) icons

Question 9

When a worksheet group is selected,the ____ includes text to indicate this.

Accepted Answer

A) title bar 
B) worksheet bar 
C) status bar 
D) formula bar 
A) title bar 
B) worksheet bar 
C) status bar 
D) formula bar

Question 10

Using multiple worksheets makes it easier to group and summarize data.Describe features that can be applied by forming a worksheet group.

Accepted Answer

By forming a worksheet group,you can:
•E

Question 11

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.

Accepted Answer

A) source 
B)  destination 
C)  both a. and b. 
D)  neither a. nor b. 
A) source 
B)  destination 
C)  both a. and b. 
D)  neither a. nor b.

Question 12

A ____ is a workbook that you can open with the text,formats,and formulas already built into it.

Accepted Answer

A) boiler 
B) summary sheet 
C) template 
D) range master 
A) boiler 
B) summary sheet 
C) template 
D) range master

Question 13

A worksheet ____ is a collection of two or more selected worksheets.

Accepted Answer

A) index 
B) roster 
C) group 
D) cluster 
A) index 
B) roster 
C) group 
D) cluster

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A connection between two files allowing information to be transferred from one file to the other

Accepted Answer

A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled 
A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains the information when two files are linked

Accepted Answer

A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled 
A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates that a link has to be updated manually by the user

Accepted Answer

A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled 
A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled

Question 17

Ryder has discovered the power of creating and viewing multiple workbooks.
-Ryder wants to use the workbooks he has created on another computer.What steps does he need to take?

Accepted Answer

A) He needs to copy just the workbook file to the other computer. 
B) He needs to copy just the individual worksheets to the other computer. 
C) He needs to copy both the workbook file and the individual worksheets to the other computer. 
D) He cannot copy the workbook; instead, he needs to copy the individual worksheets and recreate the workspace on the other computer. 
A) He needs to copy just the workbook file to the other computer. 
B) He needs to copy just the individual worksheets to the other computer. 
C) He needs to copy both the workbook file and the individual worksheets to the other computer. 
D) He cannot copy the workbook; instead, he needs to copy the individual worksheets and recreate the workspace on the other computer.

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A collection of two or more selected worksheets

Accepted Answer

A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled 
A) 3-D 
B) template 
C) A 
D) source 
E) destination
F)link
G)M
H)worksheet group
I)hyperlink
J)Tiled

Question 19

If you need to use data located in one workbook in the other workbook,you have to create a(n)____ between the two workbooks.

Accepted Answer

A) anchor 
B) source 
C) link 
D) index 
A) anchor 
B) source 
C) link 
D) index

Question 20

The default template places the formula results aligned to the ____ of a cell.

Accepted Answer

A) right side 
B) left side 
C) top 
D) bottom 
A) right side 
B) left side 
C) top 
D) bottom

A(n) $\underline { \text { asterisk } }$ separates the worksheet reference from the cell or range reference._________________________

Formulas created using the point-and-click method contain ____ references.

If you receive a destination workbook but the source files are not included,click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.

The ____ caption indicates a worksheet group.

You can use the ____________________ dialog box to break links between workbooks.

If you trust the provider of source files,you can choose to ____ the content,which allows the external reference formulas to function and updates the links in the destination workbook.

To move a worksheet or worksheet group to another location in the same workbook,select the worksheets and then drag and drop them by the selected sheet ____.

When a worksheet group is selected,the ____ includes text to indicate this.

Using multiple worksheets makes it easier to group and summarize data.Describe features that can be applied by forming a worksheet group.

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.

A ____ is a workbook that you can open with the text,formats,and formulas already built into it.

A worksheet ____ is a collection of two or more selected worksheets.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A connection between two files allowing information to be transferred from one file to the other

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the information when two files are linked

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates that a link has to be updated manually by the user

Ryder has discovered the power of creating and viewing multiple workbooks. -Ryder wants to use the workbooks he has created on another computer.What steps does he need to take?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of two or more selected worksheets

If you need to use data located in one workbook in the other workbook,you have to create a(n)____ between the two workbooks.

The default template places the formula results aligned to the ____ of a cell.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 6: Managing Multiple Worksheets and Workbooks

A(n) asterisk ‾\underline { \text { asterisk } } asterisk ​ separates the worksheet reference from the cell or range reference._________________________

Formulas created using the point-and-click method contain ____ references.

If you receive a destination workbook but the source files are not included,click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.

You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.

The ____ caption indicates a worksheet group.

You can use the ____________________ dialog box to break links between workbooks.

If you trust the provider of source files,you can choose to ____ the content,which allows the external reference formulas to function and updates the links in the destination workbook.

To move a worksheet or worksheet group to another location in the same workbook,select the worksheets and then drag and drop them by the selected sheet ____.

When a worksheet group is selected,the ____ includes text to indicate this.

Using multiple worksheets makes it easier to group and summarize data.Describe features that can be applied by forming a worksheet group.

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.

A ____ is a workbook that you can open with the text,formats,and formulas already built into it.

A worksheet ____ is a collection of two or more selected worksheets.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A connection between two files allowing information to be transferred from one file to the other

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the information when two files are linked

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates that a link has to be updated manually by the user

Ryder has discovered the power of creating and viewing multiple workbooks. -Ryder wants to use the workbooks he has created on another computer.What steps does he need to take?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of two or more selected worksheets

If you need to use data located in one workbook in the other workbook,you have to create a(n)____ between the two workbooks.

The default template places the formula results aligned to the ____ of a cell.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

A(n) $\underline { \text { asterisk } }$ separates the worksheet reference from the cell or range reference._________________________