Homework answers / question archive / Excel Tutorial 6: Managing Multiple Worksheets and Workbooks   TRUE/FALSE        1)   Using multiple worksheets makes it more difficult for you to group your data

Excel Tutorial 6: Managing Multiple Worksheets and Workbooks   TRUE/FALSE        1)   Using multiple worksheets makes it more difficult for you to group your data

Computer Science

Share With

---

 

TRUE/FALSE

 

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

 

 

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

 

 

     3.   If a worksheet group includes all the worksheets in a workbook, you can edit only the active worksheet.

 

 

     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.

 

 

     5.   Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

 

 

     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.

 

 

     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.

 

     8.   When you create a new workbook from a template, an unnamed copy of the template opens.

 

 

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

 

 

   10.   All template files have the .xlts file extension.

 

 

MODIFIED TRUE/FALSE

 

     1.   To select nonadjacent worksheets, you click a sheet tab of one of the worksheets, and then press and hold down the Ctrl key as you click the sheet tabs of other worksheets you want included in the group. _________________________

 

     2.   In order to reference data located in one workbook in another workbook, you have to create a(n) dialog between the two workbooks. _________________________

 

 

     3.   When you use the point-and-click method to build formulas with external references, Excel enters all of the required punctuation, including quotation marks. _________________________

 

 

     4.   In the figure above, cell A8 contains a hyperlink. _________________________

 

 

     5.   A(n) asterisk separates the worksheet reference from the cell or range reference. _________________________

 

 

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

 

 

     7.   Hyperlinks are usually represented by words with colored letters and underlines or images. _________________________

 

 

     8.   To delete a hyperlink, right-click the hyperlink cell and then click Clear Value. _________________________

 

 

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

 

 

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

 

MATCHING

 

Identify the letter of the choice that best matches the phrase or definition.

a.	3-D	f.	link
b.	template	g.	M
c.	A	h.	worksheet group
d.	source	i.	hyperlink
e.	destination	j.	Tiled

 

 

     1.   Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

 

     2.   Usually represented by words with colored letters and underlines or images

 

     3.   Divides the open workbooks evenly on the screen

 

     4.   Indicates that a link has to be updated manually by the user

 

     5.   Indicates a link that is updated automatically 

 

     6.   Receives the information when two files are linked

 

     7.   Contains text, formats, and formulas already built into it for your use

 

     8.   Contains the information when two files are linked

 

     9.   A connection between two files allowing information to be transferred from one file to the other

 

   10.   A collection of two or more selected worksheets

 

MULTIPLE CHOICE

 

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

a.	index	c.	group
b.	roster	d.	cluster

 

 

 

     2.   Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.

a.	controls	c.	tabs
b.	groups	d.	ranges

 

 

 

     3.   To select adjacent worksheets, you use the ____ key.

a.	Shift	c.	Ctrl
b.	Alt	d.	F1

 

 

 

     4.   The ____ caption indicates a worksheet group.

a.	[Worksheets]	c.	[Group]
b.	[Selected Sheets]	d.	[Workgroup]

 

 

 

     5.   To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.

a.	index	c.	tab
b.	panel	d.	pane

 

 

 

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

a.	title bar	c.	status bar
b.	worksheet bar	d.	formula bar

 

 

 

     7.   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	c.	Exit Group
b.	No Group	d.	Ungroup Sheets

 

 

 

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

a.	tabs	c.	keys
b.	indices	d.	icons

 

 

 

     9.   When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.

a.	?	c.	"
b.	!	d.	;

 

 

 

   10.   When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____.

a.	braces	c.	parentheses
b.	brackets	d.	single quotation marks

 

 

 

   11.   Which of the following formulas is correct, given a sheet named Sales Data?

a.	(Sales Data)!D10	c.	'Sales Data'!D10
b.	[Sales Data]!D10	d.	{Sales Data}!D10

 

 

 

   12.   The general format of a 3-D cell reference is ____.

a.	CellRange!WorksheetRange	c.	WorkbookRange!CellRange
b.	WorksheetRange!CellRange	d.	CellRange!WorkbookRange

 

 

 

   13.   The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4."

a.	Sheet1_Sheet4	c.	Sheet1:Sheet4
b.	Sheet1-Sheet4	d.	Sheet1/Sheet4

 

 

 

   14.   A(n) ____ cell reference specifies not only the rows and columns of a cell range, but also the names of the worksheets on which the cells appear.

a.	indexed	c.	absolute
b.	relational	d.	3-D

 

 

 

   15.   A link is a connection between two ____ allowing information to be transferred from one to the other.

a.	cells	c.	columns
b.	ranges	d.	files

 

 

 

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

a.	anchor	c.	link
b.	source	d.	index

 

 

 

   17.   The general form of an external reference is ____, where Path is the path of the workbook file on the computer or network, Workbook Name is the filename of the workbook, and Sheet Range and Cell Range are worksheets and cells in the workbook, respectively.

a.	(WorkbookName)WorksheetName!CellRange
b.	[WorkbookName]WorksheetName!CellRange
c.	[WorkbookName]WorksheetName!CellRange
d.	/WorkbookName/WorksheetName/CellRange

 

 

   18.   If you want to create a cell reference to B6 on the Summary Info worksheet of the Sales.xls workbook, you would use the following external reference: ____.

