Exam 4: Effective Charts

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

A common use for ________ charts is for project management.

Free
(Short Answer)
4.9/5
(34)
Correct Answer:
Verified

Gantt

   In the worksheet above,the red arrow is pointing at a(n)________ In the worksheet above,the red arrow is pointing at a(n)________

Free
(Short Answer)
4.8/5
(36)
Correct Answer:
Verified

data bar

Gridlines can be customized by using the Format ________ Gridlines task pane.

Free
(Short Answer)
4.8/5
(44)
Correct Answer:
Verified

Major

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

(Multiple Choice)
4.9/5
(30)
Match the following terms to their definition.
Chart Sheet
Tool allowing single-click access to formatting,,charts,and formulas
Data visualization
Graphic representation overlaid on a worksheet cell
Data series
Worksheet restricted to displaying chart objects
Correct Answer:
Verified
Premises:
Responses:
Chart Sheet
Tool allowing single-click access to formatting,,charts,and formulas
Data visualization
Graphic representation overlaid on a worksheet cell
Data series
Worksheet restricted to displaying chart objects
Quick Analysis
Graphical presentation of data
Data bar
Group of related data values
(Matching)
4.7/5
(32)

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

(True/False)
4.8/5
(39)

In a chart,the ________ is an index that identifies the data.

(Short Answer)
4.9/5
(39)
Match the following terms to their definition.
Trendline
Small chart embedding in a worksheet cell
Combination
Individual data value
Gantt
Shows the general direction of the data being plotted
Correct Answer:
Verified
Premises:
Responses:
Trendline
Small chart embedding in a worksheet cell
Combination
Individual data value
Gantt
Shows the general direction of the data being plotted
Data point
Chart used in project management
Sparkline
Chart that uses multiple chart types
(Matching)
4.9/5
(37)

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

(True/False)
4.8/5
(22)
Match the following chart types to their application.
Pie
Shows changes within a data series
Scatter
Compares data vertically
Column
Compares data horizontally
Correct Answer:
Verified
Premises:
Responses:
Pie
Shows changes within a data series
Scatter
Compares data vertically
Column
Compares data horizontally
Line
Compares the relationship of parts to a whole
Bar
Used for correlations
(Matching)
4.7/5
(34)

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

(Multiple Choice)
4.7/5
(39)

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

(Short Answer)
4.9/5
(40)

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

(Multiple Choice)
4.8/5
(27)

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

(True/False)
4.8/5
(35)

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

(Multiple Choice)
4.8/5
(35)

   The chart shown above depicts a line chart. The chart shown above depicts a line chart.

(True/False)
4.9/5
(39)

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

(Multiple Choice)
4.7/5
(34)

Using a(n)________ pie chart,you can emphasize a slice by moving it out away from the other slices.

(Short Answer)
4.9/5
(32)

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

(True/False)
4.9/5
(33)
Match the following buttons to their action.
Chart Elements
Chart Filters
Size and Properties
Correct Answer:
Verified
Premises:
Responses:
Chart Elements
Chart Filters
Size and Properties
Fill & Line
Chart Styles
(Matching)
4.7/5
(34)
Showing 1 - 20 of 98
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)