NEW
Font size
S
M
L
XL
WorksheetsMS-Excel Level 3 (Final)
Total questions: 11
Worksheet time: 6mins
Name
Class
Date
1.
A function that counts numbers, text and non-blank cellls
a)
COUNT
b)
COUNTA
c)
COUNTIF
d)
SUM
2.
Counting occurrences of "AB" in cells A1:A10
a)
COUNT(A1:A10,"AB")
b)
COUNTA(A1:A10,"AB")
c)
COUNTIF(A1:A10,"AB")
d)
SUM(A1:A10,"AB")
3.
Given =IF(A1>=75,"Distinction","Pass"). When cell A1 contains the value 80.
What will the formula return?
a)
50
b)
75
c)
Distinction
d)
Pass
4.
To use the IF function given that fever is above 38 degrees.
a)
=IF(A1>38,"Fever")
b)
=IF(A1>38,"Normal")
c)
=IF(A1>38,"Fever","Normal")
d)
=IF(A1<38,"Fever","Normal")
5.
To select 2 columns that are NOT next to each other, which keyboard key must be used?
a)
Alt
b)
Ctrl
c)
Enter
d)
Shift
6.
A chart that contains both a line chart and column chart
a)
Add Chart
b)
Combine Chart
c)
Combination Chart
d)
Double Chart
7.
A function that generates the both the present date and time in the same cell
a)
DATETIME()
b)
NOW()
c)
PRESENT()
d)
TODAY()
8.
To automatically generate a random 3 digit number
a)
RANDBETWEEN(1,999)
b)
RANDBETWEEN(1,1000)
c)
RANDBETWEEN(100,900)
d)
RANDBETWEEN(100,999)
9.
Cell A1 contains S123ABC, To return "123" ...
a)
LEFT(123)
b)
LEFT(A1,2,3)
c)
MID(123)
d)
MID(A1,2,3)
10.
Cell A1 contains S123ABC, To return the text length in A1.
a)
CELL(A1)
b)
LEN(A1)
c)
LEFT(A1)
d)
MID(A1)
11.
Cell A1 contains S123ABC, To return "S"
a)
CELL(A1,1)
b)
LEN(A1,1)
c)
LEFT(A1,1)
d)
MID(A1,1)
Reset
