Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)   View and Save
B)   View and Print
C)   Visible and Invisible
D)   Hidden and Plain ViewE) C) and D)
F) None of the above

Question 3

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

Accepted Answer

The answer of Sparklines are meant to show a large...

Question 4

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

Accepted Answer

A)   directly behind
B)   in front of
C)   above
D)   directly belowE) A) and C)
F) All of the above

Question 5

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.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)   diagonal
B)   vertical
C)   horizontal
D)   adjacentE) B) and C)
F) B) and D)

Question 7

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

Accepted Answer

The answer of Removing gridlines by deselecting Gridlines in the...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)   diagonal
B)   vertical
C)   horizontal
D)   adjacentE) None of the above
F) B) and C)

Question 10

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

Accepted Answer

A)   charts
B)   legends
C)   slices
D)   titlesE) A) and B)
F) A) and C)

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A)   Portrait and Landscape
B)   Portrait and Orient
C)   Landscape and View
D)   Landscape and PrintE) C) and D)
F) A) and B)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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 spreadsheetE) C) and D)
F) A) and D)

Question 15

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

Accepted Answer

A)   Axes
B)   Gridlines
C)   Plot Area
D)   TrendlineE) A) and B)
F) None of the above

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)   Home
B)   Charts
C)   Insert
D)   LayoutE) A) and B)
F) A) and C)

Question 18

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

Accepted Answer

The answer of To move a chart to a new...

Question 19

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

Accepted Answer

A)   below where
B)   above where
C)   approximately where
D)   whereE) B) and C)
F) All of the above

Question 20

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

Accepted Answer

A)   Links
B)   Images
C)   Symbol
D)   InsertE) B) and C)
F) None of the above

Exam 98: Spreadsheet Graphics

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified