Exam 14: Finalizing a Worksheet

You can adjust column widths while in _____ view.

In the accompanying figure, which callout points to the area you should click first when adding a header or footer?

____________________ is a data management feature that allows you to focus on a subset of the data in a worksheet.

Referring to the accompanying figure, which callout points to the button that starts printing?

Case-Based Critical Thinking Questions Case 14-1 Max wants to save a worksheet as a Web page. What should he do? Part of Max's worksheet contains formatting that cannot be duplicated in a Web page. He is notified of the problem areas and is given the option of _____.

Excel provides tools that allow you to sort data in ascending order only.

You can output Excel worksheets as PDF files using the _____ option on the FILE tab.

Use the _____ option to filter data based on the beginning or ending characters of the text contained in a row or column of cells.

You can test your worksheet by entering a set of ____________________ values for which you already know the results.

Which of the following buttons is used to insert manual page breaks?

Which of the following is the Margins button?

If the correct spelling appears in the Suggestions list, click to select it, then click the Replace button to correct the misspelled word.

You can use options on the ribbon to customize which elements of a worksheet will print.

To add a flagged word to the spelling dictionary, click the Add to Dictionary button.

Use the Zoom control to see the entire page.

Like Word's spelling checker, Excel provides a grammar checker.

The Options button offers several useful settings for headers and footers. List some suggestions on how to use them.

If the correct spelling appears in the _____ list, click to select it.

You should select _____ margins if you want to control the space allocated for headers and footers.

Which of the following buttons is used to specify additional sort levels?