Question 1

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

Accepted Answer

The range specified in the formula includes Sheet2, Sheet3, and Sheet4, and the formula adds the value from cell D12 in all three worksheets.

Question 2

The active sheet has a blue sheet tab.

Accepted Answer

In Excel, the active sheet tab is typically highlighted in a different color, but it is not specifically blue; the color can vary based on the version of Excel and the theme applied by the user.

Question 3

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

Accepted Answer

To insert a blank worksheet, you click the "New Sheet" button (which typically looks like a plus sign) next to the existing sheet tabs at the bottom of the Excel window, not the "Insert Cells" tab.

Question 4

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

Accepted Answer

Deleting a worksheet from a workbook permanently removes it and all its contents, unless you undo the action immediately or recover the workbook from a backup.

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.

Accepted Answer

To select more than one cell or range in a worksheet non-adjacently, you should hold down the Ctrl key (Command key on macOS), not the Shift key. The Shift key is used for selecting adjacent cells or ranges by selecting the first cell or range, holding down the Shift key, and then selecting the last cell or range in the sequence.

Question 6

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

Accepted Answer

To print all worksheets in a workbook, select the option to print the entire workbook. This option will print all worksheets in the workbook by default.

Question 7

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

Accepted Answer

Pressing the Ctrl key as you drag and drop a worksheet's sheet tab creates a duplicate of that worksheet.

Question 8

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

Accepted Answer

The answer of You can use a 3-D reference with...

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.

Accepted Answer

This is a common and logical organization for workbooks with sales data as it allows for easy analysis and comparison between territories/regions.

Question 10

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

Accepted Answer

Moving a worksheet within a workbook can affect 3-D references if the move changes the order of sheets included in the reference, as 3-D references depend on the position of sheets between the start and end points specified in the reference.

Question 11

Each workbook opens with five worksheets.

Accepted Answer

By default, Excel starts with one worksheet in a workbook, but this can be customized in the options settings.

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 ____.

Accepted Answer

The answer of To insert a worksheet, on the Home...

Question 13

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

Accepted Answer

A 3-D reference does indeed follow the format of referencing a worksheet range, followed by an exclamation point, and then a cell or range. For example, Sheet1!A1:A5 would be a 3-D reference that refers to cells A1 through A5 on Sheet1.

Question 14

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

Accepted Answer

Sheet tabs are the small tabs at the bottom of the Excel window that represent each worksheet in the workbook. By clicking and dragging the sheet tab, you can move the worksheet to a new location within the workbook.

Question 15

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

Accepted Answer

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

Question 16

A worksheet is a collection of workbooks.

Accepted Answer

This statement is incorrect. A worksheet is a collection of sheets within a single workbook.

Question 17

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

Accepted Answer

A 3-D reference allows you to refer to the same cell or range across multiple worksheets in a formula. This can be useful for calculations that involve data from different sheets in a workbook.

Question 18

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

Accepted Answer

You designate the portion of the workbook to print in the Print area of the Page Layout tab, not in Backstage view.

Question 19

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

Accepted Answer

Sheet1, Sheet2, etc. are names given to worksheets within a workbook. Workbooks refer to an entire Excel file and cannot be referred to as Sheet1, Sheet2, etc. Cells and ranges are specific locations within a worksheet and do not relate to the naming of the worksheet itself. Therefore, the correct choice is worksheets.

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.

Accepted Answer

The correct group in the Ribbon for deleting a sheet is the "Cells" group. This is where you find options related to cell and sheet management, including the Delete button which allows for the deletion of sheets when its arrow is clicked.

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