Question 1

A ____ will print behind worksheet data.
A) background
B) keyword
C) watermark
D) digital signature

Accepted Answer

A watermark is a faint image or text that appears behind the main text of a document. It is often used for branding or to indicate the document's status (e.g. draft or confidential). Watermarks can be added to printed documents, as well as digital ones.

Question 2

Cells that are protected so that their contents cannot be altered are called ____________________ cells.

Accepted Answer

The answer of Cells that are protected so that their...

Question 3

Which of the following cannot be a hyperlink in Excel?
A) filename
B) word
C) graphic
D) title bar

Accepted Answer

The title bar cannot be turned into a hyperlink in Excel.

Question 4

You can split an Excel worksheet into multiple ____________________ using the Split button in the Window group on the View tab.

Accepted Answer

The answer of You can split an Excel worksheet into...

Question 5

To hold headers in place as you scroll through a worksheet, _____ the panes.​
A)hide
B)bookmark
C)split
D)freeze

Accepted Answer

The answer of To hold headers in place as you...

Question 6

Metadata is information that describes ____.
A) keywords
B) hyperlinks
C) workspaces
D) data

Accepted Answer

The answer of Metadata is information that describes ____.
A) keywords
B)...

Question 7

The hyperlink button is in the ____ group on the Insert tab.
A) Data
B) Links
C) Interactive
D) Web

Accepted Answer

The answer of The hyperlink button is in the ____...

Question 8

____ help users locate, identify and understand a file.
A) Targets
B) Properties
C) Names
D) Hyperlinks

Accepted Answer

The answer of ____ help users locate, identify and understand...

Question 9

Which of the following cannot be a target?
A) Web site home page
B) hyperlink
C) Word document
D) Excel worksheet

Accepted Answer

The answer of Which of the following cannot be a...

Question 10

What appears in the title bar when you mark a workbook as final?
A) [Compatibility Mode]
B) [Final]
C) [Read-Only]
D) [Enable Content]

Accepted Answer

The answer of What appears in the title bar when...

Question 11

When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.​
A)Reverse Final
B)Edit Anyway
C)Review
D)Update

Accepted Answer

The answer of When a workbook is marked as final,...

Question 12

The color of a hyperlink depends on the worksheet ____ colors.
A) theme
B) background
C) watermark
D) font

Accepted Answer

The answer of The color of a hyperlink depends on...

Question 13

A worksheet displayed in its own workbook window is called a(n) ____________________.

Accepted Answer

The answer of A worksheet displayed in its own workbook...

Question 14

To ensure that a workbook displays the same way on different computers, publish it in _____ format.
A)pdf
B)ods
C)xps
D)xltm

Accepted Answer

The answer of To ensure that a workbook displays the...

Question 15

To view the Document Inspector dialog box, click the Check for Issues button, and then click ____.
A) Check Document
B) Document Info
C) Inspect Document
D) Protect Document

Accepted Answer

The answer of To view the Document Inspector dialog box,...

Question 16

The ____________________ Scrolling button allows you to scroll through arranged worksheets simultaneously.

Accepted Answer

The answer of The ____________________ Scrolling button allows you to...

Question 17

Which of the following can users search for to help them locate a workbook?
A) groups
B) folder names
C) keywords
D) links

Accepted Answer

The answer of Which of the following can users search...

Question 18

Which button do you click to add information about a hyperlink?
A) ScreenTip
B) Caption
C) Info
D) Insert

Accepted Answer

The answer of Which button do you click to add...

Question 19

The area or range of cells whose data is allowed to change is known as the ____________________ entry area.

Accepted Answer

The answer of The area or range of cells whose...

Question 20

A hyperlink jumps to a ____.
A) target
B) server
C) source
D) publisher

Accepted Answer

The answer of A hyperlink jumps to a ____.
A) target
B)...

Quiz 6: Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

A ____ will print behind worksheet data.

Cells that are protected so that their contents cannot be altered are called ____________________ cells.

Which of the following cannot be a hyperlink in Excel?

You can split an Excel worksheet into multiple ____________________ using the Split button in the Window group on the View tab.

To hold headers in place as you scroll through a worksheet, _____ the panes.​

Metadata is information that describes ____.

The hyperlink button is in the ____ group on the Insert tab.

____ help users locate, identify and understand a file.

Which of the following cannot be a target?

What appears in the title bar when you mark a workbook as final?

When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.​

The color of a hyperlink depends on the worksheet ____ colors.

A worksheet displayed in its own workbook window is called a(n) ____________________.

To ensure that a workbook displays the same way on different computers, publish it in _____ format.

To view the Document Inspector dialog box, click the Check for Issues button, and then click ____.

The ____________________ Scrolling button allows you to scroll through arranged worksheets simultaneously.

Which of the following can users search for to help them locate a workbook?

Which button do you click to add information about a hyperlink?

The area or range of cells whose data is allowed to change is known as the ____________________ entry area.

A hyperlink jumps to a ____.

To hold headers in place as you scroll through a worksheet, _____ the panes.

When a workbook is marked as final, a yellow bar appears below the tabs with a(n) _____ button.