NEW
Font size
S
M
L
XL
WorksheetsNGHS Y7 SPREADSHEET 1
Total questions: 14
Worksheet time: 14mins
Name
Class
Date
1.
The intersection of a row and a column and is identified by a cell reference
a)
cell range
b)
cell
c)
cell reference
d)
active cell
2.
A rectangular group of cells treated as a unit is a spreadsheet
a)
cell reference
b)
column
c)
range
d)
row
3.
All functions and formulas begin with which symbol?
a)
SUM
b)
(
c)
A1
d)
=
4.
What is the FUNCTION that will add cells D14, D15, D16, D17, D18, and D19?
a)
-sum(D14:D19)
b)
=D14:d19
c)
=sum(D14-D19)
d)
=D14+D15+D16+D17+D18+D19
5.
In a spreadsheet, "=max(b3:b10)" is called a
a)
function
b)
cell range
c)
formula
d)
value
6.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
7.
A cell range is indicated by which symbol?
a)
:
b)
-
c)
/
d)
*
8.
The column letter followed by the row number
a)
range
b)
cell reference
c)
value
d)
function
9.
A horizontal line of data in a spreadsheet is called
a)
value
b)
column
c)
row
d)
label
10.
A vertical line of data in a spreadsheet is called
a)
row
b)
value
c)
label
d)
column
11.
Which is an example of a cell reference is a spreadsheet?
a)
6C
b)
B9
c)
45
d)
fall
12.
Sharon want to find the average of cells between b2 and c12. Which function should she use?
a)
=average(b2:b12)
b)
averageb2:b12
c)
average(b2:b12)
d)
=average(b2-b12)
13.
John wants to offer sale items on products with the lowest sales. The easiest way to find the products is to use which function?
a)
sum
b)
max
c)
average
d)
min
14.
A teacher wants to find the student with the highest grade on the midterm exam. She should use.
a)
max
b)
average
c)
min
d)
sum
Reset
