Excel Unit F

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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


संबंधित स्टडी सेट्स

Women Gender and Politics chap 1-3

View Set

Business Communications Exam 3 (Chapters 7,9,10,11)

View Set

FIN410 Chapter 5 The Foreign Exchange Market

View Set

Richard II - Hi Q - General Trivia

View Set

CHAPTER 9: RHEOTICAL CRISTICSM : HOW TO INTERPRET PERSUASIVE TEXTS AND ARTIFACTS.

View Set