Exam 51: Spreadsheet Graphics

When viewing a workbook's orientation options,the two available choices are ____.

To ensure that column F does not print on its own page,on the PAGE LAYOUT tab,in the Scale to Fit group,click to set the column width to Automatic.

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

____ charts are best used for showing what percentage of a selected data series a particular item represents.

The first step in creating an Excel chart is to ____.

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

Tools used to add a chart to a spreadsheet are located on the ____ tab,in the Charts group.

When an empty spreadsheet cell is selected,the PICTURE TOOLS FORMAT tab appears,meaning that you can access tools for formatting the picture.

View and Print are two options for removing ____ from a spreadsheet layout.

An image inserted into a spreadsheet cell cannot be resized.

A ____ sparkline can be used to show a trend over time.

When pasting a PowerPoint picture in an Excel cell,you should insert it as a ____ via a Paste Special operation.

Adding a chart to a spreadsheet can help readers visualize data in numbers-driven worksheets.

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

A sparkline is a mini-chart within an Excel worksheet cell.

To print only a selected section of a spreadsheet,choose the Headings,View option.

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

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

To insert a picture in a spreadsheet cell,click the Picture button in the ____ group on the INSERT tab.

When viewing a column chart,the Y axis is the ____ line starting at the lower-left edge of the chart graphics.