Question 1

Identify the letter of the choice that best matches the phrase or definition.
-Usually represented by words with colored letters and underlines or images

Accepted Answer

A)  3-D
B)  hyperlink
C)  worksheet group
D)  source
E)  destinationF) link B

Question 2

A(n)template is a workbook with labels,formats,and formulas already built into it with data removed._________________________

Accepted Answer

A) True 
 B)False  True

Question 3

Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget,Inventory List,and Time sheets._________________________

Accepted Answer

A) True 
 B)False  False

Question 4

All template files have the .xlts file extension.

Accepted Answer

A) True 
 B)False

Question 5

The ____ arrangement option layers the open workbooks on the screen.

Accepted Answer

A)   Cascade
B)   Horizontal 
C)   Tiled
D)   Lateral

Question 6

When the source and destination workbooks are stored in the same folder,you still need to include the location information in the workbook reference that links the two files.

Accepted Answer

A) True 
 B)False

Question 7

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)  hyperlink
C)  worksheet group
D)  source
E)  destinationF) link

Question 8

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

Question 9

Finally,Simon asks Brooke what steps (if any)need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Brooke would be correct?

Accepted Answer

A)   If a destination file is open when a source file is changed, the destination file will be updated automatically. 
B)   Source files cannot be updated unless the corresponding destination file is open. 
C)   It is not possible to choose whether a destination file should reflect changes made to the source files. 
D)   If a destination file is open when a source file is changed, you need to update the destination file manually so that it reflects the changes.

Question 10

Excel,by default,looks for template files in the Templates folder,which is where custom template files are often stored._________________________

Accepted Answer

A) True 
 B)False

Question 11

Once you group a collection of worksheets,any changes you make to one worksheet are applied to all sheets in the group.

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

To remove a worksheet group,you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

Accepted Answer

A)   Remove Group
B)   No Group 
C)   Exit Group
D)   Ungroup Sheets

Question 14

Using multiple worksheets makes it more difficult for you to group your data.

Accepted Answer

A) True 
 B)False

Question 15

Case 6-3
Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
-Jared wants to create a hyperlink to a location in his current workbook.He clicks the Hyperlink button in the Links group on the Insert tab.What option should he select from the Link to list?

Accepted Answer

A)   Existing File
B)   Place in This Document 
C)   Create New Document
D)   E-mail Address

Question 16

A workbook based on a specific template always displays the name of the template followed by the date.

Accepted Answer

A) True 
 B)False

Question 17

When two files are linked together,the workbook that contains the information is the ____________________ file.

Accepted Answer

The answer of When two files are linked together,the workbook...

Question 18

When the destination file is ____________________,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar.

Accepted Answer

The answer of When the destination file is ____________________,and the...

Question 19

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

Question 20

Case 6-3
Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
-Jared wants to create a hyperlink to link to new a document.What should he click in the Link to list?

Accepted Answer

A)   Existing File or Web Page
B)   Create New Document 
C)   E-mail address
D)   Place in This Document

Exam 6: Managing Multiple Worksheets and Workbooks

Identify the letter of the choice that best matches the phrase or definition. -Usually represented by words with colored letters and underlines or images

A(n)template is a workbook with labels,formats,and formulas already built into it with data removed._________________________

Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget,Inventory List,and Time sheets._________________________

All template files have the .xlts file extension.

The ____ arrangement option layers the open workbooks on the screen.

When the source and destination workbooks are stored in the same folder,you still need to include the location information in the workbook reference that links the two files.

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

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

Finally,Simon asks Brooke what steps (if any) need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Brooke would be correct?

Excel,by default,looks for template files in the Templates folder,which is where custom template files are often stored._________________________

Once you group a collection of worksheets,any changes you make to one worksheet are applied to all sheets in the group.

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.

To remove a worksheet group,you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

Using multiple worksheets makes it more difficult for you to group your data.

A workbook based on a specific template always displays the name of the template followed by the date.

When two files are linked together,the workbook that contains the information is the ____________________ file.

When the destination file is ____________________,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar.

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 ____.

Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared wants to create a hyperlink to link to new a document.What should he click in the Link to list?

Exam 6: Managing Multiple Worksheets and Workbooks

Identify the letter of the choice that best matches the phrase or definition. -Usually represented by words with colored letters and underlines or images

A(n)template is a workbook with labels,formats,and formulas already built into it with data removed._________________________

Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget,Inventory List,and Time sheets._________________________

All template files have the .xlts file extension.

The ____ arrangement option layers the open workbooks on the screen.

When the source and destination workbooks are stored in the same folder,you still need to include the location information in the workbook reference that links the two files.

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

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

Finally,Simon asks Brooke what steps (if any) need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Brooke would be correct?

Excel,by default,looks for template files in the Templates folder,which is where custom template files are often stored._________________________

Once you group a collection of worksheets,any changes you make to one worksheet are applied to all sheets in the group.

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.

To remove a worksheet group,you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.

Using multiple worksheets makes it more difficult for you to group your data.

A workbook based on a specific template always displays the name of the template followed by the date.

When two files are linked together,the workbook that contains the information is the ____________________ file.

When the destination file is ____________________,and the source files are closed,the complete file path is included as part of the external reference formula that appears in the formula bar.

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 ____.

Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared wants to create a hyperlink to link to new a document.What should he click in the Link to list?

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