WorksheetsGrade 5 ICT REVISION
Total questions: 17
Worksheet time: 10mins
Semilore wants to show his teacher a graphical representation of the number of pupils that love different flavours of cake in his class. What tool on Excel can he use to achieve that?
SmartArt
Shapes
Line
Figure
Charts
What is the file extension for Macromedia flash?
.fla
.pptx
.xlsx
.png
.docx
Charts are on what tab on which group.
insert, illustration
Home, font
insert, Sparkline
Insert, chart
insert, link
What formatting provides another way to visualize data and make worksheets easier to understand and work with rules?
Conditional
Basic
Chart
Sparkline
Graph
The colour code that represents each item on a chart is known
Legend
Chart title
Axis
Gridlines
Table
Conditional formatting is on ___________ tab on _______________ group.
Home, cells
Home, style
Home, editing
Home, styles
Home,
clipboard
What conditional formatting rule can be used to fish out a particular letter or word in a cell?
Highlight cell rules( between)
Highlight cell rules
(top and bottom)
Highlight cell rules( less than)
Highlight cell rules( equal to)
Highlight cell rules( text that contains)
Which chart elements displays the chart values in a table below the chart?
Data Table
Data labels
Legend
Lines
Colours
Which chart elements show the values or data points on the chart on your worksheet?
Data labels
Data tables
Legend
Axis
Chart title
How many drawing modes do we have on flash?
1
3
5
2
6
Which drawing mode can be used to draw grouped shapes?
Merge
Object
Line
Cut
Slice
What is the primary use of Macromedia flash?
Drawing
Designing
Painting
Scaling
Animation
Which drawing mode can be used to join shapes together and cut a shape?
Line
Merge
Object
Scale
Pattern
Which of the following cannot be used to format a chart?
Chart styles
Reflection
Change colour
Glow
Add chart element
Use the column graph to derive answers to the questions
How many children liked snakes?
5
2
4
15
11
Use the column graph to derive an answer to the question below
Which animal was the favourite among the children? How many children liked this
animal?
Monkey, 30 children
Lions 25, children
Snakes 5, children
Giraffe 15, children
Elephant, 20 children
Use the column graph to derive an answer to the question below
How many more children liked lions than elephants?
10
2
5
4
11
