Exam 14: Finalizing a Worksheet

You can use the Charts group on the Page Layout tab to chart or graph data in your worksheet._________________________

In the Clip Art task pane, enter a keyword for the type of clip art you would like to use in the ____ text box, then click Go.Choose an image from the available pictures, then close the Clip Art task pane.

When a chart is selected, you can move it or resize it by dragging the sizing handles._________________________

If your worksheet contains multiple pages, the margin settings apply to ____.

To print only the current worksheet, select the Print ____ option instead of the Print Entire Workbook option.

In general, most modifications begin by right-clicking the chart element you want to change.

The ____ tools allow you to draw simple lines and shapes.

Data sorted in ascending order will be arranged in reverse alphabetical order-labels that start with Z will be positioned above those that start with Y._________________________

Excel can check the spelling of all labels in a worksheet and shows misspelled words with wavy red underlines.

To insert clip art, click the cell where you wish to place the graphic.Click the ____ tab, then click Clip Art in the Illustrations group.

Excel creates a chart based on the data and labels you select from a worksheet._________________________

Case 14-1 Juliet wants to save a worksheet as a Web page. Please answer the questions below. -To make sure that her worksheet will convert successfully to a Web page, Juliet previews her worksheet in ____ prior to posting the file.

If you are not certain which chart type to use, hover the pointer over any of the chart buttons to display a description and usage recommendation.

To get a good view of the entire worksheet before you change margins, you might want to reduce the zoom level to ____ 100%.

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

Orientation refers to the relative positions of the worksheet and the ____.

Before printing a multipage worksheet, use ____ view to preview the information that each page will contain.

A(n) ____________________ chart (sometimes called a column chart) is used to show comparisons.

You can add graphics to your Excel worksheet.Please describe the Shapes tools and how you would go about drawing an arrow.Please also describe the Smart Art button and how you would insert SmartArt into your worksheet.

-Referring to the figure above, to insert the money clip art you would click the ____ tab.