Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
1. Using multiple worksheets makes it more difficult for you to group your data.
a. True
b. False
2. Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the
group.
a. True
b. False
3. If a worksheet group includes all the worksheets in a workbook, you can edit only the active worksheet.
a. True
b. False
4. If you delete a value from one cell in a worksheet group, the content is also deleted from the same cell in all the
worksheets in the group.
a. True
b. False
5. Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in
another worksheet.
a. True
b. False
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.
a. True
b. False
7. If the destination file is closed when you make a change in the source file, you choose whether to update the link to
display the current values when you open the destination file or continue to display the older values from the destination
file.
a. True
b. False
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
8. When you create a new workbook from a template, an unnamed copy of the template opens.
a. True
b. False
9. A workbook based on a specific template always displays the name of the template followed by the date.
a. True
b. False
10. All template files have the .xlts file extension.
a. True
b. False
11. In order to reference data located in one workbook in another workbook, you have to create a(n) dialog between the
two workbooks. _________________________
12. When you use the point-and-click method to build formulas with external references, Excel enters all of the required
punctuation, including quotation marks. _________________________
13. A(n) template is a workbook with labels, formats, and formulas already built into it with data removed.
_________________________
14. Hyperlinks are usually represented by words with colored letters and underlines or images.
_________________________
15. To delete a hyperlink, right-click the hyperlink cell and then click Clear Value. _________________________
16. Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget, Inventory List,
and Time sheets. _________________________
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
17. Excel, by default, looks for template files in the Templates folder, which is where custom template files are often
stored. _________________________
18. A worksheet ____ is a collection of two or more selected worksheets.
a. index b. roster
c. group d. cluster
19. Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.
a. controls b. groups
c. tabs d. ranges
20. The ____ caption indicates a worksheet group.
a. [Worksheets] b. [Selected Sheets]
c. [Group] d. [Workgroup]
21. To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.
a. index b. panel
c. tab d. pane
22. 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.
a. Remove Group b. No Group
c. Exit Group d. Ungroup Sheets
23. 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 ____.
a. tabs b. indices
c. keys d. icons
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
24. When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell
reference.
a. ? b. !
c. “ d. ;
25. When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the
sheet name in ____.
a. braces b. brackets
c. parentheses d. single quotation marks
26. The worksheet range ____ references the worksheets, “Sheet1,” “Sheet2,” “Sheet3,” and “Sheet4.”
a. Sheet1_Sheet4 b. Sheet1-Sheet4
c. Sheet1:Sheet4 d. Sheet1/Sheet4
27. Which of the following is NOT an option for arranging your workbooks?
a. tiled b. cascade
c. horizontal d. lateral
28. The ____ arrangement option layers the open workbooks on the screen.
a. Cascade b. Horizontal
c. Tiled d. Lateral
29. A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked
workbooks.
a. internal b. external
c. import d. export
30. You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.
a. mixed b. absolute
c. relative d. indexed
31. Formulas created using the point-and-click method contain ____ references.
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
a. absolute b. mixed
c. relative d. relational
32. 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.
a. Fix b. Break
c. Update d. Check
33. When you save a workbook that contains external reference formulas Excel stores the most recent results of those
formulas in the ____ file.
a. source b. destination
c. both a. and b. d. neither a. nor b.
34. If the destination file is closed when you make a change in the ____ file, you can choose whether to update the link to
display the current values when you open the destination file.
a. target b. origin
c. source d. key
35. If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links
dialog box will be ____.
a. Done b. Completed
c. OK d. Good
36. ____ are usually represented by words with colored letters and underlines or images.
a. Indices b. Hyperlinks
c. Templates d. Icons
37. When you click a(n) ____, the computer switches to the file or portion of the file that it references.
a. index b. hyperlink
c. template d. icon
38. The default ____ for a hyperlink is the folder location and the name of the file to which you will link.
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
a. title b. alt text
c. description d. ScreenTip
39. To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink.
a. Delete b. Erase
c. Archive d. Remove
40. The default template contains the default formatting you start out with in every new workbook, including ____ 11-
point font.
a. Calibri b. Helvetica
c. Geneva d. Times New Roman
41. 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
42. 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
43. 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
44. The default template places the formula results aligned to the ____ of a cell.
a. right side b. left side
c. top d. bottom
45. All template files have a(n) ____ extension.
a. .xlsx b. .xltx
c. .xldx d. .xtpl
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
Copyright Cengage Learning. Powered by Cognero.
Page 7
Case-Based Critical Thinking Questions
Case 6-1
Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help.
46. 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
47. 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.
48. 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.
Case-Based Critical Thinking Questions
Case 6-2
Ryder has discovered the power of creating and viewing multiple workbooks.
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
49. 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
50. When Ryder goes to save the workbooks, what is the required file extension?
a. .wxls b. .xlww
c. .xlsx d. .xlwx
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.
51. 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.
52. 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
53. 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.
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
54. 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
55. A(n) ____________________ group is a collection of two or more selected worksheets.
56. 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.
57. A(n) ____________________ is a connection between two files allowing information to be transferred from one file
to the other.
58. When two files are linked together, the workbook that contains the information is the ____________________ file.
59. When two files are linked together, the ____________________ file receives the information.
60. 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.
61. ____________________ a worksheet duplicates all the values, formulas, and formats into the new worksheet, leaving
the original worksheet intact.
62. A(n) ____________________ is a link in a file, such as a workbook, to information within that file or another file.
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
63. In the Links group, click the Hyperlink button and the _______ Hyperlink dialog box opens.
64. ____________________ appear whenever you place the pointer over a hyperlink.
66. After you have saved a template, you can access the template from the New screen in ____________________ view.
67. Using multiple worksheets makes it easier to group and summarize data. Describe features that can be applied by
forming a worksheet group.
68. What are the steps to inserting a hyperlink and linking to: a file or Web page, a location in the current workbook, a
new document, and an e-mail address.
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
69. What is an example of when you would use a template? Name at least three benefits of using a workbook template.
70. Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook
71. Usually represented by words with colored letters and underlines or images
72. Receives the information when two files are linked
73. Contains the information when two files are linked
74. A connection between two files allowing information to be transferred from one file to the other
Name:
Class:
Date:
Excel Module 06: Managing Multiple Worksheets and Workbooks
75. A collection of two or more selected worksheets