Exam 3: Determining Effective Data Display with Charts

Explore all topics

Charts can be either embedded as an object on the same worksheet as the data, or placed on a separate worksheet referred to as a(n) ____________________.

(Short Answer)

4.9/5

(40)

Question 141

In a worksheet, you can add up the stock traded during the month by using the ADD function. _________________________

(True/False)

4.9/5

(36)

Question 142

The purpose of formatting is to make a chart ____.

(Multiple Choice)

4.9/5

(30)

Question 143

The ____________________ chart type displays stock price and volume trends over time. Plotted values can include volume, opening price, highest price, lowest price, and closing price.

(Short Answer)

4.9/5

(37)

Question 144

When the chart is plotted by columns, what information does it emphasize?

(Multiple Choice)

4.9/5

(41)

Question 145

____ are the related data points that are plotted on the chart.

(Multiple Choice)

4.7/5

(37)

Question 146

In a ____ chart, values are indicated by the distance from a center point.

(Multiple Choice)

4.9/5

(48)

Question 147

Excel offers many formatting and display options for changing the layout of chart elements that can be found on the ____ when a chart is selected.

(Multiple Choice)

4.9/5

(45)

Question 148

In a ____ chart, values are indicated by the height of the lines.

(Multiple Choice)

4.7/5

(41)

Question 149

The design of statistical graphics is the combined use of points, lines, numbers, words, shading, and color to present quantitative information.

(True/False)

4.7/5

(32)

Question 150

Showing 141 - 150 of 150

Charts can be either embedded as an object on the same worksheet as the data, or placed on a separate worksheet referred to as a(n) ____________________.

In a worksheet, you can add up the stock traded during the month by using the ADD function. _________________________

The purpose of formatting is to make a chart ____.

The ____________________ chart type displays stock price and volume trends over time. Plotted values can include volume, opening price, highest price, lowest price, and closing price.

When the chart is plotted by columns, what information does it emphasize?

____ are the related data points that are plotted on the chart.

In a ____ chart, values are indicated by the distance from a center point.

Excel offers many formatting and display options for changing the layout of chart elements that can be found on the ____ when a chart is selected.

In a ____ chart, values are indicated by the height of the lines.

The design of statistical graphics is the combined use of points, lines, numbers, words, shading, and color to present quantitative information.

Applying Fundamental Excel Skills and Tools in Problem Solving

Solving Problems with Statistical Analysis Tools

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters