Exam 6: Managing Multiple Worksheets and Workbooks

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

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

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

All template files have the .xlts file extension.

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

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.

Identify the letter of the choice that best matches the phrase or definition. -​Contains the information when two files are linked

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

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? 

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

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

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.

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.

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

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 workbook based on a specific template always displays the name of the template followed by the date.

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

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.

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

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 link to new a document.What should he click in the Link to list?