Excel Tutorial 6: Managing Multiple Worksheets and Workbooks
When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.
B. !
All template files have a(n) ____ extension.
B. .xltx
Formulas created using the point-and-click method contain ____ references.
A. Asbolute
The default template contains the default formatting you start out with in every new workbook, including ____ 11-point font.
A. Calibri
The ____ arrangement option layers the open workbooks on the screen.
A. Cascade
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
You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.
A. Mixed
The default template places the formula results aligned to the ____ of a cell.
A. Right side
To select adjacent worksheets, you use the ____ key.
A. Shift
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
When a worksheet group is selected, the ____ includes text to indicate this.
A. Title Bar
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.
B. Break
When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.
B. Destination
A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.
B. External
When you click a(n) ____, the computer switches to the file or portion of the file that it references.
B. Hyperlink
____ are usually represented by words with colored letters and underlines or images.
B. Hyperlinks
The general format of a 3-D cell reference is ____.
B. WorksheetRange!CellRange
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: _
D. '[Sales.xlsx]Summary Info'!B6
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.
D. 3-D
Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?
D. Fax Cover Sheet
A link is a connection between two ____ allowing information to be transferred from one to the other.
D. Files
Which of the following is NOT an option for arranging your workbooks?
D. Lateral
Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.
D. Ranges
To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink.
D. Remove
The default ____ for a hyperlink is the folder location and the name of the file to which you will link.
D. ScreenTip
When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ___
D. Single Quotation Marks
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.
D. Ungroup sheets
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.
B. [WorkbookName]WorksheetName!CellRange
Which of the following formulas is correct, given a sheet named Sales Data?
C. 'Sales Data'!D10
A worksheet ____ is a collection of two or more selected worksheets.
C. Group
If you need to use data located in one workbook in the other workbook, you have to create a(n) ____ between the two workbooks.
C. Link
If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____.
C. OK
The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4."
C. Sheet 1:Sheet 4
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.
C. Source
To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.
C. Tab
A ____ is a workbook that you can open with the text, formats, and formulas already built into it.
C. Template
The ____ template in Excel creates an online time card to track employees' work hours.
C. Time Sheet
The ____ caption indicates a worksheet group.
C. [Group]