Excel Chapter 6 MC

Question 1

A worksheet ____ is a collection of two or more selected worksheets.

Answer 1

Group

Question 2

Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.

Answer 2

Ranges

Question 3

Rather than laboriously retyping the same formulas across a series of worksheets, you can enter them all at once by

Answer 3

Group

Question 4

If you cannot see the sheet tab of a worksheet you want to include in a group, use the sheet ____ controls to display it.

Answer 4

Navigation

Question 5

Which caption indicates a worksheet group?

Answer 5

[Group]

Question 6

To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.

Answer 6

Tab

Question 7

When a worksheet group is selected, the ____ includes text to indicate this.

Answer 7

Title Bar

Question 8

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

Answer 8

Tabs

Question 9

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

Answer 9

Bold

Question 10

When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____.

Answer 10

Single quotation marks

Question 11

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.

Answer 11

3-D

Question 12

If a sheet range includes more than one sheet, you specify the first and last sheet in the range separated by a ____.

Answer 12

Colon

Question 13

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.

Answer 13

Page Setup

Question 14

Which of the following Custom Header buttons adds the worksheet name to the top of each page?

Answer 14

Insert Sheet Name

Question 15

A link is a connection between two ____ allowing information to be transferred from one to the other.

Answer 15

Files

Question 16

If you need to use data located in one workbook in the other workbook, you have to create a(n) ____ between the two

Answer 16

Link

Question 17

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

Answer 17

Cascade

Question 18

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

Answer 18

Mixed

Question 19

Formulas created using the point-and-click method contains ____ references.

Answer 19

Absolute

Question 20

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.

Answer 20

Enable

Question 21

When two workbooks are ____, it is important that the data in the destination file accurately reflects the contents of the

Answer 21

Linked

Question 22

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.

Answer 22

Source

Question 23

The ____ dialog box lists all of the links in the current workbook.

Answer 23

Edit Links

Question 24

A workspace saves all of the following information about the currently opened workbooks EXCEPT ____.

Answer 24

Formats used 
(Saves locations, window sizes, and zoom magnifications)

Question 25

You can insert a ____ directly in a workbook file.

Answer 25

Hyperlink

Question 26

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

Answer 26

Hyperlinks

Question 27

When you click a(n) ____, the computer switches to the file or portion of the file that it references.

Answer 27

Hyperlink

Question 28

The default ____ for a hyperlink is the folder location and the name of the file to which you will link.

Answer 28

ScreenTip

Question 29

Each time you start Excel, a blank ____ workbook opens.

Answer 29

Book1

Question 30

A ____ is a blank workbook that you can open with the text, formats, and formulas already built into it.

Answer 30

Template