Question 1

Which of the following items does the Document Inspector check for sensitive information?
A) Formulas
B) Tables
C) Cell Styles
D) Document properties

Accepted Answer

The Document Inspector checks for sensitive information in document properties such as author name, company name, and other metadata. It does not check formulas, tables, or cell styles.

Question 2

A(n) _____ is a set of display or print settings that you can name and save, and then access later.
A) pane
B) window
C) view
D) outline

Accepted Answer

A view is a set of display or print settings that you can name and save, and access later. Panes and windows refer to sections of a user interface, while an outline refers to a hierarchical structure of headings and subheadings.

Question 3

When you group worksheet data, you can use the Hide Outline button to hide details in grouped columns or rows.

Accepted Answer

- Collapse
 - collapse
 - COLLAPSE

Question 4

Calista wants to provide additional information about a hyperlink she is creating.Which of the following can she do?
A) Add a description.
B) Add a ScreenTip.
C) Change the Link to location.
D) Add a HyperTip.

Accepted Answer

Adding a ScreenTip to a hyperlink allows the author to provide additional information about the link, which is displayed when the user hovers over the hyperlink. This feature is commonly used in various software applications, including web browsers and Microsoft Office products, to enhance usability and provide context.

Question 5

In one workbook, Tim wants to include a link to another workbook.Which of the following dialog boxes should he use to add the link?
A) Style dialog box
B) Insert Text dialog box
C) ScreenTip Text box
D) Insert Hyperlink dialog box

Accepted Answer

The Insert Hyperlink dialog box allows the user to link to an external workbook or file. The other dialog boxes listed do not have this capability.

Question 6

Alba wants to display a picture as the worksheet background.Which of the following buttons on the Page Layout tab should she use?
A) Breaks
B) Margins
C) Orientation
D) Background

Accepted Answer

Alba should use the "Background" button on the Page Layout tab to insert a picture as the worksheet background.

Question 7

When you click the View Side by Side button, you activate the Synchronous Scrolling button so you can scroll both worksheets at the same time.

Accepted Answer

When you click on the View Side by Side button, the Synchronous Scrolling button gets activated automatically so you can scroll through both worksheets simultaneously.

Question 8

A(n) _____ is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage.
A) Bookmark
B) ScreenTip
C) Address
D) Hyperlink

Accepted Answer

A hyperlink is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage. Bookmarks are used to save a webpage's address for future reference. Screentips are small windows that display descriptive text when you hover your mouse over something. An address is the specific location of a webpage on the internet.

Question 9

Which of the following can be the target of a hyperlink in Excel?
A) New blank workbook
B) Worksheet in the current workbook
C) Print setting in the current workbook,
D) New worksheet in the current workbook

Accepted Answer

A hyperlink in Excel can link to a specific worksheet within the current workbook.

Question 10

Jim wants to print sections of the various worksheets.The most efficient way for him to do so is to print one worksheet at a time.

Accepted Answer

Jim can select multiple sections across different worksheets by holding down the Ctrl key while selecting the areas he wants to print, and then print them all at once, making it more efficient than printing one worksheet at a time.

Question 11

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013.To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Accepted Answer

Clicking on "File > Info > Check for Issues > Check Compatibility > OK" will allow Darnell to verify whether the workbook he created is compatible with Excel 2007, 2010, or 2013.

Question 12

Rukha has created two custom views of a worksheet.In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?
A) Click Custom Views and double-click on the display settings she wants to see.
B) Under Windows group on the View tab, click on View Side by Side.
C) Under Windows group on the View tab, click on Switch Windows and select the View she wants.
D) Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden.

Accepted Answer

To switch between different custom views that Rukha has created, she needs to click on Custom Views and then double-click on the display settings she wants to see. This action will allow her to toggle between the view where all rows and columns are visible and the view where specific rows and columns are hidden.

Question 13

When you group data to create a(n) custom view, you can create groups of columns or rows.

Accepted Answer

- outline
 - Outline
 - OUTLINE

Question 14

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time.Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?
A) Reset Window Position
B) Synchronous Scrolling
C) Arrange All
D) Zoom to Selection

Accepted Answer

Synchronous Scrolling will allow Al to scroll through both worksheets at the same time, making it easier to compare data.

Question 15

