NEW
Font size
S
M
L
XL
Worksheetsspreadsheet
Total questions: 38
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.
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.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
9.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
10.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
11.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
12.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
13.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
14.
Each box on a spreadsheet is called a ...
a)
row
b)
column
c)
cell
d)
box
15.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
16.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
17.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
18.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color
19.
Your best friend in the computer lab is...
a)
Mrs. Martin
b)
delete
c)
redo
d)
undo
20.
Which of the following is an example of a cell reference or cell address?
a)
C
b)
9
c)
B4
d)
=A1+A2
21.
Which symbol on the computer represents the multiplication sign?
a)
/
b)
-
c)
+
d)
*
22.
Which symbol on the computer represents the division sign?
a)
/
b)
-
c)
+
d)
*
23.
What are "words" classified as in a spreadsheet?
a)
values
b)
formulas
c)
labels
d)
cells
24.
Which of the following is an example of a "function"?
a)
=A2 + A5
b)
=B7 * B9
c)
=Sum(C4:C15)
d)
= D3 / D6
25.
What are "formulas" classified as in spreadsheets?
a)
Math problems
b)
Labels
c)
Values
d)
Cells
26.
Is this a formula or a function?
=A1 + B5 + C10
=A1 + B5 + C10
a)
Formula
b)
Function
27.
Is this a formula or a function:
=Avg(C1:M1)
=Avg(C1:M1)
a)
Formula
b)
Function
28.
Is this a formula or a function:
=Sum(B3:B30)
=Sum(B3:B30)
a)
Formula
b)
Function
29.
Is this a formula or a function:
=D7 * E9
=D7 * E9
a)
Formula
b)
Function
30.
Is this a formula or a function?
=D4 / F8
=D4 / F8
a)
Formula
b)
Function
31.
Is it a formula or a function:
=Sum(E2:E25)
=Sum(E2:E25)
a)
Formula
b)
Function
32.
Gridlines are gray lines that divide the cells, rows, and columns in a spreadsheet.
a)
True
b)
False
33.
How would a telephone number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
34.
How would someone's social security number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
35.
A formula that automatically adds up a column of numbers is called __________.
a)
cell
b)
auto sum
c)
graph
d)
value
36.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
37.
Highlighting items within a spreadsheet is called selecting.
a)
True
b)
False
38.
Horizontal and vertical lines in a spreadsheet are called ____.
a)
rows
b)
graphs
c)
labels
d)
gridlines
Reset
