WorksheetsMidterm 2 - Grade 5 - 2022/2023
Total questions: 23
Worksheet time: 12mins
Name
Class
Date
1.
What is your FULL name?
4 lines
2.
Your campus:
a)
Ba Tháng Hai - BTH
b)
Garden Hills
c)
Hoàng Văn Thụ - HVT
d)
Sala
e)
Sunrise
3.
Your class:
a)
5.1
b)
5.2
c)
5.3
d)
5.4
e)
5.5
4.
How many cells are selected?
a)
20
b)
10
c)
120
d)
200
5.
Which one is the correct cell address?
a)
3D
b)
D3
c)
=D3
d)
+D3
6.
How many columns are selected?
a)
20
b)
10
c)
120
d)
200
7.
Which is the cell address of the highlighted cell?
a)
4C
b)
C4
c)
B3
d)
C3
8.
What is the cell address of Total quantity?
a)
A5
b)
B4
c)
B5
d)
B1
9.
What is the cell address of the MANGO?
a)
C5
b)
3D
c)
D3
d)
2F
10.
What is displayed in cell A5?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
11.
In Excel, Columns are labelled as ______
a)
A, B, C, etc.
b)
A1, A2, etc.
c)
1,2,3 etc.
d)
1A, 2A, etc.
12.
To start a formula, we must put ... first.
a)
Number
b)
Cell Address
c)
Equal sign (=)
d)
Addition sign (+)
13.
Which is the right formula?
a)
=B4/B2
b)
SUM(B3:B9)
c)
=B5xB6
d)
=SUM C1:C7
14.
Which of the following is the correct SUM formula?
a)
=SUM(A1:A6)
b)
SUM=(A1:A6)
c)
=SUM[A1:A6]
d)
=SUM(A1-A6)
15.
What is it?
a)
CELL REFERENCE
b)
ROW
c)
COLUMN
d)
CELL
16.
In Excel, which of the following formulas is the Total legs?
a)
B2*C2
b)
=B2+C2
c)
B2+C2
d)
=C2*B2
17.
What is the result of total in this case?
a)
Cannot calculate
b)
C7
c)
15
d)
Fifteen
18.
To combine many cells into one, we use...
a)
Wrap text
b)
Format the font
c)
Merge & Center
d)
Add cell borders
19.
What is the formula in cell K15 to calculate the total of the bill?
a)
=sum(K4-K14)
b)
sum(K4:K14)
c)
=K4+K10+K12+K13+K14
d)
=SUM(K4:K14)
20.
What is it?
a)
CELL REFERENCE
b)
CELL
c)
COLUMN
d)
ROW
21.
What is it?
a)
CELL REFERENCE
b)
CELL
c)
COLUMN
d)
ROW
22.
What formula is used in cell B9?
a)
=B4+B5
b)
=SUM(B4-B7)
c)
=A4+A5+A6+A7
d)
=SUM(B4:B7)
23.
What is this button?
a)
Font Size
b)
Font Style
c)
Font Color
d)
Bold
100 %
