Excel Chapter 6 MC Flashcards
A worksheet ____ is a collection of two or more selected worksheets.
Group
Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.
Ranges
Rather than laboriously retyping the same formulas across a series of worksheets, you can enter them all at once by
Group
If you cannot see the sheet tab of a worksheet you want to include in a group, use the sheet ____ controls to display it.
Navigation
Which caption indicates a worksheet group?
[Group]
To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.
Tab
When a worksheet group is selected, the ____ includes text to indicate this.
Title 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 ____.
Tabs
The active worksheet in a group is indicated by ____ text.
Bold
When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____.
Single quotation marks
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.
3-D
If a sheet range includes more than one sheet, you specify the first and last sheet in the range separated by a ____.
Colon
You can set up the page layout and print area for all the worksheets in a workbook by selecting a worksheet group and then accessing the ____ dialog box.
Page Setup
Which of the following Custom Header buttons adds the worksheet name to the top of each page?
Insert Sheet Name
A link is a connection between two ____ allowing information to be transferred from one to the other.
Files
If you need to use data located in one workbook in the other workbook, you have to create a(n) ____ between the two
Link
The ____ arrangement option layers the open workbooks on the screen.
Cascade
You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.
Mixed
Formulas created using the point-and-click method contains ____ references.
Absolute
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.
Enable
When two workbooks are ____, it is important that the data in the destination file accurately reflects the contents of the
Linked
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.
Source
The ____ dialog box lists all of the links in the current workbook.
Edit Links
A workspace saves all of the following information about the currently opened workbooks EXCEPT ____.
Formats used (Saves locations, window sizes, and zoom magnifications)
You can insert a ____ directly in a workbook file.
Hyperlink
____ are usually represented by colored words with underlines or images.
Hyperlinks
When you click a(n) ____, the computer switches to the file or portion of the file that it references.
Hyperlink
The default ____ for a hyperlink is the folder location and the name of the file to which you will link.
ScreenTip
Each time you start Excel, a blank ____ workbook opens.
Book1
A ____ is a blank workbook that you can open with the text, formats, and formulas already built into it.
Template
