MS Excel 97 Lesson 5 Review

Please provide the following contact information:

Sorting has the potential to damage worksheets, so you should always save before sorting.

True False

The Sort Ascending button can only be used if you first select the desired rows.

True False

The Sort dialog box allows you to specify more than one sort key.

True False

The Window-->Freeze Panes command lets you view two sections of the worksheet at the same time.

True False

Freezing the panes makes it easier to identify data in large worksheets.

True False

You can select a range of cells by clicking the first cell in the range, then pressing & holding Ctrl while you click the last cell in the range.

True False

You can scroll one screen at a time by clicking an open part of the scroll bar.

True False

The Page Setup dialog box provides access to many features that are useful when printing large worksheets.

True False

You can set the margins in the Print Preview window.

True False

Headers and footers have three sections.

True False

1. Which of the following statements describes the columns and rows that are frozen when the Window-Freeze Panes command is issued?

   No answer a)Columns to the left of the highlight and rows above the highlight. b)Columns to the left of the highlight and rows below the highlight. c)Columns to the right of the highlight and rows below the highlight. d)Columns to the right of the highlight and rows above the highlight.
   

2. Which tab in the Page Setup dialog box lets you set the Landscape orientation?

   No answer a)Page b)Margins c)Header/Footer d)Sheet
   

3. Assuming the current page is 1, how will the header Page &[page] be printed?

   No answer a)Page l of 1 b)Page 1 of 2 c)Page 1 d)Page 1, Current Date
   

4. Which tab in the Page Setup dialog box contains an option that lets you repeat a Column on every page of a printout?

   No answer a)Page b)Margins Header/Footer d)c)Sheet
   

5. Which command is used to insert a manual page break?

   No answer a)Format-->Page Break b)Insert-->Page Break c)Alt + Enter d)None of the above.