Question 1

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

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

Question 2

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 3

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

Accepted Answer

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

Question 4

To select nonadjacent worksheets,you use the ____ key.

Accepted Answer

To select nonadjacent worksheets, you can hold down the Ctrl key and click on each individual sheet tab that you want to select.

Question 5

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 6

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

Accepted Answer

Navigation controls are used to move between sheets and also display hidden sheets.

Question 7

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 or file containing a set of formats, layout, and formulas that can be used to create new, similar documents or files.

Answer: K
 A worksheet group is a collection of two or more adjacent or non-adjacent worksheets that are grouped together to perform certain actions, such as formatting or editing, on all of them at the same time.

Answer: C
 The letter "A" is not a valid choice for any of the given phrases or definitions.

Question 8

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 destination receives the information when two files are linked.

Question 9

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

Accepted Answer

Creating a worksheet group allows you to enter formulas or data across multiple worksheets simultaneously.

Question 10

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, we need to ungroup the sheets. So, the correct option is D) Ungroup Sheets.

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Saves information about currently opened workbooks

Accepted Answer

A workspace saves information about currently opened workbooks, allowing you to reopen them together later.

Question 12

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

Accepted Answer

To ungroup worksheets, you have to click on the tab of a sheet that is not in the group. The tabs are located at the bottom of the Excel window and identify each sheet within the workbook. Therefore, Choice C (tab) is the correct answer.

Question 13

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 14

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

Tabs are the clickable labels along the bottom of the workbook that represent each worksheet. Dragging and dropping the selected sheets by the tabs will move them to a new location within the same workbook.

Question 15

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 16

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

Accepted Answer

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

Question 17

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 allowing information to be transferred from one file to the other.

Question 18

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 when referencing a cell or range in a different worksheet. For example, if cell A1 in Sheet1 is referencing cell B1 in Sheet2, the formula would be "=Sheet2!B1".

Question 19

The ____ caption indicates a worksheet group.

Accepted Answer

The caption [Group] indicates that the worksheets are currently grouped together, meaning any action taken on one worksheet in the group will be applied to all other worksheets in the group. [Worksheets] and [Selected Sheets] are not related to worksheet grouping. [Workgroup] refers to a group of individuals working together.

Question 20

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

Accepted Answer

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

Quiz 6: Managing Multiple Worksheets and Workbooks

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

To select adjacent worksheets,you use the ____ key.

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

To select nonadjacent worksheets,you use the ____ key.

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

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

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

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