WorksheetsJSS3
Total questions: 25
Worksheet time: 23mins
Name
Class
Date
1.
THE __________ FUNCTION IS USED TO FIND THE MAXIMUM VALUE FROM A SET OF VALUES
a)
MAX( )
b)
MIN( )
2.
A ___________ IS AN EQUATION TO SOLVE A MATHMATICAL PROBLEM.
a)
FUNCTION
b)
FORMULA
c)
CELL
d)
ROW
3.
A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________
a)
COLUMN
b)
ROW
c)
RANGE
d)
FORMULA
4.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
5.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
6.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
7.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
8.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
9.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
10.
A formula that automatically adds up a column of numbers is called __________.
a)
cell
b)
auto sum
c)
graph
d)
value
11.
A mathematical operation is called a _____.
a)
formula
b)
range
c)
label
d)
graph
12.
What do all formulas begin with?
a)
%
b)
[ ]
c)
=
d)
:
13.
What symbol do we use for multiplication in a Spreadsheet program?
a)
/
b)
=
c)
^
d)
*
14.
What symbol do we use for addition in a Spreadsheet program?
a)
/
b)
+
c)
=
d)
*
15.
What symbol do we use for subtraction in a Spreadsheet program?
a)
/
b)
*
c)
+
d)
-
16.
What symbol do we use for division in a Spreadsheet program?
a)
/
b)
*
c)
+
d)
=
17.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
18.
Which of the following is a formula that will add cells C9 and C10?
a)
=C9+C10
b)
C9+C10
c)
=C9:C10
d)
=C9*C10
19.
Which of the following is a formula that will subtract cell B4 from cell B3?
a)
=3-4
b)
=B3-B4
c)
=B3*B4
d)
B3-B4
20.
What are the individual rectangles on a worksheet called?
a)
Rows
b)
Columns
c)
Cells
d)
Formulae
21.
A vertical line of cells in a spreadsheet is a what?
a)
Row
b)
Column
22.
A horizontal line of cells in a spreadsheet is a what?
a)
Row
b)
Column
23.
A spreadsheet
a)
is a rectangle where a column and a row meet
b)
goes up and down on the spreadsheet screen
c)
data type that will calculate a result. always starts with an "=" sign
d)
is software that processes and does calculations on the data entered by the user
24.
Columns
a)
is a rectangle where a column and a row meet
b)
go up and down on the spreadsheet screen
c)
data type that will calculate a result. always starts with an "=" sign
d)
is software that processes and does calculations on the data entered by the user
25.
A cell is
a)
a rectangle where a column and a row meet
b)
go up and down on the spreadsheet screen
c)
data type that will calculate a result. always starts with an "=" sign
d)
software that processes and does calculations on the data entered by the user
100 %
