Exam 19: Organizing and Enhancing Worksheets

A(n) ____ is the design of the typeface.

To change the angle of the text direction, click the ____________________ button.

You can use the Format Painter feature to copy formats.

By default, new blank workbooks include ____ worksheets.

When you ____________________ rows and columns, the data remains intact; it is just not visible on the screen.

When you sort data, you screen data that matches specified criteria; the data that does not meet the criteria is hidden.

You can easily change the print settings using commands in the ____.

The Freeze Panes button is on the View tab.

Cate has finished entering data and formatting her worksheet and is ready to print and share it with others. Cate wants to share her workbook electronically, but doesn't want the recipients to be able to modify the data. One of her options is to save it as a(n) ____ file.

A(n) ____________________ is information and/or graphics that are printed in the top margin of a worksheet.

Which of the following is NOT true about changing alignment?

Conditional formatting applies designated formats to cells when the cell value meets specified criteria.

When you ____ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.

Which of the following is NOT true about changing the page setup?

The default Zoom setting is 75%.

To remove a split in a worksheet, double-click the dividing line.