Miguel wants to remove the outline from a worksheet containing grouped data.What does he need to do?
A) Use the Auto Outline tool.
B) Clear the outline.
C) Collapse the outline.
D) Hide the outline symbols.

Accepted Answer

To remove the outline from a worksheet containing grouped data, Miguel needs to clear the outline. This can be done by going to the "Data" tab, clicking on "Group" under the "Outline" section, and selecting "Clear Outline".

Question 16

Amelia wants to insert a hyperlink to an e-mail address.Which part of the Insert Hyperlink dialog box should she use to indicate she wants to insert an email hyperlink?
A) Link to list
B) Text to display box
C) Look in box
D) Target list

Accepted Answer

The "Link to list" in the Insert Hyperlink dialog box is where you can choose different types of links, including an email hyperlink, by selecting an option like "E-mail Address."

Question 17

When you right-click a cell containing a hyperlink, which of the following commands should you select to remove cell contents along with the hyperlink?
A) Remove Hyperlink
B) Clear Contents
C) Edit Hyperlink
D) Clear Formats

Accepted Answer

Selecting "Clear Contents" will remove the cell contents as well as the hyperlink, while "Remove Hyperlink" only removes the hyperlink itself without affecting the cell contents. "Edit Hyperlink" allows you to modify the hyperlink URL or display text, and "Clear Formats" only removes any formatting applied to the cell.

Question 18

In cell A5, Jiang inserted a hyperlink to a webpage, but now does not want to link to the webpage when she clicks the cell.How should she make this change in cell A5?
A) Right-click the cell, then click Clear Contents on the shortcut menu.
B) Click the cell, then click the Clear button in the Editing group.
C) Click the cell, then click the Underline button in the Font group.
D) Right-click the cell, then click Remove Hyperlink on the shortcut menu.

Accepted Answer

To remove the hyperlink, Jiang should right-click the cell and select "Remove Hyperlink" from the shortcut menu.

Question 19

You can use the Auto Outline feature to group worksheet data into an outline.

Accepted Answer

The Auto Outline feature can be used to group worksheet data into an outline based on specified criteria, making it easier to analyze and summarize the data.

Question 20

Lilia wants to save a workbook as a read-only file.She should encrypt the workbook with a password.

Accepted Answer

To save a workbook as read-only, Lilia should use the "Save As" option and then choose "General Options" to set the workbook as read-only, rather than encrypting it with a password. Encrypting with a password would require users to enter the password to open the workbook, not just to save changes to it.

Quiz 7: Excel

Which of the following items does the Document Inspector check for sensitive information?

A(n) _____ is a set of display or print settings that you can name and save, and then access later.

When you group worksheet data, you can use the Hide Outline button to hide details in grouped columns or rows.

Calista wants to provide additional information about a hyperlink she is creating.Which of the following can she do?

In one workbook, Tim wants to include a link to another workbook.Which of the following dialog boxes should he use to add the link?

Alba wants to display a picture as the worksheet background.Which of the following buttons on the Page Layout tab should she use?

When you click the View Side by Side button, you activate the Synchronous Scrolling button so you can scroll both worksheets at the same time.

A(n) _____ is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage.

Which of the following can be the target of a hyperlink in Excel?

Jim wants to print sections of the various worksheets.The most efficient way for him to do so is to print one worksheet at a time.

Darnell wants to verify whether a workbook he created is compatible with Excel 2007 2010, or 2013.To do so, he can click File > Info > Check for Issues > Check Compatibility > OK.

Rukha has created two custom views of a worksheet.In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

When you group data to create a(n) custom view, you can create groups of columns or rows.

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time.Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Miguel wants to remove the outline from a worksheet containing grouped data.What does he need to do?

Amelia wants to insert a hyperlink to an e-mail address.Which part of the Insert Hyperlink dialog box should she use to indicate she wants to insert an email hyperlink?

When you right-click a cell containing a hyperlink, which of the following commands should you select to remove cell contents along with the hyperlink?

In cell A5, Jiang inserted a hyperlink to a webpage, but now does not want to link to the webpage when she clicks the cell.How should she make this change in cell A5?

You can use the Auto Outline feature to group worksheet data into an outline.

Lilia wants to save a workbook as a read-only file.She should encrypt the workbook with a password.