Deck 4: Effective Charts

Question 1

To show changes over time,you would use a ________ chart.

A)Line
B)Column
C)Bar
D)Pie

Answer 1

A

Question 2

A ________ chart is used to shows project schedule where each bar represents a project component or task.

A)Gantt
B)Flow
C)Structure
D)Venn

Answer 2

A

Question 3

The chart shown above depicts a(n)________ chart.

A)Line
B)Scatter
C)Radar
D)Area

Answer 3

D

Question 4

A(n)________ chart is useful for showing categories that change over time and where each column represents a unit of time.

A)Column
B)Radar
C)Area
D)Surface

Question 5

To illustrate the relationship of the parts to the whole,you would use a(n)________ chart.

A)Line
B)Pie
C)Scatter
D)Area

Question 6

Which of the following is NOT one of the CHART TOOLS contextual tabs?

A)Chart Elements
B)Chart Area
C)Chart Filters
D)Chart Styles

Question 7

The chart shown above depicts a(n)________ chart.

A)Surface
B)Area
C)Bar
D)Column

Question 8

To show the relationship between two numeric variables,you would use a ________ chart.

A)Cluster
B)Surface
C)Scatter
D)Radar

Question 9

When creating a chart from data in a worksheet,the legend data is indicated by ________.

A)shading the data with a light purple background
B)surrounding the data with a purple border
C)changing font color of the data to red
D)surrounding the data with a red dashed border

Question 10

To display the Move Chart dialog box,you click Move Chart in the ________.

A)Chart Layouts group on the CHART TOOLS FORMAT tab
B)Location group on the CHART TOOLS FORMAT tab
C)Chart Layouts group on the CHART TOOLS DESIGN tab
D)Location group on the CHART TOOLS DESIGN tab

Question 11

A ________ chart can show information such as start and end times,sequence of tasks,and people assigned to each task.

A)Scatter
B)Combination
C)Gantt
D)Flow

Question 12

Which of the following is NOT a primary business charting objective?

A)Data modification
B)Data exploration
C)Argumentation
D)Hypothesis testing

Question 13

If you wanted to compare the percentages of students in a class that received A's,that received B's,that received C's,and so on,you would use a ________ chart.

A)Radar
B)Column
C)Scatter
D)Pie

Question 14

To see possible types of graph to use,you can click Recommended Charts in the ________.

A)Illustrations group on the INSERT tab.
B)Charts group on the INSERT tab.
C)Illustrations group on the VIEW tab.
D)Charts group on the VIEW tab.

Question 15

To enter a footer or header to a worksheet,you click Header & Footer in the:

A)Page setup group on the INSERT tab.
B)Text group on the INSERT tab.
C)Page setup group on the PAGE LAYOUT tab.
D)Text group on the PAGE LAYOUT tab.

Question 16

If you wanted to see how the value of Apple's stock has changed during the past year,you would use a ________ chart.

A)Scatter
B)Column
C)Line
D)Pie

Question 17

The related data values used in creating a chart are called ________.

A)a legend
B)category labels
C)data series
D)value labels

Question 18

To view additional information or modify labels,you would click the ________ conceptual tab.

A)Chart Elements
B)Chart Styles
C)Chart Area
D)Chart Editing

Question 19

Excel's ________ feature analyzes a selection in a worksheet and suggests chart types that best fit the selected data.

A)Chart Wizard
B)Chart Maker
C)Recommended Charts
D)Chart Styles

Question 20

The chart shown above depicts a(n)________ chart.

A)Area
B)Radar
C)Scatter
D)Cluster

Question 21

In the worksheet above,the red arrow is pointing at a ________.

A)trendline
B)sparkline
C)regression line
D)progression line

Question 22

To modify the layout and data in an existing chart,you click Change Chart Type in the ________.

A)Chart Layouts group on the CHART TOOLS FORMAT tab
B)Type group on the CHART TOOLS FORMAT tab
C)Chart Layouts group on the CHART TOOLS DESIGN tab
D)Type group on the CHART TOOLS DESIGN tab

Question 23

A chart sheet contains both the chart and the data associated with the chart.

Question 24

To change the color of a chart ,you click Change Colors in the ________.

A)Chart Layouts group on the CHART TOOLS DESIGN tab
B)Chart Styles group on the CHART TOOLS DESIGN tab
C)Chart Layouts group on the CHART TOOLS FORMAT tab
D)Chart Styles group on the CHART TOOLS FORMAT tab

Question 25

A chart is limited to a single data series.

Question 26

To place an object such as a rectangle or circle into a chart,you click ________ in the Illustrations group on the INSERT tab.

