Question 1

Match between columns
                        Premises: Identifies the worksheets within the workbook.
The worksheet that appears in the workbook window.
The location the data is being transferred from.
The location where the data will appear after it is transferred.
A group of adjacent worksheets.

Accepted Answer

The Answer of Destination and Source and Worksheet range and is...

Question 2

A(n) ____________________ mark separates the worksheet range from its cell or range reference.

Accepted Answer

The answer of A(n) ____________________ mark separates the worksheet range...

Question 3

To display data or formula results from one worksheet in another worksheet of the same workbook, you use a(n) ____________________ with a reference to another worksheet.

Accepted Answer

The answer of To display data or formula results from...

Question 4

The ____________________ Print Area print option prints the entire worksheet, regardless of what print area is set for that worksheet.

Accepted Answer

The answer of The ____________________ Print Area print option prints...

Question 5

What would be a circumstance where you would want to hide one of the worksheets within a workbook? How do you go about hiding a worksheet?

Accepted Answer

The answer of What would be a circumstance where you...

Question 6

To delete a worksheet, you can right-click a sheet tab, click Delete on the shortcut menu, and then click ____________________ in the message box to delete a worksheet.

Accepted Answer

The answer of To delete a worksheet, you can right-click...

Quiz 13: Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Identify the letter of the choice that best matches the phrase or definition.

A(n) ____________________ mark separates the worksheet range from its cell or range reference.

To display data or formula results from one worksheet in another worksheet of the same workbook, you use a(n) ____________________ with a reference to another worksheet.

The ____________________ Print Area print option prints the entire worksheet, regardless of what print area is set for that worksheet.

What would be a circumstance where you would want to hide one of the worksheets within a workbook? How do you go about hiding a worksheet?

To delete a worksheet, you can right-click a sheet tab, click Delete on the shortcut menu, and then click ____________________ in the message box to delete a worksheet.