Analyzing Data Answers

16 verified answers1 views
3

Click the dialog box launcher and then the tab.

A
All charts
B
Symbols
C
Filters
D
Links
5

Where do charts get the data series names?

A
data entries
B
row labels
C
column labels
D
worksheet title
6

What is the purpose of formatting charts?

A
changes the data set used for creating the chart
B
changes the look and feel of the display
C
changes the values in the data set
D
changes the type of chart used
8

Which Chart Tool button allows you to quickly toggle the legend on and off?

A
Chart Styles button
B
Chart Filters button
C
Chart Elements button
D
Chart Font button
10

What is unique about a dual-axis chart?

A
Data is coded with two different colors.
B
Data is charted by two different types of data.
C
The information on the axis has two different fonts.
D
One set of data is shown two different ways.
11

Click the Chart Tools tab.

A
Layout
B
Design
C
Insert
D
Format
13

What is the purpose of a linear trendline?

A
graphically represent trend of current data and predict the future of a steady rate
B
graphically represent trend of current data rate in an up-down trend
C
graphically predict the future of an up-down rate
D
graphically represent trend of current data and predict the future of a sporadic rate
15

Click the Chart Tools tab.

A
Layout
B
Design
C
Insert
D
Format
16

Click the tab on the ribbon and look in the group.

A
Tables
B
Illustrations
C
Add-ins
D
Charts

Did you find these answers helpful?