Exam 6: Managing Multiple Worksheets and Workbooks

All template files have a(n)____ extension.

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

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

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(n)____________________ is a connection between two files allowing information to be transferred from one file to the other.

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

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

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

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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a link that is updated automatically

A(n) $\underline { \text { template } }$ is a workbook with labels,formats,and formulas already built into it with data removed._________________________

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

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

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

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

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

To delete a hyperlink,right-click the hyperlink cell and then click Clear $\underline { \text { Value } }$ ._________________________

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

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