Exam 98: Spreadsheet Graphics

A ____ sparkline is used to show positive and negative values.

____ charts are best used for showing individual data values as a percentage of the whole.

Charts can help readers catch trends in the data that can be missed by simply viewing numbers in columns and rows.

The Page Layout View button is located in the lower-____________________ corner of a spreadsheet window.

Removing gridlines by deselecting Gridlines in the ____________________ group on the Layout tab means that gridlines will not be printed.

To insert a page break,click the Layout tab,and in the Page Setup group,click the ____ button.

A chart wall is the area ____ the chart's columns.

When a spreadsheet cell is selected,the Format Picture tab is visible,meaning that you can access tools for formatting the picture.

Print ____________________ lets you adjust the height and width of a worksheet's contents to fit more data on a single page.

To select a range of cells upon which to base a chart,press and hold the ____ key as you drag through the cells.

A line sparkline shows a data trend over a period of time.

The pie chart is the best type of chart to select for most business uses.

An image from a PowerPoint presentation cannot be copied into an Excel spreadsheet.

To print only a portion of a spreadsheet,select the required range,click the File menu,point to Print Area,and then click Set Print Area.

To ensure that a title printing on page 1 appears on subsequent pages,click the Print Titles button in the Page Titles group.

You can use options on the ____ tab to add high and low markers to a sparkline.

Excel does not provide functionality to display a file's system path as part of its footer.

When selecting cells to include in a chart,a(n)____________________ should never be combined on the same chart with the data that comprises the total.

To insert a spreadsheet footer,click the View menu and then click the ____ option.

An image pasted into a spreadsheet cell can be formatted using tools found on the Format Picture tab.