Question 1

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

Accepted Answer

When using the point-and-click method to build formulas with external references, Excel does enter all of the required punctuation and quotation marks.

Question 2

Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget, Inventory List, and Time sheets.

Accepted Answer

False

Question 3

When the source and destination workbooks are stored in the same folder, you still need to include the location information in the workbook reference that links the two files.

Accepted Answer

If the source and destination workbooks are stored in the same folder, you don't need to include the location information. You only need to include the filename in the reference.

Question 4

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

Accepted Answer

When all worksheets are grouped, any changes made in one worksheet will be reflected in all other worksheets in the group. Therefore, only the active worksheet should be edited to avoid unintended changes in other worksheets.

Question 5

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

Accepted Answer

This is true. When worksheets are grouped, they are considered as a single entity and changes made to one sheet will be applied to all sheets in the group.

Question 6

Hyperlinks are usually represented by words with colored letters and underlines or images.

Accepted Answer

Hyperlinks can be represented by words with colored letters and underlines or images.

Question 7

In the figure above, cell A8 contains a hyperlink .

Accepted Answer

The figure is not provided for reference, but if it is assumed that cell A8 contains a hyperlink, then the answer would be A.

Question 8

To delete a hyperlink, right-click the hyperlink cell and then click Clear Value .

Accepted Answer

The answer of To delete a hyperlink, right-click the hyperlink...

Question 9

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 10

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

Accepted Answer

Using multiple worksheets actually makes it easier to group your data as you can easily sort and filter each worksheet separately before consolidating them.

Question 11

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

Accepted Answer

This statement is true, to select non-adjacent worksheets you need to hold down the Ctrl key and click on the sheet tabs of each worksheet you want to include in the selection.

Question 12

When you create a new workbook from a template, an unnamed copy of the template opens.

Accepted Answer

When you create a new workbook from a template, an unnamed copy of the template opens.

Question 13

A(n) asterisk separates the worksheet reference from the cell or range reference.

Accepted Answer

The answer of  
A(n) asterisk separates the worksheet reference...

Question 14

Excel, by default, looks for template files in the Templates folder, which is where custom template files are often stored.

Accepted Answer

Excel does look for template files in the Templates folder by default, along with other default locations such as the XLSTART folder. Custom templates are often stored in the Templates folder.

Question 15

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

Accepted Answer

Using 3-D references allows you to reference the same cell or range of cells across multiple worksheets, which can be used for summarizing data in another worksheet.

Question 16

All template files have the .xlts file extension.

Accepted Answer

Template files in Excel have the .xltx file extension. The .xlts extension is used for Excel template files that contain macros.

Question 17

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

When a change is made in the source file and the destination file is closed, the user is given the option to update the link to display the current values when the destination file is opened or continue to display the older values.

Question 18

If you delete a value from one cell in a worksheet group, the content is also deleted from the same cell in all the worksheets in the group.

Accepted Answer

When cells are grouped, any changes made to one cell in the group will affect all cells in that group, including deleting the content.

Question 19

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

Accepted Answer

The answer of A workbook based on a specific template...

Question 20

A(n) template is a workbook with labels, formats, and formulas already built into it with data removed.

Accepted Answer

A template is a predesigned workbook with labels, formats, and formulas already included, but with the data removed so that it can be customized for a specific purpose.

Quiz 6: Excell: Managing Multiple Worksheets and Workbooks

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

Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget, Inventory List, and Time sheets.

When the source and destination workbooks are stored in the same folder, you still need to include the location information in the workbook reference that links the two files.

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

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

Hyperlinks are usually represented by words with colored letters and underlines or images.

In the figure above, cell A8 contains a hyperlink .

To delete a hyperlink, right-click the hyperlink cell and then click Clear Value .

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

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

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

When you create a new workbook from a template, an unnamed copy of the template opens.

A(n) asterisk separates the worksheet reference from the cell or range reference.

Excel, by default, looks for template files in the Templates folder, which is where custom template files are often stored.

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

All template files have the .xlts file extension.

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.

If you delete a value from one cell in a worksheet group, the content is also deleted from the same cell in all the worksheets in the group.

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

A(n) template is a workbook with labels, formats, and formulas already built into it with data removed.