Question 1

Consolidated workbooks help you standardize the appearance and content of workbooks.

Accepted Answer

The answer of Consolidated workbooks help you standardize the appearance...

Question 2

To select nonadjacent worksheets you use the ____ key.
A)Alt
B)Ctrl
C)Esc
D)Shift

Accepted Answer

To select nonadjacent worksheets in programs like Microsoft Excel, you hold down the Ctrl key while clicking on the tabs of the sheets you want to select. This allows for the selection of multiple sheets that are not next to each other.

Question 3

Plans reports schedules and budgets are all categories of tasks available on Microsoft Office Online

Accepted Answer

Microsoft Office Online primarily offers applications like Word, Excel, PowerPoint, and OneNote for creating documents, spreadsheets, presentations, and notes, rather than categorizing or managing tasks. Task management is more directly handled by applications like Microsoft To Do or Microsoft Planner.

Question 4

A worksheet ____ is a collection of two or more selected worksheets.
A)index
B)roster
C)group
D)cluster

Accepted Answer

A group is a collection of two or more selected worksheets.

Question 5

To select nonadjacent worksheets you click a sheet tab of one of the worksheets and then press and hold down the Shift key as you click the sheet tabs of other worksheets you want included in the group.

Accepted Answer

To select nonadjacent worksheets, you click a sheet tab of one of the worksheets, then press and hold down the Ctrl key as you click the sheet tabs of other worksheets you want included in the group.

Question 6

To select adjacent worksheets you use the ____ key.
A)Shift
B)Alt
C)Ctrl
D)F1

Accepted Answer

To select adjacent worksheets in applications like Microsoft Excel, you hold down the Shift key while clicking the tabs of the sheets you want to select. This allows for multiple worksheets to be selected at once for actions like formatting or data entry across all selected sheets.

Question 7

You copy formulas with 3-D references the same way you copy other formulas-using copy and paste or AutoFill.

Accepted Answer

You can copy formulas with 3-D references the same way you copy other formulas using copy and paste or AutoFill. The references in the formula will adjust automatically based on the relative position of the source and destination cells.

Question 8

When you use the point-and-click method to build formulas with external references Excel enters all of the required punctuation except quotation marks.

Accepted Answer

The answer of When you use the point-and-click method to...

Question 9

A(n)dialog is a connection between two files allowing information to be transferred from one file to the other.

Accepted Answer

A dialog is a communication or exchange between two individuals, not necessarily files. A file may be involved in a dialog, but the dialog itself is not exclusively between files.

Question 10

Rather than laboriously retyping the same formulas across a series of worksheets you can enter them all at once by creating a worksheet ____.
A)index
B)roster
C)group
D)cluster

Accepted Answer

By creating a worksheet group, you can enter formulas and data in one worksheet and it will automatically appear in all the worksheets in the group, saving time and effort.

Question 11

Like cell ____ a worksheet group can contain adjacent or nonadjacent sheets.
A)controls
B)groups
C)tabs
D)ranges

Accepted Answer

The answer of Like cell ____ a worksheet group can...

Question 12

The item indicated in the accompanying figure is the Security Bar .

Accepted Answer

The answer of  The item indicated in the accompanying...

Question 13

When the destination file is closed and the source files are closed the complete file path is included as part of the external reference formula that appears in the formula bar.

Accepted Answer

When the destination file is closed, the complete file path is included in the external reference formula. However, when both the source and destination files are open, only the file name appears in the formula, not the complete path.

Question 14

When you apply the Comma Style number format to a cell range the values in the range will appear with a(n)decimal point and no comma .

Accepted Answer

When you apply the Comma Style number format to a cell range, the values in the range will appear with comma separators and no decimal point.

Question 15

The default template contains the default formatting you start out with in every new workbook including labels aligned to the left side of a cell.

Accepted Answer

The default template in Excel does indeed contain default formatting including left-aligned labels in cells.

Question 16

In order to reference data located in one workbook in another workbook you have to create a(n)dialog between the two workbooks.

Accepted Answer

To reference data located in one workbook in another, you create a link or external reference, not a dialog.

Question 17

In the dialog box shown in the accompanying figure the source file type of the files is Excel worksheet .

Accepted Answer

The sentence in the question states that "in the dialog box shown in the accompanying figure the source file type of the files is Excel worksheet."

Question 18

A blank workbook you can open with the text formats and formulas already built into it is called a(n)spreadsheet .

Accepted Answer

A blank workbook does not have any text formats or formulas built into it. It is an empty spreadsheet that you can customize according to your needs.

Question 19

If Excel has not attempted to update the links in a given session the Edit Links dialog box will show the status of the links as not checked .

Accepted Answer

The answer of  If Excel has not attempted to...

Question 20

As with inserting formulas and text any formatting changes you make to a single sheet in a(n)group are applied to all sheets.

Accepted Answer

Any formatting changes made to a single sheet within a group are automatically applied to all sheets within that group.

Quiz 6: Excel: Managing Multiple Worksheets and Workbooks