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

Question 1

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

Answer 1

True

Question 2

The active sheet has a blue sheet tab.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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 6

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

Question 7

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 8

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

Question 9

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 10

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

Question 11

Each workbook opens with five worksheets.

Question 12

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 13

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

Question 14

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

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

Question 15

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

Question 16

A worksheet is a collection of workbooks.

Question 17

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

Question 18

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

Question 19

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

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

Question 20

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 21

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 22

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 23

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 24

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 25

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 26

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 27

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 28

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 29

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 30

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 31

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 32

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 33

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 34

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 35

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

Question 36

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 37

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 38

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 39

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 40

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

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

Question 42

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

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

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

Question 45

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?

Question 46

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.