Question 1

To inspect a document for issues, you first click the Protect Workbook button in the Inspect Workbook area.

Accepted Answer

To inspect a document for issues, you first click the 'Inspect Document' or 'Check for Issues' button in the Info menu, not the 'Protect Workbook' button. The 'Protect Workbook' button is used for securing the workbook, not inspecting it.

Question 2

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

Accepted Answer

The Synchronous Scrolling button does allow you to scroll through arranged worksheets simultaneously.

Question 3

To open two instances of one Excel workbook, you need to open it twice from its original location.

Accepted Answer

To open two instances of one Excel workbook, you can right-click the Excel icon in the taskbar and select "Microsoft Excel" instead of the workbook name. Then open the same workbook from its original location in the second instance.

Question 4

A picture added to the worksheet background will show on screen and will also print.

Accepted Answer

A picture added as a worksheet background in Excel will show on the screen but will not print. Background images are meant for on-screen viewing only.

Question 5

To open two instances of one Excel workbook, you open the file and then create a new window using the New Window button in the Window group.

Accepted Answer

This is the correct method to open two instances of one Excel workbook.

Question 6

When you create custom views, you name the view first and then set the worksheet display.

Accepted Answer

The answer of When you create custom views, you name...

Question 7

A(n) ____________________ is usually used to show trends, patterns, and relationships.

Accepted Answer

The answer of A(n) ____________________ is usually used to show...

Question 8

A drawing ____________________ is a workspace for creating your own graphics.​

Accepted Answer

The answer of A drawing ____________________ is a workspace for...

Question 9

To show and hide custom views, you click the Add View button in the Custom Views dialog box.

Accepted Answer

The answer of To show and hide custom views, you...

Question 10

In order to see who has permission to open, copy, or change your workbook, click the File tab and review the information area.

Accepted Answer

The answer of In order to see who has permission...

Question 11

When you protect a worksheet, unlocked areas can still be changed.

Accepted Answer

The answer of When you protect a worksheet, unlocked areas...

Question 12

The area in which data in cells may be changed is sometimes called the data entry area.

Accepted Answer

The answer of The area in which data in cells...

Question 13

A watermark will print behind worksheet data.

Accepted Answer

The answer of A watermark will print behind worksheet data....

Question 14

The cell lock option does not change the way a user interacts with a worksheet until the protection feature is activated.

Accepted Answer

The answer of The cell lock option does not change...

Question 15

The Excel Custom Views feature allows you to create several views of a worksheet without having to create separate sheets.

Accepted Answer

The answer of The Excel Custom Views feature allows you...

Question 16

In Word, callouts and block arrows are considered ____.
A) chart objects
B) text boxes
C) shapes
D) WordArt

Accepted Answer

The answer of In Word, callouts and block arrows are...

Question 17

Cells in the data entry area are generally locked.

Accepted Answer

The answer of Cells in the data entry area are...

Question 18

The Hide and Unhide buttons in the Window group are used for hiding individual worksheet cells.

Accepted Answer

The answer of The Hide and Unhide buttons in the...

Question 19

The _____ command in the Adjust group allows you to make a photo look like a painting.​
A) Modify
B)Color
C)Blur
D)Artistic Effects

Accepted Answer

The answer of The _____ command in the Adjust group...

Question 20

A(n) ____________________ is a visual representation of numeric data.

Accepted Answer

The answer of A(n) ____________________ is a visual representation of...

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