Excel Tutorial 6: Managing Multiple Worksheets and Workbooks

¡Supera tus tareas y exámenes ahora con Quizwiz!

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]


Conjuntos de estudio relacionados

Exam 4 (Assessment 4) Adult Health II

View Set

Circumference and Arc Length Assignment 100%

View Set

Econ 201M - Quiz 7: Chapter 24 Long Run Economic Growth

View Set

B Intro to IT unit 5 conditional statement assignment

View Set

Milady Ch. 8 Skin Disorders and Diseases

View Set

APUSH First Semester Study Guide

View Set