Exam 6: Managing Multiple Worksheets and Workbooks

-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 worksheet ____ is a collection of two or more selected worksheets.

Provide at least two different examples of when to use a linked workbook.

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

Case-Based Critical Thinking Questions Case 6-3 Your friend Connor asks you to help him learn more about using hyperlinks in an Excel workbook file. -Connor 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?

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Each worksheet functions independently again

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

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

If a sheet range includes more than one sheet,you specify the first and last sheet in the range separated by a ____.

____________________ appear whenever you place the pointer over a hyperlink.

To manually update the link and see the new data values,click the Update Values button in the Edit Links dialog box.

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Saves information about currently opened workbooks

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

To create a template,you simply save an Excel workbook in template format using the ____ dialog command.

Case-Based Critical Thinking Questions Case 6-2 Telden has discovered the power of creating a workspace that allows her to access a collection of workbooks at the same time. -Telden wants to use the workspace she has created on another computer.What steps does she need to take?

In the Edit Links dialog box in the accompanying figure,____ indicates that a link has to be updated manually by the user.