BAT Chapter 3

Question 1

Gradient

Answer 1

Variegated blend of colors in a chart element

Question 2

Bevels and Shadows

Answer 2

Special effects applied to chart objects

Question 3

Data label

Answer 3

Displays the value of a column, bar, pie slice or other marker

Question 4

Waterfall chart type

Answer 4

Depicts a running total and identifies positive / negative cash flows in financial data

Question 5

What are 5 Chart Elements?

Answer 5

Titles 
Data Labels
Legends 
Gridlines
Trendlines

Question 6

Sparkline

Answer 6

Miniature charts in a cell or range

Question 7

Sunburst

Answer 7

Chart type that shows relationships among multiple categories of data

Question 8

How can a trendline be used for forecasting?

Answer 8

By plotting future approximate averages

Question 9

In a histogram chart, where are the category labels shown?

Answer 9

On both axes

Question 10

Why is it important to personalize your chart?

Answer 10

Makes your data clear and concise

Question 11

Word Art

Answer 11

Used to create a custom title chart

Question 12

What are the 3 different types of sparklines?

Answer 12

Line
Column
Win / Loss

Question 13

Win / Loss

Answer 13

A type of spark line

Question 14

Shape style

Answer 14

A predesigned combination of fill, borders and effects

Question 15

What 2 things can a Trendline be used for?

Answer 15

Displays averages in your data

Used to forecast data

Question 16

Bubble Chart

Answer 16

Displays relationships among numeric values in 2 or more data series

Question 17

Combo Chart

Answer 17

Uses 2 types of charts to graph values that are widely different

Question 18

Radar Chart Type

Answer 18

Displays the frequency of multiple data series relative to a center point