a.	'[Sales.xlsx]Summary Info'/B6	c.	'[Sales.xlsx:Summary Info]'!B6
b.	'(Sales.xlsx)Summary Info'!B6	d.	'[Sales.xlsx]Summary Info'!B6

 

 

 

   19.   Which of the following is NOT an option for arranging your workbooks?

a.	tiled	c.	horizontal
b.	cascade	d.	lateral

 

 

 

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

a.	Cascade	c.	Tiled
b.	Horizontal	d.	Lateral

 

 

 

   21.   A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.

a.	internal	c.	import
b.	external	d.	export

 

 

 

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

a.	mixed	c.	relative
b.	absolute	d.	indexed

 

 

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

a.	absolute	c.	relative
b.	mixed	d.	relational

 

 

 

   24.   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	c.	Update
b.	Break	d.	Check

 

 

 

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

a.	enable	c.	concatenate
b.	embed	d.	consolidate

 

 

 

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

a.	source	c.	both a. and b.
b.	destination	d.	neither a. nor b.

 

 

 

   27.   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	c.	source
b.	origin	d.	key

 

 

 

   28.   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	c.	OK
b.	Completed	d.	Good

 

 

 

   29.   ____ are usually represented by words with colored letters and underlines or images.

a.	Indices	c.	Templates
b.	Hyperlinks	d.	Icons

 

 

 

   30.   When you click a(n) ____, the computer switches to the file or portion of the file that it references.

a.	index	c.	template
b.	hyperlink	d.	icon

 

 

 

   31.   The default ____ for a hyperlink is the folder location and the name of the file to which you will link.

a.	title	c.	description
b.	alt text	d.	ScreenTip

 

 

 

   32.   To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink.

a.	Delete	c.	Archive
b.	Erase	d.	Remove

 

 

 

   33.   The default template contains the default formatting you start out with in every new workbook, including ____ 11-point font.

a.	Calibri	c.	Geneva
b.	Helvetica	d.	Times New Roman

 

 

 

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

a.	boiler	c.	template
b.	summary sheet	d.	range master

 

 

 

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

a.	Family Budget	c.	Team Roster
b.	Inventory List	d.	Fax Cover Sheet

 

 

 

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

a.	Payroll	c.	Time Sheet
b.	Personnel Statement	d.	Employment Calculator

 

 

 

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

a.	right side	c.	top
b.	left side	d.	bottom

 

 

 

   38.   All template files have a(n) ____ extension.

a.	.xlsx	c.	.xldx
b.	.xltx	d.	.xtpl

 

 

 

Case-Based Critical Thinking Questions

 

Case 6-1

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help.

 

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

 

 

 

   40.   After Brook 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.

 

 

 

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

 

   42.   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	c.	Click the Overlap option button
b.	Click the Tile Vertically option button	d.	Click the Cascade option button

 

 

 

   43.   Ryder wants to use the workbooks he has created on another computer. What steps does he need to take?

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.

 

 

 

   44.   When Ryder goes to save the workbooks, what is the required file extension?

a.	.wxls	c.	.xlsx
b.	.xlww	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.

 

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

 

 

 

   46.   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	c.	Create New Document
b.	Place in This Document	d.	E-mail Address

 

 

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

 

 

 

   48.   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	c.	E-mail address
b.	Create New Document	d.	Place in This Document

 

 

 

   49.   Click the button marked ____ in the accompanying figure to fix broken links.

a.	Break Link	c.	Check Status
b.	Update Values	d.	Change Source

 

 

 

   50.   Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.

a.	Break Link	c.	Check Status
b.	Update Values	d.	Change Source

 

 

   51.   In the Edit Links dialog box in the accompanying figure, ____ in the Update column indicates that links are updated automatically.

a.	Update Values	c.	A
b.	Automatic	d.	UPD

 

 

 

   52.   In the Edit Links dialog box in the accompanying figure, ____ in the Update column would indicate that a link has to be updated manually by the user.

a.	M	c.	U
b.	A	d.	UPD

 

 

 

COMPLETION

 

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

 

 

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

 

 

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

 

 

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

 

 

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

 

 

     6.   If both the ____________________ and source files are open, Excel will update the link between them automatically whenever a value in the source file is changed.

 

 

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

 

 

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

 

 

     9.   ____________________ a worksheet duplicates all the values, formulas, and formats into the new worksheet, leaving the original worksheet intact.

 

 

   10.   A(n) ____________________ is a link in a file, such as a workbook, to information within that file or another file.

 

 

   11.   In the Links group, click the Hyperlink button and the _______ Hyperlink dialog box opens.

 

 

   12.   ____________________ appear whenever you place the pointer over a hyperlink.

 

 

   13.   To manually ____________________ a link and see the new data values, click the Update Values button.

 

 

   14.   To use a template that you create, the template file is typically placed in the ____________________ folder.

 

 

   15.   After you have saved a template, you can access the template from the New screen in ____________________ view.

 

 

ESSAY

 

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

 

 

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

 

 

     3.   What is an example of when you would use a template? Name at least three benefits of using a workbook template.