Creating and Using Advanced Charts and Tables

Front

What is one of the ways Excel helps users communicate information to the reader?

Back

By producing illuminating and visually appealing charts

Front

Which chart type is commonly used to display data related to income? Options: Line chart, Waterfall chart, Bar chart, Column chart

Back

Waterfall chart

Front

What does a Funnel chart represent?

Back

Decreases in a value over each stage of a multi-step process

Front

Which chart type is useful for displaying statistical information? Options: Box & Whisker chart, Funnel chart, Histogram chart, Waterfall chart

Back

Box & Whisker chart

Front

What does a Box & Whisker chart represent?

Back

Statistical distribution of values

Front

What does a Histogram chart display?

Back

Frequency of values falling within a range

Front

What is the purpose of a Waterfall chart?

Back

To display the changes in a running total over time

Front

What is important when creating a Waterfall chart?

Back

Entering values as positive or negative

Front

What does a Waterfall chart display to represent a calculation of the total value?

Back

A total value

Front

What is the purpose of the Lesson 4.1 in the workbook?

Back

To create various types of advanced charts