Question 1

FIGURE EX 7-1  The area indicated by #1 in Figure EX 7-1 above is ____.

Accepted Answer

The answer of FIGURE EX 7-1  The area indicated...

Question 2

Case EX 7-2 Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. Ron now wants to change the tab color. He first right-clicks the sheet tab he wants to recolor, points to ____ on the shortcut menu, and then clicks the color he wants for the tab.

Accepted Answer

Ron needs to change the color of the tab, so he needs to select "Tab Color" from the shortcut menu. Option A is not specific enough, Option B is also not specific to the tab, and Option D is not a valid choice in this case.

Question 3

The active workbook has all of the following EXCEPT: ____.

Accepted Answer

The active workbook may have an Excel program icon in the upper-left corner, sizing buttons, and scroll bars, but it does not necessarily have a blue status bar. The status bar may be a different color or even turned off entirely.

Question 4

When working with cell references, any change you make to the ____ cell also changes the value in the destination cell.

Accepted Answer

When you use a cell reference in a formula, the value in the destination cell (where the formula is located) is based on the value in the source cell (the cell being referenced). Therefore, any change made to the source cell will also change the value in the destination cell.

Question 5

The Print option called Print ____ prints the worksheet that appears on-screen, or a group of selected worksheets.

Accepted Answer

The "Print Active Sheets" option is used to print the worksheet that is currently active or a group of selected worksheets. This means it prints the content that appears on-screen or the specifically selected sheets within a workbook.

Question 6

To make a workbook active, just click ____.

Accepted Answer

Clicking either its title bar or anywhere in the worksheet can make a workbook active.

Question 7

When the Move or Copy dialog box appears, click the To book arrow and click the workbook where you want to move or copy the selected worksheet. After you select the destination workbook, the names of all of its worksheets appear in the ____ sheet box.

Accepted Answer

The names of all worksheets in the destination workbook appear in the "Before" sheet box, allowing you to specify where to place the moved or copied worksheet relative to the existing ones.

Question 8

Case EX 7-2 Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. How does Ron go about renaming his worksheet?

Accepted Answer

Ron can either right-click the sheet tab and select Rename, or double-click the sheet tab and type the new name before pressing Enter. Both methods will allow him to rename the worksheet.

Question 9

You can tell which workbook is active by looking at its title. The active workbook has a ____ title bar.

Accepted Answer

The active workbook has a gray title bar, distinguishing it from inactive workbooks which may have a different color or appear faded/diminished in contrast.

Question 10

To select multiple worksheets in a workbook, hold down the ____ key as you click the sheet tab of each worksheet you want to include in the group.

Accepted Answer

Holding down the Ctrl key allows you to select multiple non-adjacent worksheet tabs in a workbook.

Question 11

Case EX 7-1 Kristin wants to arrange multiple workbooks in a way where she can compare figures. Kristin wants to move the February worksheet from the February Statement workbook to the Annual Statement workbook. She intends to place the February worksheet after the January worksheet in the Annual Statement workbook. What should she do?

Accepted Answer

To move a worksheet from one workbook to another, you should right-click the tab of the sheet you want to move, then select "Move or Copy" from the shortcut menu. This allows you to choose the destination workbook and the position where the sheet will be placed. In this scenario, since Kristin wants to move the February worksheet from the February Statement workbook to the Annual Statement workbook, she should perform these actions starting from the February Statement workbook.

Question 12

The Print option called Print ____ prints the range or ranges selected within a single worksheet.

Accepted Answer

The Print Selection option will only print the range or ranges that are currently selected within a single worksheet. This is the best choice for printing specific information without including unnecessary data from the entire workbook or active sheets.

Question 13

The Print option called Print ____ prints all of the worksheets in a workbook.

Accepted Answer

The option that will print all of the worksheets in a workbook is "Entire Workbook".

Question 14

FIGURE EX 7-1  The area indicated by #2 in Figure EX 7-1 above is ____.

Accepted Answer

The answer of FIGURE EX 7-1  The area indicated...

Question 15

When you reposition a worksheet, a placement ____________________ indicates the new location.

Accepted Answer

The answer of When you reposition a worksheet, a placement...

Question 16

Case EX 7-1 Kristin wants to arrange multiple workbooks in a way where she can compare figures. Kristin wants to access the Arrange Windows dialog box. She clicks the ____ tab on the Ribbon, and then in the Window group, clicks the Arrange All button.

Accepted Answer

The Arrange Windows dialog box is located under the View tab on the Ribbon. Therefore, the correct choice is C, View.

Question 17

To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu.

Accepted Answer

The option "Move or Copy" is specifically mentioned in the question as the action to take for moving or copying a worksheet.

Question 18

In a worksheet range, as in a cell range, a ____ separates the names of the first worksheet and the last worksheet in the group.

Accepted Answer

A colon separates the names of the first worksheet and the last worksheet in a worksheet range.

Question 19

FIGURE EX 7-1  The area indicated by #3 in Figure EX 7-1 above is ____.

Accepted Answer

The area indicated by #3 in Figure EX 7-1 above represents tab scrolling buttons which allow users to move left or right across the available sheet tabs.

Question 20

When using the Arrange Windows dialog box, the ____ layout is NOT an option.

Accepted Answer

The Split layout is not an option in the Arrange Windows dialog box. The other three options (Tiled, Vertical, and Cascade) are available.

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

FIGURE EX 7-1 The area indicated by #1 in Figure EX 7-1 above is ____.