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