AC161 Excel F

What opens when you click on the File tab on the Ribbon?

Backstage View

John wnats to freeze columns A, B, and C in his worksheet. In which column should he position the pointer before he initiates the Freeze Panes command?

D

Metadata is information that describes _____.

Data

Manual page breaks adjust automatically when you insert data into a worksheet

False

In the figure above, item number 1 identifies the _____. (line across the screen horizontally)

Horizontal split box

HTML is an acronym or _____.

Hypertext Markup Language

Which feature helps you specify access permissions toy our workbook files?

Information Rights Management

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

Instance

Which of the following is not a possible window arrangement in the Arrange Windows dialog box?

Layered

Sasha wants to use the thesaurus to find a synonym. Which tab should he click?

Review

A watermark will print behind worksheet data.

True

A workbook can be password protected

True

Dynamic page breaks adjust automatically when you insert or delete rows and columns or change column widths or row heights

True

In Excel, you can temporarily freeze columns and rows, which enables you to view separate areas of your worksheet at the same time.

True

Metadata is information that describes data.

True

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

True

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

True

The default file format for Excel 2010 files is the Office Open XML format.

True

To remove a worksheet split, double-click the split bar.

True

In the figure above, item number 2 identifies the ____. (line across the screen vertically)

Vertical split box

A set of display and/or print settings that you can name and save, then access at a later time, is called a ___.

View

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

View

The New Window button is located on the _______ tab.

View

To create a manual page break, use the Page Break Preview button on the ____ Tab.

View

You can view and change page breaks manually by using the Page Break Preview button on the ____ Tab.

View

The Freeze Panes button is located on the ____.

View Tab

To easily return from a hyperlinked target to the original document, you can add the ____ button to your Quick Access toolbar.

back

A worksheet ______ will display behind worksheet data on the screen, but it will not print behind the worksheet data.

background

If you want both horizontal and vertical page breaks, position the cell pointer ____ before setting the manual page break.

below and to the right of the intersection where you want the breaks to occur

Which of the following is not a resource option in to Resource pane?

chat web sites

An intranet is a ___.

company's internal Web site

To split a worksheet area into multiple panes, ___________.

drag the split box in the direction you want the split to appear.

A word or object in a worksheet that, when clicked, displays, or "jumps to," another location is called a ______.

hyperlink

A workspace has a(n) _____ extension.

.xlw

The Document Inspector feature finds hidden data in a worksheet

true

Which of the following statements about hiding and protecting worksheet areas in NOT true?

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

A worksheet background will print with the worksheet

False

Cells in the data entry area are generally locked

False

Excel allows you to split the worksheet area into horizontal panes only.

False

The columns and rows that freeze while you scroll through the worksheet are called _____.

Panes

To select and paste an area from an open window, use the ____ button in the Screenshot gallery.

Screen Clipping

To insert a screenshot into your Excel workbook, use which button in the Illustrations group of the Insert tab?

Screenshot

Which of the following statements about page breaks is NOT true?

There is only one way to set page breaks.

The default file formal for Excel 2010 files is the Office Open ____ format.

XML

Which of the following statements about headers and footers is true?

You can insert a picture into the header.

You can make an Excel file a(n) _____ workbook so that several users can open and modify it at the same time.

shared

If your worksheet contains macros, you need to save it in a file format that applies which file extension?

xlsm