Exam 14: Finalizing a Worksheet

The ____________________ button allows you to clear the print area setting so that the entire worksheet prints.

If you want headings displayed and printed, make sure there are checkmark(s) in _____.

You can use the FILE tab's Share option to save a worksheet in Excel format to Microsoft's Internet-based _____ and allow others to view it.

When sorting data click a cell in the column after you click the desired sort button.

In Page layout view, gridlines are shown in _____.

Referring to the accompanying figure, which callout points to the control that allows you to preview each page?

If you are sure the word is spelled correctly and appears multiple times in your worksheet, click the _____ button if you want to ignore all occurrences of this word throughout the entire worksheet.

To print multiple copies of the current worksheet use the FILE tab's Print option.

In the accompanying figure, which callout points to the area you should click in the worksheet to exit Header/Footer mode?

To get a good view of an entire worksheet before you change margins, you might want to reduce the zoom level to less than _____.

If no suggested spellings are displayed, click the ____________________ text box, then type the correct word.

Which of the following words may not be recognized by Excel?

Which of the following buttons should you click to specify label titles that should be repeated on every page?

Specify page numbers on the right side of even numbered pages.

You might want to insert a manual ____________________ if a page ends with a row that should be grouped with data on the next page.

You can hide rows or columns of data in a worksheet if the data they contain is confidential.

Excel's ____________________ view helps you refine the appearance of a worksheet before you print it.

Worksheet labels are the column letters and row numbers.

Case-Based Critical Thinking Questions Case 14-1 Max wants to save a worksheet as a Web page. What should he do? In the Save As dialog box, Max should save his Excel file as a(n) _____ file type.

To check the spelling of worksheet labels, click the Spelling button in the _____ group on the REVIEW tab.