wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

grade 5- modelling exel- review ICT

Total questions: 33

Worksheet time: 17mins

Name
Class
Date
1.
Cell you’re currently working in.
a)
Active cell
b)
Column
c)
Worksheet
d)
Row
2.
Used to color the lines or border.
a)
Fill color
b)
Fill border
c)
Fill lines
d)
Fill bucker
3.
Numbers identified in spreadsheet that are used in calculations.
a)
Label
b)
Graph
c)
Value
d)
cell
4.
A tab that identifies a worksheet.
a)
Sheet
b)
Sheet Tab
c)
Spreadsheet
d)
Spread TAB
5.
Vertical references in a spreadsheet; identified by an alphabetic letter.
a)
Column
b)
Row
c)
Cell
d)
Sheets
6.
We can insert games in Excel.
a)
YES
b)
NO
7.
Can we type words, number and symbols in Excel?
a)
YES
b)
NO
8.
Can we make a weekly schedule in MS Excel?
a)
YES
b)
NO
9.
Which is not an example of DATA?
a)
Hardware
b)
Picture
c)
Letter
d)
Number
10.
We cannot select two separated columns or rows.
a)
TRUE
b)
FALSE
11.
Which is the icon used to colour the cells or box in Excel?
a)
1
b)
2
12.
Which is the icon used to colour the words?
a)
1
b)
2
13.
Which you will use to have a line or table in Excel?
a)
Fill Color
b)
Font Color
c)
All Border
d)
No Border
14.
How do you select 2 separated rows?
a)
By holding the shift+clicking the rows
b)
By holding the capslock+clicking the rows
c)
By holding the ctrl+clicking the rows
d)
By holding the alt+clicking the rows
15.
How do you select 2 separated columns?
a)
By holding the shift+clicking the columns
b)
By holding the ctrl+clicking the columns.
c)
By holding the caps+clicking the columns.
d)
By holding the alt+clicking the columns.
16.
a)

Gear

b)

Motor

c)

Sensor

d)

Frame

17.

1. How to remove a rivet?

a)

Using a rivet tool

b)

Using a rivet remover

c)

Using a gear

d)

Using a plate

18.
a)

Big Motor

b)

Big Gear

c)

Small Gear

d)

Big Wheel

19.

How to use a rivet to connect two plates?

a)

Push the Pin first, and then push the Pinhole

b)

Push the Pin and Pinhole at the same time.

c)

Push the Pinhole first and then push the Pin

d)

All are wrong

20.

How to use a rivet to connect two plates?

a)

Push the Pin first, and then push the Pinhole

b)

Push the Pin and Pinhole at the same time.

c)

Push the Pinhole first and then push the Pin

d)

All are wrong

21.

What is this?

a)

Plate

b)

Controller

c)

Sensor

d)

Gear Motor

22.

What is the formulas in cell K15 to calculate the total of the bill?

a)

=K4+K6+K7+K8+K9+K10+K11+K12+K13+K14

b)

=SUM(K4:K14)

c)

=SUM(K4-K14)

d)

SUM(K4:K14)

23.

Which of these could be used in a spreadsheet to display your data?

a)

A bar chart

b)

A line chart

c)

A pie chart

d)

All of the above

24.

What is the result of total in this case?

a)

Cannot calculate

b)

C7

c)

15

d)

Fifteen

25.

Which of the following charts is a column chart?

a)
b)
c)
d)

None of these

26.

What is formula for E6?

a)

= sum(E2:E5)

b)

= E5 - E2

c)

= E2 * E5

d)

none of them

27.

Which is right formula?

a)

SUM(B3:B9)

b)

=B4/B2

c)

=B5xB6

d)

=SUM C1:C7

28.

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)

a)

1-2-3-4

b)

1-3-2-4

c)

1-4-3-2

d)

4-3-2-1

29.

What can you do when you want to change the size of the cell accordingly to the text’s length?

a)

Autofit

b)

Merge and center

c)

Wrap text

d)

none of them

30.

How many cells are there in this table?

a)

20

b)

10

c)

200

d)

120

31.

Where do you click to add one more cell?

a)
b)
c)
d)
32.

Match the operations with the correction symbol/icon.


Addition +

Subtraction -

Multiplication *

Division /

a)

true

b)

false

33.

Which is the cell address of the highlighted cell?

a)

4C

b)

C4

c)

B3

d)

B4