Deck 10: Effective Charts

Question 1

Chart styles are located in the ________ tab.

A) Chart Formats group on the Chart Design
B) Chart Styles group on the Chart Design
C) Chart Formats group on the Chart Tools Design
D) Chart Styles group on the Chart Tools Design

Answer 1

Chart Styles group on the Chart Tools Design

Question 2

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

A) on a chart sheet
B) integrated
C) embedded
D) an external object.

Answer 2

on a chart sheet

Question 3

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

A) column
B) combination
C) area
D) Scatter

Answer 3

combination

Question 4

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

A) development
B) hypothesis
C) persuasion
D) visualization

Question 5

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

A) combination
B) bar
C) column
D) scatter

Question 6

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

A) orange
B) purple
C) blue
D) green

Question 7

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

A) combination
B) bar
C) area
D) column

Question 8

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

A) Quick Analysis
B) Sparklines
C) Quick Chart
D) Insert Charts

Question 9

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

A) analysis
B) data bar
C) data point
D) data series

Question 10

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

A) line
B) Scatter
C) pie
D) stacked column

Question 11

Chart layouts are available in the ________ tab.

A) Chart Layouts group on the Design
B) Chart Styles group on the Design
C) Chart Layouts group on the Chart Tools
D) Chart Styles group on the Chart Tools

Question 12

When creating a chart,best practices indicate that you first consider ________.

A) the basic design of the chart
B) the data
C) who will be viewing the chart
D) how quickly it needs to be created

Question 13

To open the Format Chart Area task pane,right-click the chart border,and then select ________.

A) Format Properties
B) Chart Properties
C) Format Chart Area
D) Chart Formatting dialog box

Question 14

A ________ chart is useful for comparing data sets that are categorized.

A) combination
B) column
C) area
D) Scatter

Question 15

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

A) a chart sheet
B) integrated
C) embedded
D) wrapped

Question 16

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

A) mark
B) bar
C) point
D) series

Question 17

The underlying data for a chart and labels is the ________ data.

A) worksheet
B) source
C) link
D) workbook

Question 18

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

A) orange
B) purple
C) blue
D) green

Question 19

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

A) bar
B) combination
C) area
D) pie

Question 20

A ________ chart is used to communicate trends over time.

A) line
B) column
C) pie
D) stacked column

Question 21

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

A) Sparklines
B) Trendlines
C) Data bars
D) Data points

Question 22

When you click an existing chart,you initially activate the legend.

Question 23

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

A) x-axis labels
B) title
C) legend
D) y-axis labels

Question 24

When a chart is selected,the Chart Formatting Control will appear below the chart.

Question 25

A chart is like a picture,where a picture is worth 1,000 words.

Question 26

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

A) trendlines
B) gridlines
C) data points
D) area grids

Question 27

Which of the following is NOT true about modifying axes?

A) Excel knows best in regard to formatting the axes; thus, if it seems to crowded, it probably is not.
B) The Format Axis task pane can be used to manually set the axis options.
C) The default Excel scale minimum and maximum values are set automatically on the basis of the data.
D) The x-axis and y-axis scales are automatically created through a mathematical algorithm within Excel.

Question 28

Charts are a critical component of data visualization.

Question 29

In Excel,the default is to display the ________.

A) trendlines
B) minor gridlines
C) major gridlines
D) major and minor gridlines

Question 30

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

A) sparkline
B) trendline
C) data bar
D) legend

Question 31

Which of the following is NOT a common issue that should be avoided when creating a chart?

A) Users dislike the color scheme.
B) Too much information is on the chart.
C) Chart has issues with readability.
D) The incorrect chart type is used.

Question 32

From a chart sheet,a chart will print ________.

A) as a full page
B) with two on a page
C) with four on a page
D) Charts cannot be printed from a chart sheet

Question 33

In Excel,there are ________ types of trendlines.

