Exam 6: Excel: Managing Multiple Worksheets and Workbooks

Consolidated workbooks help you standardize the appearance and content of workbooks.

If both the destination and source files are open Excel will prompt you to update the link with the source file.

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

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

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

To select adjacent worksheets you use the ____ key.

Plans reports schedules and budgets are all categories of tasks available on Microsoft Office Online

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

Hyperlinks like the ones created with the dialog box in the accompanying figure can be used to jump to ____.

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

The active worksheet in a group is indicated by ____ text.

When you use a template you can make any changes you want to the workbook without affecting the template file.

When creating and saving a custom template you may find it helpful to replace variable data values with ____________________ which will help you recognize the cells in which to enter new data.

If two workbooks are located in the same folder you still need to include the location information in the workbook reference that links the two files.

When you start Excel and use the blank workbook that displays you are actually using a workbook based on a template known as the ___ template.

The Web Page format saves the worksheet as a(n)____ file and creates a folder that stores the supporting files.