Deck 29: Working With Multiple Worksheets and Workbooks

Question 1

A 3-D reference is a reference to the same cell or range in multiple worksheets that you use in a formula.

Answer 1

True

Question 2

A 3-D reference lists the worksheet range, an exclamation point, and a cell or range.

Answer 2

True

Question 3

To unhide a worksheet, right-click any sheet tab, and then click Unhide on the shortcut menu.

Answer 3

True

Question 4

To print all of the worksheets in the workbook, click Print Entire Workbook print option.

Question 5

You designate the portion of the workbook to print on the Area tab in Backstage view.

Question 6

To insert a blank worksheet, click the Insert Cells tab next to the existing sheet tabs.

Question 7

The active sheet has a blue sheet tab.

Question 8

Moving a worksheet does not affect 3-D references in the workbook.

Question 9

You can create a copy of a worksheet by pressing the ____ key as you drag and drop its sheet tab.

A) Ctrl
B) Tab
C) F3
D) Enter

Question 10

A worksheet is a collection of workbooks.

Question 11

A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then summarize the total sales in another worksheet.

Question 12

You can use a 3-D reference with 24 different functions.

Question 13

To select more than one cell or range in a worksheet, select the first cell or range, hold down the Shift key, and select each additional cell or range.

Question 14

Each workbook opens with five worksheets.

Question 15

The formula =SUM(Sheet2:Sheet4!D12), adds the value from cell D12 in the Sheet2, Sheet3, and Sheet4 worksheets.

Question 16

Until ____ are named, they are identified as Sheet1, Sheet2, and so on.

A) worksheets
B) workbooks
C) cells
D) ranges

Question 17

You can reposition a worksheet by dragging its ____ to a new location.

A) sheet tab
B) cells
C) file name
D) right border

Question 18

Deleting does not permanently remove a worksheet and all its contents from the workbook.

Question 19

To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the ____ group, click the arrow to the right of the Delete button, and then click Delete Sheet.

A) Workbook
B) Cells
C) Data
D) Worksheet

Question 20

To insert a worksheet, on the Home tab of the Ribbon, in the Cells group, click the arrow to the right of the Insert button, and then click ____.

A) Insert
B) Sheet
C) Worksheet
D) Insert Sheet

Question 21

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.

A) Data
B) Format
C) View
D) Edit

Question 22

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

A) Sheet tabs for the inactive worksheets
B) Sheet tabs for the active worksheets
C) Tab scrolling buttons
D) Custom sheet buttons

Question 23

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

A) Active Sheets
B) Selection
C) Entire Workbook
D) Range

Question 24

To make a workbook active, just click ____.

A) its title bar
B) anywhere in the worksheet
C) either a. or b.
D) neither a. nor b.

Question 25

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

A) source
B) primary
C) main
D) active

Question 26

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

A) red
B) white
C) gray
D) green

Question 27

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?

A) Right-click its sheet tab, and then click Rename on the shortcut menu
B) Double-click its sheet tab, type the new name, and then press the Enter key
C) Either a. or b.
D) Neither a. nor b.

Question 28

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.

A) Move or Copy
B) Relocate
C) New
D) Location

Question 29

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

A) an Excel program icon in the upper-left corner
B) a blue status bar
C) sizing buttons
D) scroll bars

Question 30

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

A) Sheet tabs for the inactive worksheets
B) Sheet tabs for the active worksheets
C) Tab scrolling buttons
D) Custom sheet tabs

Question 31

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.

A) Tab
B) Ctrl
C) F2
D) F3

Question 32

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

A) period
B) colon
C) comma
D) semicolon

Question 33

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.

A) To book
B) From book
C) Before
D) After

Question 34

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

Question 35

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

A) Sheet tabs for the inactive worksheets
B) Sheet tabs for the active worksheets
C) Tab scrolling buttons
D) Custom sheet tabs

Question 36

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

A) Active Sheets
B) Selection
C) Entire Workbook
D) All Sheets

Question 37

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.

A) Tab
B) Color
C) Tab Color
D) New Color

Question 38

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?

A) In the Annual Statement workbook, right-click the January sheet tab, and then click Move or Copy on the shortcut menu.
B) In the Annual Statement workbook, double-click the January sheet tab, and then click Arrange on the shortcut menu.
C) In the February Statement workbook, double-click the February sheet tab, and then click Arrange on the shortcut menu.
D) In the February Statement workbook, right-click the February sheet tab, and then click Move or Copy on the shortcut menu.

Question 39

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

A) Active Sheets
B) Selection
C) Entire Workbook
D) Entire Worksheet

Question 40

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

A) Tiled
B) Vertical
C) Cascade
D) Split

Question 42

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.

Question 43

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.

Question 44

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

Question 45

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

Question 46

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?