A) 5
B) 2
C) 4
D) 6

Question 34

It is fairly simple to create a perfect chart the first time you create it.

Question 35

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

A) Esc
B) Ctrl + Del
C) Del
D) Alt + Del

Question 36

The first task that needs to take place when creating a chart is o organize the data.

Question 37

A ________ is a graphic component that is overlaid onto data in worksheet cells.

A) sparkline
B) trendline
C) data bar
D) data point

Question 38

Which of the following is NOT a common readability issue that should be avoided when creating a chart?

A) Check the color scheme to ensure that the text is readable.
B) Add a chart title that conveys context of time and scope.
C) Move data labels, and remove excess information.
D) Information or labeling is misleading.

Question 39

An individual data value is a data series.

Question 40

A group of related data values to be charted are called data points.

Question 41

It is important to present a well-designed chart because the chart can become a reflection on you and your company.

Question 42

A legend is considered to be a chart index.

Question 43

The Recommended Charts feature offers single-click access to formatting,charts,formulas,PivotTables,and sparklines.

Question 44

A chart sheet is a special worksheet that is dedicated to displaying chart objects.

Question 45

Chart sizes can be locked so they do not resize when columns or rows are resized.

Question 46

The default display of gridlines in Excel is to display the major gridlines and hide the minor gridlines.

Question 47

A column chart is a quantitative chart that shows growth or change in totals.

Question 48

You can resize a chart by clicking and dragging a sizing handle.

Question 49

A pie chart shows trends over time.

Question 50

As the data moves up or down,the moving average trendline will curve and adjust.

Question 51

A chart sheet contains gridlines.

Question 52

A scatter chart shows the relationship between two numeric variables.

Question 53

The Quick Analysis tool quickly analyzes a selection in a worksheet and recommends chart types that best fit your data.

Question 54

Click outside a chart object or press Esc to deselect an object.

Question 55

Any action that can be completed in the Chart Formatting Control can also be completed through the Chart Tools contextual tab.

Question 56

Trendlines help gauge the size of the bars,columns,or data lines.

Question 57

Stacked bar charts can be useful when you want to see how the individual parts add up to create the entire length of each bar.

Question 58

Bar charts are similar to column charts.

Question 59

A line chart is used to display a percent to a whole.

Question 60

When a chart is created,it is automatically placed on a chart sheet.

Question 61

The best chart to display how stocks you own have performed over the past year is the ________ chart.

Question 62

To resize a chart,click and drag a(n)________.

Question 63

A(n)________ chart is a chart that is located on the same worksheet with the data.

Question 64

A sparkline is a type of conditional formatting.

Question 65

The ________ tool is a contextual tool that provides single-click access to charts and PivotTables.

Question 66

When first creating a chart,best practice dictates that you first consider and develop the basic ________ of the chart.

Question 67

A(n)________ chart is displayed vertically and is useful for comparing categorized data sets.

Question 68

A(n)________ chart represents a percent to a whole.

Question 69

A data ________ is an individual value in a data series.

Question 70

The ________ feature analyzes your data and suggests which chart would best represent your data.

Question 71

A(n)________ chart displays a horizontal representation of categorical data.

Question 72

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

Question 73

A(n)________ bar chart can be used when the sum of the data values is as important as the individual items.

Question 74

Businesses have three primary objectives in charting: data analysis,________ testing,and persuasion.

Question 75

If you wanted to see if there is relationship between the miles per hour over the speed limit recorded on a ticket and the amount of the resulting fine,you would use a(n)________ chart.

Question 76

A group of related data values to be charted is a data ________.

Question 77

Data ________ is the graphical presentation of data focusing on qualitative understanding.

Question 78

When a chart is selected,the ________ contextual tab appears on the ribbon.

Question 79

A(n)________ chart stacks a series of colored layers and can be used to see trends over a period of time.

Question 80

A(n)________ is a special worksheet that only contains chart objects.