Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Test For Beginner

Total questions: 10

Worksheet time: 3mins

Name
Class
Date
1.

=SUM(C4:F4)

a)

30

b)

31

c)

32

d)

36

2.

=AVERAGE(C7:F7)

a)

7,3

b)

8,1

c)

8,5

d)

9,0

3.

=D13*F13

a)

60

b)

42

c)

62,5

d)

169

4.

=SUMIF(A:A;A4;C:C)

a)

32

b)

24

c)

36

d)

26

5.

=C12+D12+E12+F12

a)

28

b)

29

c)

30

d)

31

6.

=COUNTIF(C4:F12;10)

a)

6

b)

7

c)

8

d)

10

7.

=MAX(D4:D12)

a)

7

b)

8

c)

9

d)

10

8.

=COUNT(C4:C12)

a)

6

b)

7

c)

8

d)

9

9.

=D4-E4*2

a)

2

b)

-5

c)

0

d)

-2

10.

=IF(D10=7;E8;F9)

a)

6

b)

7

c)

8

d)

9