Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Usually represented by words with colored letters and underlines or images

Accepted Answer

The phrase describes a hyperlink.

Answer: F
 The phrase describes a link.

Answer: A
 The phrase describes 3-D.

Note: The other choices do not match the given phrase or definition.

Question 2

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.

Accepted Answer

To remove a worksheet group, you need to ungroup the sheets. Therefore, the best choice is D) Ungroup Sheets. A) Remove Group, B) No Group, and C) Exit Group do not exist as options in the shortcut menu.

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A collection of two or more selected worksheets

Accepted Answer

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

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A connection between two files allowing information to be transferred from one file to the other

Accepted Answer

A link is a connection between two files that allows information to be transferred from one file to the other.

Question 5

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

Accepted Answer

Worksheets in the same workbook are arranged as tabs in a row at the bottom of the worksheet. To move a worksheet or worksheet group to another location, you simply need to click and hold the selected sheet tabs and then drag and drop them to the desired location. Therefore, the correct answer is A) tabs.

Question 6

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

Accepted Answer

The answer of Like cell ____,a worksheet group can contain...

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains the information when two files are linked

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Divides the open workbooks evenly on the screen

Accepted Answer

"Tiled" is a formatting option in Excel that divides open workbooks evenly on the screen.

Question 9

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

Accepted Answer

To ungroup worksheets, you need to click on a sheet tab that is not in the group.

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Receives the information when two files are linked

Accepted Answer

The term "destination" refers to the file or location where information is received when two files are linked.

Answer: D
 The term "source" refers to the file or location where information is coming from when two files are linked.

Answer: F
 The term "link" refers to the connection between two files or locations when they are linked together.

Note: None of the other choices seem to fit the given phrase or definition.

Question 11

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

Accepted Answer

When referencing cells and ranges in other worksheets,if the worksheet name contains spaces, you must enclose the sheet name in single quotation marks.

Question 12

When you reference a cell or range in a different worksheet,the ____ separates the sheet reference from the cell reference.

Accepted Answer

The exclamation mark (!) separates the sheet reference from the cell reference in Excel when referencing a cell or range in a different worksheet.

Question 13

To select adjacent worksheets,you use the ____ key.

Accepted Answer

To select adjacent worksheets in applications like Microsoft Excel, you hold down the Shift key while clicking the tabs of the sheets you want to select. This allows for multiple worksheets to be selected at once for actions like formatting or data entry across all selected sheets.

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates that a link has to be updated manually by the user

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 15

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

Accepted Answer

The title bar includes text to indicate when a worksheet group is selected, showing the name of the workbook along with an indication that multiple sheets are selected.

Question 16

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

Accepted Answer

A group is a collection of two or more selected worksheets in Microsoft Excel. It allows you to perform the same action on multiple worksheets at once. The other options (index, roster, and cluster) do not refer to a collection of worksheets.

Question 17

The ____ caption indicates a worksheet group.

Accepted Answer

The square bracketed caption [Group] is used to indicate a worksheet group in Microsoft Excel. The caption indicates that multiple worksheets have been grouped together for simultaneous editing or other operations. The other options do not indicate a worksheet group. [Worksheets] is the default caption when no sheets are selected, [Selected Sheets] indicates only the sheets currently selected, and [Workgroup] is not a valid caption in Excel.

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

Accepted Answer

A 3-D cell reference refers to the same cell or range of cells on multiple worksheets in the same workbook.

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates a link that is updated automatically

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains text,formats,and formulas already built into it for your use

Accepted Answer

A template is a pre-designed document that contains text, formatting, and formulas already built into it for your use.

Answer: H
 A worksheet group is a collection of two or more worksheets that are grouped together in Excel.

Answer: C
 This question does not provide enough context to determine the correct answer.

Quiz 6: Managing Multiple Worksheets and Workbooks

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Usually represented by words with colored letters and underlines or images

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of two or more selected worksheets

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A connection between two files allowing information to be transferred from one file to the other

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains the information when two files are linked

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Divides the open workbooks evenly on the screen

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Receives the information when two files are linked

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

When you reference a cell or range in a different worksheet,the ____ separates the sheet reference from the cell reference.

To select adjacent worksheets,you use the ____ key.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates that a link has to be updated manually by the user

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

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

The ____ caption indicates a worksheet group.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Type of cell reference that refers to the same cell or range of cells on multiple worksheets in the same workbook

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates a link that is updated automatically

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains text,formats,and formulas already built into it for your use