AnswersTX-Business Information Management BIM IAnalyzing Data

Analyzing Data Answers

16 verified answers3 views
1
Free Preview

Where do charts get the data series names?

A
data entries
B
row labels
C
column labels
D
worksheet title
2
Free Preview

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

A
Chart Legends
B
Data
C
Types
D
Chart Styles
149139

Select the correct navigational path to create a combination chart.

Answers:
Click the Chart Tools tab.:Format
Click the Chart Tools tab.:Design
149140

Layout ✔ DesignInsert Format

A
Layout
B
✔ Design
C
Insert
D
Format
149141

Select the correct navigational path to use a saved chart template.

Answers:
Click the tab on the ribbon and look in the group.:Insert
Click the tab on the ribbon and look in the group.:Charts
Click the dialog box launcher and then the tab.:All charts
Select the left tab , select the one you want to use, and click OK.:Templates
149142

Tables Illustrations Add-ins ✔ Charts

A
Tables
B
Illustrations
C
Add-ins
D
✔ Charts
149143

✔ All chartsSymbols Filters Links

A
✔ All charts
B
Symbols
C
Filters
D
Links
149144

Column Recent ✔ TemplatesCombo

A
Column
B
Recent
C
✔ Templates
D
Combo
149145

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
149146

On the Design tab, which group allows you to select a different data set for a chart?

A
Data
B
Chart Legends
C
Type
D
Chart Styles
149147

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
149148

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

A
Format
B
Design
C
View
D
Data
149149

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.
149150

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
149151

After saving a chart, where can you find it again to use it for a different data set?

A
sparklines
B
saved charts
C
templates
D
formats
149152

Select the correct navigational path to use a saved chart template.

Answers:
Click the tab on the ribbon and look in the group.:Insert
Click the tab on the ribbon and look in the group.:Charts
Click the dialog box launcher and then the tab.:All charts
Select the left tab , select the one you want to use, and click OK.:Templates

Did you find these answers helpful?

More from this Course

Instruction
16 verified answers

Instruction

Instruction
14 verified answers

Forecasting Data

Instruction
14 verified answers

Working with Table Data