Question 1

A worksheet cluster is a collection of several worksheets.

Accepted Answer

False

Question 2

If the destination file is closed when you make a change in the source file you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.

Accepted Answer

If the destination file is closed when a change is made in the source file, upon opening the destination file a prompt will appear asking whether to update the link with the current values or keep the older values from the destination file.

Question 3

Excel will prompt you to update the source file link when you initially open the destination file.

Accepted Answer

This is correct. When you open the destination file, Excel will check if there are any source file links that need to be updated and prompt you to do so if necessary.

Question 4

When using 3-D formulas to summarize data across worksheets if you change the value in one worksheet the result of the formulas that reference that cell will automatically show the result of the change.

Accepted Answer

3-D formulas in Excel are dynamic and automatically update their results when the value in any of the referenced cells is changed, even if the cell is on a different worksheet.

Question 5

If two workbooks are located in the same folder you still need to include the location information in the workbook reference that links the two files.

Accepted Answer

If two workbooks are located in the same folder, you do not need to include the full location information in the workbook reference. Simply referencing the workbook by name should suffice.

Question 6

The name of the sheet range is a required component in 3-D cell references.

Accepted Answer

A 3-D cell reference in Excel does not require the name of the sheet range; it can simply reference multiple sheets by specifying the first and last sheet names separated by a colon, along with the cell or range address.

Question 7

If you delete a value from one cell values in that cell will be deleted in all sheets in the group.

Accepted Answer

If cells are grouped together, any changes made to one of the cells will affect all the cells in the same group.

Question 8

You can enter 3-D references by using your mouse to select the appropriate worksheet cells in the workbook.

Accepted Answer

Yes, you can enter 3-D references by selecting appropriate cells on different worksheets using your mouse.

Question 9

When you use a template you can make any changes you want to the workbook without affecting the template file.

Accepted Answer

When you use a template, a new workbook is created based on the template file. Any changes you make to the new workbook will not affect the original template file.

Question 10

The workspace file contains the location and name of the file as well as the actual workbooks and worksheets.

Accepted Answer

The workspace file saves information about which workbooks are open and how their windows are arranged, but it does not contain the actual workbooks and worksheets themselves.

Question 11

You cannot move worksheets without making 3-D references inaccurate.

Accepted Answer

Moving worksheets within the same workbook does not affect 3-D references, as they automatically adjust to include the correct range of sheets.

Question 12

If you use the mouse to enter a 3-D reference you must first select the cell range followed by the sheet range.

Accepted Answer

When entering a 3-D reference using the mouse, you first select the sheet range and then the cell range.

Question 13

In Excel 2007 if you want to publish interactive versions of your workbook or items from the worksheet as a Web page with spreadsheet functionality you need to use a component of Microsoft Office Share-Point Server called MHTML Services.

Accepted Answer

In Excel 2007, you can publish interactive versions of your workbook or items from the worksheet as a Web page with spreadsheet functionality using the "Save as Web Page" feature. MHTML Services is not required for this.

Question 14

If both the destination and source files are open Excel will prompt you to update the link with the source file.

Accepted Answer

The answer of If both the destination and source files...

Question 15

Excel has some templates that are automatically installed on your hard disk.

Accepted Answer

Excel does come with several templates already installed on your hard disk.

Question 16

Once you group a collection of worksheets any changes you make to one worksheet are applied to all sheets in the group.

Accepted Answer

When you group worksheets in Excel, any changes made to one worksheet will be applied to all sheets in the group.

Question 17

If a worksheet group includes all the worksheets in a workbook you can edit only the active worksheet.

Accepted Answer

When a worksheet group includes all the worksheets in a workbook, you can only edit the active worksheet in that group.

Question 18

A workbook based on a specific template always displays the name of the template followed by a sequential number.

Accepted Answer

This is correct. When you create a new workbook based on a specific template, the name of the template is displayed followed by a sequential number in parentheses, such as "Budget.xlsx (1)". This helps to distinguish between different workbooks created from the same template.

Question 19

If you use a template once when you next open a blank workbook based on the template its original settings will still be present.

Accepted Answer

When you create a new workbook based on a template, the original formatting, settings, and content of the template will still be present.

Question 20

Using multiple worksheets makes it more difficult for you to group your data.

Accepted Answer

Using multiple worksheets can actually help you group your data as you can organize related data in different worksheets and then use formulas or functions to consolidate or summarize the information. It can make it easier to manage large amounts of data and avoid cluttering a single worksheet.

Quiz 6: Excel: Managing Multiple Worksheets and Workbooks