Chapter Three

Question 1

In a column chart, what happens to your chart when you add a data series?

Answer 1

another column is added to the chart

Question 2

What are miniature charts displayed in a cell or cell range with your data?

Answer 2

Sparklines

Question 3

What is true about filters?

Answer 3

a filter is criteria that specifies which data is hidden, filters let you switch between several scenarios for your data, a filter is criteria that specifies which data is shown

Question 4

What chart type displays the distribution of data with minimum, mean, maximum, and outlier values?

Answer 4

Box & Whisker

Question 5

What type of chart displays relationships among numeric values in two or more data series?

Answer 5

XY

Question 6

True or False: by default, a chart sheet prints in portrait orientation?

Answer 6

False

Question 7

What is the rectangular area bounded by the horizonal and vertical axes?

Answer 7

Plot Area