Exam 14: Finalizing a Worksheet

You can select a specific area of a worksheet to print.When you use the Print ____ button to select such an area, the setting is used every time you print.

Use the File tab's Print option to____.

If you need to perform a multilevel sort, add additional levels with the Add Level button and designate the columns from the ____ list.

Data sorted in ____________________ order will be arranged in alphabetical order-labels that start with A will be positioned above those that start with B.

You can use Excel to create a table for use on a Web page.In the Save As dialog box, click the Selection option, choose the ____ file type, name your file, and click Save.

You might consider if you would like to include row and column ____ on every page to help readers identify the data presented after page 1.

Excel's ___________________ view helps you refine the appearance of a worksheet before you print it or post it as a Web page.

Label formats on charts can be different from those in the worksheet cells.

If you would like to shrink headers and footers when you use the Shrink to fit option, you would choose the following header and footer option: ____.

-In the figure above, the colored bars represent a ____.

A ____ is text that appears at the bottom of every page.

By default, the chart is inserted into the current worksheet.You can move the chart with the Move Chart button on the ____ tab.

If you would like to specify page numbers on the left side of even numbered pages, but on the right side of odd numbered pages, you would choose the following header and footer option: ____.

Case 14-1 Juliet wants to save a worksheet as a Web page. Please answer the questions below. -Part of Juliet's worksheet contains formatting that isn't available in HTML.She is notified of the problem areas and is given the option of ____.

Excel includes predefined ____ that contain information such as the title of the worksheet, the date, and the page number.

To insert SmartArt, click the Insert SmartArt Graphic button on the ___________________ tab, select the shape you want to insert, and then click the OK button.

The round, green handle that appears at the top of a graphic allows you to ____________________ the graphic.

To select a different range of cells to be charted, click the ____ button from the Design tab.

To specify the order in which pages of a multipage worksheet are printed, use the ____ tab of the Page Setup dialog box.

Excel provides several ways to access margin settings, but one of the easiest ways is to drag directly in the margins while in ____ view.