NEW
Font size
WorksheetsCreating Charts
Total questions: 20
Worksheet time: 10mins
Every chart must have a
chart name
chart title
chart slogan
chart word
On our X and Y axis we must always
insert axis titles
leave these blank
fill them in with numbers
remove them
Chart titles and axis titles should be
shown in bold
shown in capital letters
shown in italics
font size 14
The key at the side of the chart is called
a decoder
a what is where
a legend
the axis
we must add these so that the person reading the chart can see the exact figures clearly
data labels
information labels
number labels
item labels
When adding up more than 2 cells in a spreadsheet we use
=PLUS
=ADD
=SUM
=SUBTRACT
To find the average number in a range we use the formula
=AVG
=AVERAGE
=AVERAGES
=MEAN
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
Identify this chart.
Pie
Line
Bar
Column
Which is NOT a type of chart?
pie
column
bar
axis
Why are charts/graphs used in spreadsheets?
to show a visual of the data in a spreadsheet
to make the spreadsheet look cool
to backup the data you input into the spreadsheet
all of these are reasons
What is the first thing you have to do in a spreadsheet before you can create a chart/graph?
click insert charts/graphs
go to file, print
highlight the data with your mouse
bold all the information
Click __________ tab to create a chart.
CREATE
INSERT
FORMAT
HOME
The lines that run across the plot area are known as ________
Chart title
Legends
Gridlines
Data series
