Deck 51: Spreadsheet Graphics

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

An image inserted into a spreadsheet cell cannot be resized.

Answer 3

False

Question 4

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

Question 5

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) Shift
B) Alt
C) Esc
D) Ctrl

Question 6

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

Question 7

Adding labels to pie ____ makes it easier for readers to interpret individual pieces of data.

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

Question 8

The advantage of using _____ after selecting a data series is the ability to look at the data in a new format before applying the change.

A) the Axes button
B) Chart Layouts
C) Live Preview
D) Quick Layout

Question 9

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 10

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

Question 11

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

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

Question 12

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

Question 13

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

Question 14

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

Question 15

A total should always be combined on the same chart with the data that comprises the total.

Question 16

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

Question 17

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.

Question 18

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

A) HOME
B) INSERT
C) CHART
D) LAYOUT

Question 19

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 20

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

Question 21

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

A) Line
B)Column
C)either a.or b.
D)neither a.nor b.

Question 22

It is possible to fit all the columns of a spreadsheet on one page using the ____ option in the Print section on the FILE tab.

A) Settings
B) Width
C) Info
D) Printer

Question 23

It is a good practice to insert a ____ after a section in a spreadsheet that needs to be displayed as one continuous unit.

A) page break
B) section break
C) column break
D) chart

Question 24

To insert a spreadsheet footer,click the INSERT tab and then click the ____ button.

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

Question 25

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

A) Pie
B) Win/Loss
C) Bar
D) Line

Question 26

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

Question 27

The ____ button,which is available via the CHART TOOLS LAYOUT tab,provides tools for modifying chart axes.

A) Axes
B) Horizontal
C) XY Area
D) Trendline

Question 28

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

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

Question 29

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

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

Question 30

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 31

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

A) sparklines
B) gridlines
C) images
D) formatting