Question 1

When two files are linked together, the ____________________ file receives the information.

Accepted Answer

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

Question 2

Case-Based Critical Thinking Questions Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. After Brooke has helped Simon to resolve his original problem, Simon asks her about another linked workbook he has received. The source files for this workbook have not been included, but Simon would like to use the workbook with the most recent values from the source files. What should Brooke tell him?
A)He can open the workbook and click the Continue button in the Edit Links dialog box.
B)He can open the workbook and click the Break button in the Edit Links dialog box.
C)He can open the workbook and click the Change Source button in the Edit Links dialog box.
D)He will not be able to use the workbook until he obtains copies of the source files.

Accepted Answer

The Continue button in the Edit Links dialog box allows the user to update the linked workbook with the most recent values from the source files, even if the source files are not available.

Question 3

Case-Based Critical Thinking Questions Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible. Ryder opens all of the workbooks, and then he clicks the View tab on the Ribbon and clicks the Arrange All button. What should he do next to obtain the desired layout?
A)Click the Tile Horizontally option button
B)Click the Tile Vertically option button
C)Click the Overlap option button
D)Click the Cascade option button

Accepted Answer

The Cascade option arranges open workbooks so that they overlap with all title bars visible, allowing easy access to each workbook.

Question 4

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?
A)They appear whenever you place the pointer over a cell.
B)You can specify the contents of a ScreenTip when you create a hyperlink.
C)The default ScreenTip for a hyperlink is the message "Active Hyperlink."
D)You can change the contents of an existing ScreenTip by changing the value in the cell.

Accepted Answer

ScreenTips are small pop-up windows that can provide additional information about a hyperlink. When you create a hyperlink in Excel, you can specify the contents of the ScreenTip in the Edit Hyperlink dialog box. The default ScreenTip is the address of the hyperlink, but you can change this to any text you want. The ScreenTip will appear whenever you hover over the hyperlink with your mouse. The contents of an existing ScreenTip can be edited by modifying the hyperlink's settings. Modifying the cell value will not change the ScreenTip.

Question 5

All template files have a(n)____ extension.
A).xlsx
B).xltx
C).xldx
D).xtpl

Accepted Answer

Template files in Microsoft Excel have the extension .xltx. This file format is specifically designed for creating new workbooks with a consistent structure, formatting, and predefined formulas.

Question 6

Case-Based Critical Thinking Questions 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?
A)Existing File
B)Place in This Document
C)Create New Document
D)E-mail Address

Accepted Answer

Jared should select "Place in This Document" from the Link to list since he wants to create a hyperlink to a location in his current workbook. This option allows him to select the cell or range of cells to which he wants to link.

Question 7

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?
A)Family Budget
B)Inventory List
C)Team Roster
D)Fax Cover Sheet

Accepted Answer

All of the other options (Family Budget, Inventory List, Team Roster) are task-specific templates that can be found on the Microsoft Office Online Web site. However, a Fax Cover Sheet is a generic template that is not specific to any particular task.

Question 8

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

Question 9

Jared wants to create a hyperlink to link to new a document. What should he click in the Link to list?
A)Existing File or Web Page
B)Create New Document
C)E-mail address
D)Place in This Document

Accepted Answer

Jared wants to create a hyperlink to a new document, so he should choose "Create New Document" in the Link to list. This will allow him to create a new document and hyperlink to it directly.

Question 10

Case-Based Critical Thinking Questions Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. When Ryder goes to save the workbooks, what is the required file extension?
A).wxls
B).xlww
C).xlsx
D).xlwx

Accepted Answer

.xlsx is the required file extension for saving workbooks in Microsoft Excel.

Question 11

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

Accepted Answer

The answer of A(n)____________________ is a connection between two files...

Question 12

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Which of the following statements about hyperlinks in Excel workbooks is correct?
A)They are usually represented by bold faced words with underlines or images.
B)They can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook.
C)They cannot be used to jump to other types of files or sites on the Web.
D)To use a hyperlink, you can click anywhere in the cell that contains the link, including white space in the cell or any text that flows into an adjacent cell.

Accepted Answer

Hyperlinks in Excel workbooks can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook. They can also be used to jump to other types of files or sites on the Web. Option A is partially correct, as hyperlinks are usually represented by underlined text, but not necessarily bold faced. Option C is incorrect, as hyperlinks can be used to jump to other types of files or sites on the Web. Option D is partially correct, as you can click anywhere in the cell that contains the link, but not necessarily on any text that flows into an adjacent cell.

Question 13

A 3-D cell ____________________ specifies not only the rows and columns of a cell range, but also the range of worksheet names that the cells appear on.

Accepted Answer

The answer of A 3-D cell ____________________ specifies not only...

Question 14

The default template places the formula results aligned to the ____ of a cell.
A)right side
B)left side
C)top
D)bottom

Accepted Answer

The answer of The default template places the formula results...

Question 15

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

Question 16

Case-Based Critical Thinking Questions Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. Simon tells Brooke that when he attempts to open a workbook, the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message. Which of the following is a possible cause?
A)one of the workbook's source files was edited
B)one of the workbook's source files was copied to a different folder
C)one of the workbook's source files was replaced with an updated file of the same name
D)the workbook was sent to him without links

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 6-1 Simon...

Question 17

The ____ template in Excel creates an online time card to track employees' work hours.
A)Payroll
B)Personnel Statement
C)Time Sheet
D)Employment Calculator

Accepted Answer

The Time Sheet template in Excel is designed for tracking employees' work hours. It allows for easy entry of the employee's name and shift, and provides space for logging the hours worked each day, as well as any overtime or breaks. This template can be customized to fit different pay rates or work schedules, and can also be adapted to track time off or vacation days.

Question 18

A ____ is a workbook that you can open with the text, formats, and formulas already built into it.
A)boiler
B)summary sheet
C)template
D)range master

Accepted Answer

A template is a pre-made workbook that includes text, formatting, and formulas already built in. This can save time and provide consistency when creating multiple similar documents. A boiler is a type of heating unit, a summary sheet summarizes data, and a range master is not a commonly used term in Excel.

Question 19

A(n)____________________ group is a collection of two or more selected worksheets.

Accepted Answer

The answer of A(n)____________________ group is a collection of two...

Question 20

Case-Based Critical Thinking Questions Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. 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?
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.

Accepted Answer

If a destination file is open when a source file is changed, the destination file will be updated automatically.

Quiz 6: Excel 2: Managing Multiple Worksheets and Workbooks

When two files are linked together, the ____________________ file receives the information.

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?

All template files have a(n) ____ extension.

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

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

Jared wants to create a hyperlink to link to new a document. What should he click in the Link to list?

Case-Based Critical Thinking Questions Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. When Ryder goes to save the workbooks, what is the required file extension?

A(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Which of the following statements about hyperlinks in Excel workbooks is correct?

A 3-D cell ____________________ specifies not only the rows and columns of a cell range, but also the range of worksheet names that the cells appear on.

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

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.

The ____ template in Excel creates an online time card to track employees' work hours.

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

A(n)____________________ group is a collection of two or more selected worksheets.