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