NEW
Font size
Worksheetsgrade 5- modelling exel- review ICT
Total questions: 33
Worksheet time: 17mins
Gear
Motor
Sensor
Frame
1. How to remove a rivet?
Using a rivet tool
Using a rivet remover
Using a gear
Using a plate
Big Motor
Big Gear
Small Gear
Big Wheel
How to use a rivet to connect two plates?
Push the Pin first, and then push the Pinhole
Push the Pin and Pinhole at the same time.
Push the Pinhole first and then push the Pin
All are wrong
How to use a rivet to connect two plates?
Push the Pin first, and then push the Pinhole
Push the Pin and Pinhole at the same time.
Push the Pinhole first and then push the Pin
All are wrong
What is this?
Plate
Controller
Sensor
Gear Motor
What is the formulas in cell K15 to calculate the total of the bill?
=K4+K6+K7+K8+K9+K10+K11+K12+K13+K14
=SUM(K4:K14)
=SUM(K4-K14)
SUM(K4:K14)
Which of these could be used in a spreadsheet to display your data?
A bar chart
A line chart
A pie chart
All of the above
What is the result of total in this case?
Cannot calculate
C7
15
Fifteen
Which of the following charts is a column chart?
None of these
What is formula for E6?
= sum(E2:E5)
= E5 - E2
= E2 * E5
none of them
Which is right formula?
SUM(B3:B9)
=B4/B2
=B5xB6
=SUM C1:C7
Put these steps in the right order to make a column chart (1. Select needed data - 2. Select column chart - 3. Select Insert - 4. Choose a type of column chart)
1-2-3-4
1-3-2-4
1-4-3-2
4-3-2-1
What can you do when you want to change the size of the cell accordingly to the text’s length?
Autofit
Merge and center
Wrap text
none of them
How many cells are there in this table?
20
10
200
120
Where do you click to add one more cell?
Match the operations with the correction symbol/icon.
Addition +
Subtraction -
Multiplication *
Division /
true
false
Which is the cell address of the highlighted cell?
4C
C4
B3
B4
