WorksheetsPART 2: QUIZ#1-COMPUTER 6
Total questions: 30
Worksheet time: 15mins
A (a) is a tool you can use in Excel to communicate data graphically.
The (a) is one of the most frequently used chart types, typically used to show trends over a period of time.
(a) are ideal if you need to compare a single category of data between individual sub-items, such as, for example, when comparing revenue between regions.
A (a) represents the distribution or proportion of each data item over a total value .
(a) are ideal for visualizing the distribution or proportion of data items when there are more than three categories.
(a) are ideal for clearly illustrating the magnitude of change between two or more data points. For example, you can give your audience a visual feel for the degree of variance between the high and low price for each month.
chart is a visualization that combines two or more chart types into a single chart
(a)
Identify
(a)
Identify
(a)
Identify
(a)
Illustrates comparisons among individual items
bar
column
line
xy scatter
Combines more than one type of chart for example, a column chart and a line chart, which would easily identify data that reflects an average
combo
line
pie
Radar
Every chart must have a
chart name
chart title
chart slogan
chart word
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
The cells that contains values and labels to be graphed in a chart
data series
data points
source data
chart elements
Identify this chart.
Pie
Line
Bar
Column
Identify this chart.
Line
Bar
Column
Pie
Identify this chart.
Column
Bar
Line
Pie
Tells you what each part of the chart represents.
Legend
Vertical axis
Horizontal axis
Chart title
This part of the chart is usually vertical and contains data.
Y axis
X axis
Legend
Chart title
This part of the chart is usually horizontal and contains categories.
X axis
Y axis
Legend
Chart title
According to this chart, in which month are produce sales the highest?
June
March
November
May
According to this chart, which band sold the most albums?
Doug and the Slugs
Gails and the Snails
Sherm and the Worms
Marva and the Larva
Emphasizes the magnitude of change over time
Area
Bar
column
pie
Legends are added at the ________ of a chart by default.
top
bottom
middle
right
A Chart is a pictorial representation of data
True
False
A Chart can be moved to a separate sheet.
True
False
Once a type of graph is chosen it cannot be changed to other type
True
False
