MIS Chapter 4 Excel Dr.Mo

A(n) ________ chart is similar to a column chart except the data is horizontal instead of vertical.

Bar

Brighten the color of the element

Bar/Column

A(n) ________ chart compares data vertically; can incororate a time element and groups.

Column

A(n) ________ chart displays two different types of data by using multiple chart types in a single chart object.

Combination

A group of related data values to be charted is a(n) ________

Data Series

A chart element can be easily removed by selecting the element and pressing ________.

Del

The lines that go across charts to help gauge the size of the bars, columns, or data lines are called ________.

Gridlines

An individual data value in a data series is a data ________.

Point

You can use one of two methods to deselect a chart that is embedded on the worksheet. Look at the list below and select the two methods you can use. Remember, you will select two answers below.

Press the [ESC} key Click anywhere outside the chart object

The ________ tool is a contextual tool that appears when you select data in a worksheet.

Quick Analysis

To help users better understand your chart's context, your ebook suggested all of these methods except which one?

Resize the chart

A ________ chart is very common as a statistical tool depicting the correlation (relationships) between the two variables.

Scatter

Add a trendline

Scatter

________ are small charts that are embedded into the cells in a worksheet.

Sparklines

Data bars are graphic overlays in worksheet cells which helps the user quickly understand data. They are on the Home tab under which group?

Style

If a chart is placed on a special worksheet that is dedicated to displaying chart objects, it is ________.

on a chart sheet

If a chart is selected, a(n) ________ border surrounds the data that represents the legend labels.

purple

The combination of the graphical presentation of data with a focus on qualitative understanding is called data ________.

visualization

From a chart sheet, a chart will print ________.

As A full page

A ________ chart is generally used for showing the relationship of the parts to the whole.

Pie

Explode the area of discussion

Pie Chart

A(n) ________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.

Area

f a chart is selected, a(n) ________ border represents the data series.

Blue

hart layouts are available in the ________ tab.

Chart Layouts group on the Chart Tools Design

Chart styles are located in the ________ tab.

Chart Styles group on the Chart Tools Design

Adds an exponential trendline for the elected chart series

Exponential

Why do you use sparklines?

Facilitates quick analysis of trends

The ________ is an index within a chart that provides information about the data.

Legend

A ________ chart shows changes within a data series; often used with time on the x-axis

Line

Different color, heavier weight, change marker size

Line

Adds a linear trendline for the selected chart series

Linear

Adds a trendline with a 2-period forecast

Linear Forecast

In Excel, the default is to display the ________.

Major Gridlines

The Recommended Charts feature quickly analyzes a selection in a worksheet and recommends chart types that best fit your data. Look at the list below and select the two places where the Recommended Charts option appears on a worksheet. Remember, you will select two answers below.

On the Insert tab on the ribbon In the Quick Analysis tool

A ________ is a line that shows the direction of the data.

Trendline

An audience that is distracted by the look and feel of the chart may stop looking for the message in the chart or extend the chaotic personality of the chart to the presenter.

True

Adds a 2-period moving average trendline

Two-Period/Moving Average

If a chart is inserted on the same worksheet where the data lives, it is ________ on the worksheet.

embedded