NEW
Font size
WorksheetsExpressing Data in Charts Review
Total questions: 23
Worksheet time: 18mins
An Excel chart is
group of data points
cells that contain values to be graphed
visual representation of numeric data
small circle shape to show comparisons of values
By default, OpenOffice Cal will create a chart with the y-axis starting at _____________.
0 (zero)
1
100
10
What identifies data series with colors, patterns or symbols?
Data labels
Legend
Axes
Trendline
Can you change the appearance of a chart after it is created?
Yes
No
Which chart feature is NOT available in OpenOffice Calc?
Pivot Charts
Pie Charts
Bar Charts
Changing Formatting
Which is the best chart for displaying scientific data?
Scatter Plot
Pie Chart
Area Chart
Doughnut Chart
When a PivotTable and PivotChart are linked, changes made to the PivotTable, the PivotChart changes as well.
True
False
What is the default chart type for Microsoft Excel?
Line
Column
Pie
Bar
The _______ chart compares the trend of values over time or categories.
area
line
stock
bar
Which of these types of charts compare multiple series of data in a percentage format?
Scatter plot
Doughnut
Bubble
Stock
Which type of chart displays changes in values relative to a center point?
Area
Radar
Pie
Bubble
Which type of chart is useful for finding optimum combinations between two sets of data?
Scatter plot
Stock
Column
Surface
Which type of chart is used to compare stock prices and quotes?
Line
Stock
Pie
Bubble
In Excel, how many different ways are there to view the layout of the Pivot Table field list?
2
3
5
7
