Excel Unit D

Question 1

Often contains numerical values that help you interpret the size of chart elements

Answer 1

Data market

Question 2

Visually represents each data point

Answer 2

Chart

Question 3

An independent element on a worksheet

Answer 3

Object

Question 4

What type of chart is shown in the accompanying figure

Answer 4

Column

Question 5

In the accompanying figure item ___ represents the vertical axis

Answer 5

3

Question 6

To show how individual volume changes over time in a relationship to total volume use an

Answer 6

Area chart

Question 7

Which chart type do you use to compare distinct objects over time using horizontal bars

Answer 7

Bar

Question 8

Which chart type is the best candidate for spotting trends and extrapolating information based on research data

Answer 8

Scatter

Question 9

You can ___ title text to select it

Answer 9

Triple click

Question 10

An example of a(n) ___ chart is a column chart with a line chart

Answer 10

Combination

Question 11

A combination chart can add an ___ axis to chat related data

Answer 11

Secondary

Question 12

The default border color around a chart title is

Answer 12

Blue

Question 13

In the accompanying figure item 1 points to a

Answer 13

Vertical axis title

Question 14

In the accompanying figure item 2 points to a

Answer 14

Vertical axis label

Question 15

In the accompanying figure item 5 points to a

Answer 15

Horizontal axis label

Question 16

Which of the following is not an option that the Data Labels can produce

Answer 16

Legend name

Question 17

Shape ___ make it possible to apply multiple formats to a data series’s such as on outline fill color all with a single click

Answer 17

Styles

Question 18

You can add text box using the Chart Tools

Answer 18

Format

Question 19

___ lets you create diagram types including List Process Cycle Hierarchy Relationship Matrix and Pyramid

Answer 19

Smart art

Question 20

In a pie chart slices that are pulled away are said to be

Answer 20

Exploded

Question 21

Text annotations are ___ that you can add to further describe the data in your chart

Answer 21

Labels

Question 22

In the accompanying figure item 3 points to ___

Answer 22

Horizontal axis title

Question 23

You can change a column chart to a clustered bar chart using the ___ dialog box

Answer 23

Change Chart Type

Question 24

Which of the following will NOT be affected or rearrange by choosing a new layout on the Chart Tools Design tab

Answer 24

Data

Question 25

A scatter chart

Answer 25

Compares trends over uneven time or measurements intervals

Question 26

A chart that is inserted directly in the current worksheet is called a(n)

Answer 26

Embedded chart

Question 27

Which chart type is the best candidate for emphasizing sales trends over a period of six months

Answer 27

Line

Question 28

Which to chats compare trends over time

Answer 28

Line and scatter

Question 29

Compares sizes of pieces as parts of a whole

Answer 29

A pie chart

Question 30

A(n) ___ chart compares distinct object levels using vertical bars it is the exel default

Answer 30

Column

Question 31

In the accompanying figure item 5 represents

Answer 31

The legend

Question 32

In the accompanying figure item ___ represents the horizontal axis

Answer 32

2

Question 33

Often contains the names of data groups such as locations months or years

Answer 33

Value axis