NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet
Total questions: 15
Worksheet time: 16mins
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.
A SELECTED CELL IS HIGHLIGHTED IN THE SHEET AND IT IS CALLED _________
a)
CELL
b)
SELECTED RANGE
c)
ACTIVE CELL
d)
NONE
5.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
6.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
7.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
8.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
9.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
10.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
11.
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)
12.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
13.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
14.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
15.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
Reset
