Deck 98: Spreadsheet Graphics

Question 1

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

Answer 1

False

Question 2

Tools used to add a chart to a spreadsheet are located on the ____ tab.

A) Home
B) Charts
C) Insert
D) Layout

Answer 2

B

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

A) diagonal
B) vertical
C) horizontal
D) adjacent

Question 12

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

Question 13

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

A) select the range of cells containing the data to include in the chart
B) choose a chart style
C) format chart titles
D) determine where the chart will be situated in the spreadsheet

Question 14

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

Question 15

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

A) shift
B) alt
C) esc
D) command

Question 16

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.

Question 17

Tools for creating headers and footers are located on the Page Setup dialog box.

Question 18

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

A) Column
B) Line
C) Pie
D) Bar

Question 19

Adding labels to pie ____ makes it easier for viewers to interpret each piece of data.

A) charts
B) legends
C) slices
D) titles

Question 20

To resize a chart,click the chart to select it,grab any edge,and drag the chart to its desired size.

Question 21

When pasting a PowerPoint picture in an Excel cell,you should select Paste as ____ in the Paste menu.

A) Bitmap
B) Drawing Object
C) Picture
D) none of the above; a PowerPoint image cannot be copied into a spreadsheet cell

Question 22

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.

Question 23

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

A) Portrait and Landscape
B) Portrait and Orient
C) Landscape and View
D) Landscape and Print

Question 24

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

Question 25

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

A) Page Break
B) Manual Breaks
C) Breaks
D) Insert Break

Question 26

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

A) Footer
B) Page Options
C) Header and Footer
D) Print Options

Question 27

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

A) directly behind
B) in front of
C) above
D) directly below

Question 28

To move a chart to a new workbook location,click the ____________________ menu,and then click Move Chart.

Question 29

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

A) diagonal
B) vertical
C) horizontal
D) adjacent

Question 30

The ____ button,which is available via the Chart Layout tab,provides tools for modifying chart axes.

A) Axes
B) Gridlines
C) Plot Area
D) Trendline

Question 31

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

Question 32

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

A) 3-D
B) line
C) win/loss
D) column

Question 33

Sparklines are meant to show a large amount of ____________________ information in a limited amount of space.

Question 34

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

A) Chart
B) Home
C) Sparklines
D) Format

Question 35

Removing gridlines by deselecting Gridlines in the ____________________ group on the Layout tab causes gridlines to disappear from the display screen.

Question 36

To insert a picture in a spreadsheet cell,select Photo and then select "Picture from File" from the ____ menu.

A) Links
B) Images
C) Symbol
D) Insert

Question 37

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

A) directly behind
B) in front of
C) above
D) directly below

Question 38

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

Question 39

The options to remove gridlines from a spreadsheet are located in the ____ groups on the Layout tab.

A) View and Save
B) View and Print
C) Visible and Invisible
D) Hidden and Plain View

Question 40

To insert a manual page break in a worksheet,click the row ____ the new page should begin.

A) below where
B) above where
C) approximately where
D) where