Excel Chapter 4 MC

Question 1

For which of the following reasons would you choose to use a chart or graph?

Answer 1

To show trends or relationships across data

Question 2

The ____ is not a component of a data series.

Answer 2

Category name

Question 3

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

Answer 3

pie

Question 4

To work with a title or other individual element of a chart, select the ____ tab.

Answer 4

Layout

Question 5

Placing a chart in a ____ displays only the chart and no worksheet cells.

Answer 5

chart sheet

Question 6

Depending on the pie chart layout you choose, you can ____.

Answer 6

Hide or display the chart title

Display a chart legend

Add percentages to pie slices

Question 7

A(n) ____ is text associated with a data value.

Answer 7

data label

Question 8

If you do not want a chart to reflect new values in the data source, you should ____.

Answer 8

paste the chart as a picture

Question 9

To display a large number of categories whose values are close to one another, you should create a ____ chart.

Answer 9

Column

Bar

Question 10

A ____ acts like a line on a ruler, making it easier to read a chart’s scale.

Answer 10

major tick mark

Question 11

The ____ axis displays the categories associated with each data value.

Answer 11

horizontal

Question 12

In a column chart, you can ____.

Answer 12

Add a gradient fill to columns

Reduce gap width between columns

Insert minor tick marks to detail space

Question 13

To display Mar 17, 2008 as a custom format, you would type ____ in the Format Code: box in Excel.

Answer 13

mmm-dd-yyyy

Question 14

Which of the following are examples of shapes you could choose from the Excel design gallery?

Answer 14

?

Question 15

After you insert a shape into a chart or worksheet, you can ____.

Answer 15

?

Question 16

The most precise way to move an embedded shape from one position to another is to use ____.

Answer 16

?

Question 17

All of the following are options for horizontally aligning a shape except ____.

Answer 17

?

Question 18

A chart sheet can contain ____, enabling you to display several charts at once within a single sheet.

Answer 18

embedded charts

Question 19

Rotation options for a chart allow you to rotate the ____.

Answer 19

x-axis

y-axis

perspective

Question 20

Which of the following represents a range of data in Excel?

Answer 20

C2:F12

Question 21

A(n) ____ chart is similar to a line chart, but uses a fill color to shade areas under the lines.

Answer 21

area

Question 22

In Excel charts, the Legend Options dialog box allows you to change all the following except ____.

Answer 22

Font Size

Question 23

If you have chosen Outside End, Percentage, and Show Leader Lines, you are setting options in the ____ box.

Answer 23

Label Options

Question 24

Because of the visual distortion that can result with 3D charts, you should ____.

Answer 24

include data labels with all 3D charts

Question 25

With 3-D rotation, you can change a chart’s ____.

Answer 25

Rotation

Perspective

Depth

Question 26

To fill a column with a blend of colors in a column chart, you would choose ____ from the Fill options.

Answer 26

gradient fill

Question 27

Which of the following is not an option in the Fill options in the Format Data Series dialog box?

Answer 27

All are options (preset colors, angles, direction)

Question 28

In Excel, Axis Options allow you to specify ____.

Answer 28

The axis type

Where the vertical axis crosses

The axis position

Question 29

The first step in creating a combination chart is to ____.

Answer 29

select a data series in an existing chart that you want to appear as another chart type

Question 30

The ____ is a rectangular area that labels the markers or symbols used in a chart.

Answer 30

legend