Question 1

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

Accepted Answer

All of the other options (Family Budget, Inventory List, and Team Roster) are task-specific templates that are available on the Microsoft Office Online Web site.

Question 2

Ryder has discovered the power of creating and viewing multiple workbooks.
-When Ryder goes to save the workbooks,what is the required file extension?

Accepted Answer

The required file extension for Excel workbooks is .xlsx, which is the file format used for Excel files created in Excel 2007 and newer versions. The other options (wxls, xlww, xlwx) are not valid file extensions for Excel workbooks.

Question 3

All template files have a(n)____ extension.

Accepted Answer

According to Microsoft Excel, all template files have the .xltx file extension. Therefore, the correct answer is B.

Question 4

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
-Jared has heard that ScreenTips can be used in conjunction with hyperlinks.Which of the following statements about ScreenTips is correct?

Accepted Answer

ScreenTips are small pop-up boxes that appear when you hover the mouse pointer over a hyperlink. You can customize the contents of a ScreenTip by specifying the text you want to appear in the ScreenTip when you create a hyperlink. Option A is incorrect because ScreenTips only appear when you hover over a hyperlink, not any cell. Option C is incorrect because the default ScreenTip for a hyperlink is the address or location of the URL linked to the cell, not "Active Hyperlink." Option D is incorrect because you cannot change the contents of an existing ScreenTip by simply changing the value in the cell. You would need to recreate the hyperlink to change the ScreenTip.

Question 5

-Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.

Accepted Answer

The "Break Link" button is used to replace the link to a source file with the current values for the linked cells, effectively converting the linked data into static values.

Question 6

The default template contains the default formatting you start out with in every new workbook,including ____ 11-point font.

Accepted Answer

The default template in Excel contains Calibri 11-point font as the default formatting.

Question 7

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help.
-Simon tells Brooke that when he attempts to open a workbook,the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message.Which of the following is a possible cause?

Accepted Answer

The answer of Simon is having trouble using linked workbooks,...

Question 8

The default template places the formula results aligned to the ____ of a cell.

Accepted Answer

In spreadsheet applications like Microsoft Excel, the default alignment for numbers and formula results is to the right side of the cell.

Question 9

Ryder has discovered the power of creating and viewing multiple workbooks.
-Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible.Ryder opens all of the workbooks,and then he clicks the VIEW tab on the Ribbon and clicks the Arrange All button.What should he do next to obtain the desired layout?

Accepted Answer

The Cascade option arranges the workbooks so that they overlap with all title bars visible, allowing easy access to each workbook.

Question 10

-Click the button marked ____ in the accompanying figure to fix broken links.

Accepted Answer

The "Change Source" button is typically used to fix broken links by allowing you to select a new source file for the linked data.

Question 11

The ____ template in Excel creates an online time card to track employees' work hours.

Accepted Answer

The Time Sheet template in Excel is specifically designed to track employees' work hours, making it the best choice for this scenario. The Payroll template may include time tracking features, but it is a more comprehensive tool for managing payroll and may not be necessary in this case. The Personnel Statement and Employment Calculator templates are not relevant to tracking work hours.

Question 12

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help.
-Finally,Simon asks Brooke what steps (if any)need to be taken to keep a destination file up-to-date if he updates a value in one of the source files.Which of the following statements by Brooke would be correct?

Accepted Answer

If a destination file is open when a source file is changed, the destination file will be updated automatically. This is because the destination file is linked to the source file, and any changes made in the source file will automatically update in the destination file, as long as the destination file is open.

Question 13

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help.
-After Brook has helped Simon to resolve his original problem,Simon asks her about another linked workbook he has received.The source files for this workbook have not been included,but Simon would like to use the workbook with the most recent values from the source files.What should Brooke tell him?

Accepted Answer

He can open the workbook and click the Continue button in the Edit Links dialog box.

Question 14

A ____ is a workbook that you can open with the text,formats,and formulas already built into it.

