NEW
Font size
S
M
L
XL
WorksheetsSpreadsheets Retrieval 1
Total questions: 14
Worksheet time: 9mins
Name
Class
Date
1.
Which of these opens up a spreadsheet?
a)
b)
c)
d)
2.
What have I highlighted?
a)
A cell
b)
Data
c)
A row
d)
A column
3.
What have I highlighted?
a)
A cell
b)
Data
c)
A row
d)
A column
4.
What have I highlighted?
a)
A cell
b)
Data
c)
A row
d)
A column
5.
What have I highlighted?
a)
Data
b)
Labels
c)
Products
d)
Formulas
6.
What have I highlighted?
a)
Data
b)
Labels
c)
Products
d)
Formulas
7.
What is =C4*D4 ?
a)
A cell location
b)
A function
c)
A formula
d)
A total
8.
What is =SUM(E4:E7) ?
a)
A cell location
b)
A function
c)
A formula
d)
A column
9.
What result would =MIN(D4:D7) give me?
a)
£0.15
b)
£0.50
c)
£1.95
d)
An Error
10.
What result would =MAX(D4:D7) give me?
a)
£0.15
b)
£0.70
c)
£1.95
d)
An Error
11.
What result would =SUM(C4:C7) give me?
a)
4
b)
5
c)
20
d)
An Error
12.
What result would =COUNT(C4:C7) give me?
a)
4
b)
5
c)
20
d)
An Error
13.
What result would =AVE(C4:C7) give me?
a)
4
b)
5
c)
20
d)
An Error
14.
What result would =AVERAGE(C4:C7) give me?
a)
4
b)
5
c)
20
d)
An Error
Reset