A)Figures
B)Objects
C)Shapes
D)Forms

Question 27

To activate the Chart Tools contextual tab,you double-click the chart border.

Question 28

To open the Format Axis task pane,you ________.

A)click anywhere in the chart and click select Format Axis in the Arrange group on the CHART TOOLS FORMAT tab
B)click anywhere in the chart and click select Format Axis in the Layouts group on the CHART TOOLS FORMAT tab
C)right-click anywhere in the chart and select Format Axis from the menu
D)double-click on the axis

Question 29

Which of the following is NOT an Excel trendline type?

A)Quadratic
B)Linear
C)Exponential
D)Two-period moving average

Question 30

The Recommend Charts feature is located on the INSERT tab on the Ribbon.

Question 31

Clicking allows single-click access to formatting,formulas,and sparklines.

Question 32

PNG,JPEG,and GIF are examples of file extensions used for ________ files.

A)template
B)dynamic worksheet
C)picture
D)chart or graph

Question 33

Actions performed in the Chart Formatting Control can be performed through the Chart Tools contextual tab on the Ribbon.

Question 34

You can use the corners or middle areas of a chart border to resize a chart.

Question 35

________ are small charts that are embedded into the cells in a worksheet to help with trend analysis.

A)Minicharts
B)Microcharts
C)Sparklines
D)Data bars

Question 36

Which of the following is NOT a chart background fill option?

A)Transition
B)Color
C)Pattern
D)Picture

Question 37

To move a chart,you double-click its border and drag the chart to a new location.

Question 38

A(n)________ is a line that uses current data to display the progress or general direction of the data.

A)major gridline
B)minor gridline
C)trendline
D)axis

Question 39

To deselect a chosen chart object,you can press Esc.

Question 40

To place an image into a chart,you click ________ in the Illustrations group on the INSERT tab.

A)Pictures
B)Figures
C)Illustrations
D)Images

Question 41

By clicking the Chart Elements button,you can add,move,or remove data labels.

Question 42

The chart layouts are available in the Chart Layouts group under the Chart Tools contextual tabs on the Design tab.

Question 43

If a change is made to a worksheet,you have to make the corresponding change to the connected chart.

Question 44

An enhanced pie chart is a chart in which a slice is pulled outward away from the other slices.

Question 45

You can enhance chart text by formatting it as WordArt.

Question 46

A scatter chart is a variation of a stacked line chart emphasizing the amount of change over time.

Question 47

Care must be taken when adding or removing chart elements,since the position of other elements may change.

Question 48

When adding colors to a chart,more is better.

Question 49

After inserting a shape into a graph,you can enter text in the shape.

Question 50

You can remove a chart element by selecting it and then pressing Delete.

Question 51

You can add chart and axes titles on the Chart Tools Format tab or with the Chart Elements button.

Question 52

By default,Excel displays both major gridlines and minor gridlines on a chart.

Question 53

The chart shown above depicts a line chart.

Question 54

To examine the relationship between two numeric variables,you would use a scatter chart.

Question 55

When using an area chart,the x-axis typically involves time.

Question 56

Chart layouts focus on location of components,whereas styles focus more on the color coordination and effects of the components.

Question 57

A scatter chart is displayed vertically and is useful for comparing categorized data sets.

Question 58

To create a line chart,at least one set of labels and at least one set of corresponding data are needed.

Question 59

A bar chart is displayed horizontally and is useful for comparing categorized data sets.

Question 60

To create a pie chart,two data series,the labels and a set of corresponding values are required.

Question 61

A(n)________ chart highlights regions showing growth over time or for categories and is a variation of a line chart.

Question 62

The chart shown above depicts a(n)________ chart.

Question 63

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 64

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

Question 65

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

Question 66

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

Question 67

To change the style of a chart,you would click the ________ conceptual tab.

Question 68

A(n)________ is an individual value in a data series.

Question 69

To display the Format Data Labels task pane,you click the Data Labels ________ and select More Options.

Question 70

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

Question 71

When working with a chart,you click the ________ to display the CHART TOOLS.

Question 72

A common use for ________ charts is for project management.

Question 73

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

Question 74

Printing a chart is basically the same as printing a worksheet.

Question 75

Exploding a pie slice is a common pie chart enhancement.

Question 76

When formatting a chart area,you would click ,which is the ________ button used to display chart properties.

Question 77

When creating a chart from data in a worksheet,the data series is surrounded by a(n)________ border.

Question 78

The chart shown above depicts a(n)________ chart.

Question 79

You can display data bars as a one-color solid fill or a gradient fill from left to right as the numerical value increases.

Question 80

A common enhancement for a line chart is the addition of color,weight,and marker size.