Excel Unit F
Marian wants to freeze the labels on rows 1-5, in which row does she need to position the pointer?
6
John wants to freeze columns A, B and C in his worksheet. In which column should he position the pointer?
D
Metadata is information that describes
Data
To split a worksheet area into multiple panes
Drag the split box in the direction you want the split to appear.
Manual page breaks adjust automatically when you insert data into a worksheet
False
To remove a worksheet split, move the mouse over the split and click and drag it off the screen
False
The hyperlink button is on the
Insert Tab
A worksheet is displayed in its own window is called a
Instance
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
The Synchronous Scrolling button allows you to scroll through arranged worksheets simultaneously.
True
The cell lock option does not take effect until the protection feature is activated
True
The default file format for Excel 2007 files is the Office Open XML format
True
You can digitally sign a workbook to validate it.
True
A set of display and/or print setting that you can name and save, then access at a later time is called a
View
The Freeze Panes button is located on the
View Tab
The new window button is located on the
View Tab
You can view and change page breaks manually by using the Page Break Preview button on the
View Tab
A _____________ will print behind worksheet data
Watermark
If you want both horizontal and vertical page breaks, position the cell pointer
below and to the right of the gridline where you want the breaks to occur
An intranet is a
company's internal Web site
To remove a split in a worksheet, move the mouse over the split, then
double-click
Statement about hiding and protecting a worksheet areas is NOT true
Cells that are protected so that their contents cannot be altered are called hidden cells.
Cells in the data entry area are generally locked
False
The arrange Windows dialog box allows you to choose from ___________________ different configurations
Four
To create a manual page break, use the Breaks button on the
Page Layout tab
Which of the following statements about page breaks is NOT true
Page breaks are indicated by solid vertical and horizontal lines
The columns and rows that freeze while you scroll through your worksheet are called
Panes
True statement about headers and footers
You can insert a picture into a header
If your worksheet contains macros you need to save it with an extension of
xlsm
