unit d excel

a bar chart compares trends over even time intervals

false

when the landscape oritentation is selected, the data and chart will be positioned vertically on a page

false

moving a chart object around on a worksheet can affect the data in the worksheet

false

the horizontal axis is also called the value axis

false

a chart must be located in a specific cell or at a specific range address

false

word art, which lets you create curved or strylized text, can be created using the Chart tools format tab

false

a collection of related data points is called a ———-

data series

a —– identifies each data series in a chart

legend

——- indicate the scale of measure for each value on the Y- axis

gridlines

each value in a cell selected for a chart is called a —– —-

data point

teh x- axis and y- axis are respectively the ——- ——- ————–

horizontal and vertical axis

which two charts compare trends overtime intervals?

scatter line

a pie chart ——————————————————-

compares sizes of pieces as part of a whole

which chart type would you use to compare distinct objects over time using a horizontal format?

bar

to show how individual volume changes over time in relation to total volume, use an ——- chart

area

on a chart created in excel the vertical axis is called the —— axis

value

item —- represents a data point

1

item —- represents the vertical axis

3

item 4 points to the ———————-

data marker

item 5 represents the ———————

data series

item —- represents the horizontal axis

6

item 7 represents ———–

legend

a chart that is inserted directly in the current worksheet is called an ——————

embedded

a —– chart compares distinct object levels using a vertical format; is the excel default

column

the chart shown above is a —– chart

column

the arrow is pointing to —– —–

sizing handles

you can add data labels by selecting your chart and clicking the data labels button in the labels group in the chart tools ———– tab on the ribbon

layout

you can modify the data range and configuration of a chart in the —- group of the chart tools design tab

data

—– are the horizontal and vertical lines in a chart that enable the eye to follow the value on an axis

gridlines

you can apply a chart type to an existing data series in a chart to create ——– chart

combination

item 3 points to a ———— —– —–

horizontal axis title

item 4 point to a —– —– ——

horizontal axis label

item 1 to a —– —– —–

vertical axis title

item 2 to a ——————– —-

vertical axis label

text annotations are ———- that you can add to further describe the data in your chart

labels

——– —— lets you create diagram types including list process cycle hierarchy relationship matrix pyramid

smart art

you can add a text box using the chart tools ——— tab

layout

—– make it possible to apply multiple formats to a data series such as an outline fill color and text color all with a single click

styles

in a pie chart slices that are pulled away are said to be ————————

exploding