Accepted Answer

A template is a pre-designed workbook that contains pre-built text, formats, and formulas. It can be used as a starting point for creating new workbooks with similar content or design. The other options (boiler, summary sheet, range master) are not related to the concept of a pre-built workbook template.

Question 15

Ryder has discovered the power of creating and viewing multiple workbooks.
-Ryder wants to use the workbooks he has created on another computer.What steps does he need to take?

Accepted Answer

To ensure that all the data and formatting is retained, Ryder needs to copy both the workbook file and the individual worksheets to the other computer. This way, he would be able to view and work on the entire workbook with all the necessary worksheets.

Question 16

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
-Jared wants to create a hyperlink to a location in his current workbook.He clicks the Hyperlink button in the Links group on the INSERT tab.What option should he select from the Link to list?

Accepted Answer

If Jared wants to create a hyperlink to a location within his current workbook file, he should select "Place in This Document" from the Link to list. This will allow him to select a specific cell or range of cells within the current workbook to link to.

Question 17

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
-Jared wants to create a hyperlink to link to new a document.What should he click in the Link to list?

Accepted Answer

To create a hyperlink to a new document, Jared should click on "Create New Document" in the Link to list. This will allow him to create a new Word or Excel document and link it directly from the current workbook.

Question 18

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.
-Which of the following statements about hyperlinks in Excel workbooks is correct?

Accepted Answer

Hyperlinks in Excel workbooks can be used to jump to a specific cell or range within the active worksheet, another worksheet, or another workbook. Option A describes the general appearance of hyperlinks, but it is not a statement about their functionality. Option C is incorrect because hyperlinks can be used to jump to other files or URLs. Option D is incorrect because clicking on white space within the cell will not activate the hyperlink.

Question 19

The default ____ for a hyperlink is the folder location and the name of the file to which you will link.

Accepted Answer

The ScreenTip is the default text that appears when you hover over a hyperlink, and it typically displays the folder location and file name of the linked page. The title, alt text, and description are all optional attributes that can be added to provide additional information about the hyperlink, but they are not part of the default settings.

Question 20

To delete the hyperlink but keep the text,right-click the hyperlink cell,and then click ____ Hyperlink.

Accepted Answer

"Remove" is the most appropriate choice as it is commonly used to indicate the action of getting rid of something. Deleting or erasing may also work, but "remove" specifically refers to removing the hyperlink while leaving the text intact. "Archive" does not make sense in this context as it usually refers to storing data for future reference.

Quiz 6: Managing Multiple Worksheets and Workbooks

Which of the following is NOT a task-specific template available from the Microsoft Office Online Web site?

Ryder has discovered the power of creating and viewing multiple workbooks. -When Ryder goes to save the workbooks,what is the required file extension?

All template files have a(n) ____ extension.

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared has heard that ScreenTips can be used in conjunction with hyperlinks.Which of the following statements about ScreenTips is correct?

-Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.

The default template contains the default formatting you start out with in every new workbook,including ____ 11-point font.

The default template places the formula results aligned to the ____ of a cell.

-Click the button marked ____ in the accompanying figure to fix broken links.

The ____ template in Excel creates an online time card to track employees' work hours.

A ____ is a workbook that you can open with the text,formats,and formulas already built into it.

Ryder has discovered the power of creating and viewing multiple workbooks. -Ryder wants to use the workbooks he has created on another computer.What steps does he need to take?

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared wants to create a hyperlink to a location in his current workbook.He clicks the Hyperlink button in the Links group on the INSERT tab.What option should he select from the Link to list?

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Jared wants to create a hyperlink to link to new a document.What should he click in the Link to list?

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. -Which of the following statements about hyperlinks in Excel workbooks is correct?

The default ____ for a hyperlink is the folder location and the name of the file to which you will link.

To delete the hyperlink but keep the text,right-click the hyperlink cell,and then click ____ Hyperlink.