NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet
Total questions: 72
Worksheet time: 43mins
Name
Class
Date
1.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
2.
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)
3.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
4.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
5.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
6.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
7.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
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.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
11.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
12.
THE __________ FUNCTION IS USED TO FIND THE MAXIMUM VALUE FROM A SET OF VALUES
a)
MAX( )
b)
MIN( )
13.
A ___________ IS AN EQUATION TO SOLVE A MATHMATICAL PROBLEM.
a)
FUNCTION
b)
FORMULA
c)
CELL
d)
ROW
14.
A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________
a)
COLUMN
b)
ROW
c)
RANGE
d)
FORMULA
15.
A SELECTED CELL IS HIGHLIGHTED IN THE SHEET AND IT IS CALLED _________
a)
CELL
b)
SELECTED RANGE
c)
ACTIVE CELL
d)
NONE
16.
A row is a vertical reference in a spreadsheet.
a)
True
b)
False
17.
Numbers identified in spreadsheets that are used in calculations are called _____.
a)
gridlines
b)
selecting
c)
values
d)
graph
18.
A mathematical operation is called a _____.
a)
formula
b)
range
c)
label
d)
graph
19.
Text used in a spreadsheet and usually creates titles is a called a _____.
a)
range
b)
auto sum
c)
row
d)
label
20.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
21.
A group of cells is called a _____.
a)
graph
b)
selecting
c)
range
d)
cell
22.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
23.
Highlighting items within a spreadsheet is called selecting.
a)
True
b)
False
24.
Horizontal and vertical lines in a spreadsheet are called ____.
a)
rows
b)
graphs
c)
labels
d)
gridlines
25.
A formula that automatically adds up a column of numbers is called __________.
a)
cell
b)
auto sum
c)
graph
d)
value
26.
Each box on a spreadsheet is called a ...
a)
row
b)
column
c)
cell
d)
box
27.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
28.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
29.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
30.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
31.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
32.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
33.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
34.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color
35.
Your best friend in the computer lab is...
a)
Mrs. Martin
b)
delete
c)
redo
d)
undo
36.
In spreadsheets, rows are marked with _____.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
37.
All spreadsheet formulas begin with which symbol?
a)
=
b)
^
c)
$
d)
#
38.
Which of the following is an example of a cell reference or cell address?
a)
C
b)
9
c)
B4
d)
=A1+A2
39.
Which symbol on the computer represents the multiplication sign?
a)
/
b)
-
c)
+
d)
*
40.
Which symbol on the computer represents the division sign?
a)
/
b)
-
c)
+
d)
*
41.
What are "words" classified as in a spreadsheet?
a)
values
b)
formulas
c)
labels
d)
cells
42.
Which of the following is an example of a "function"?
a)
=A2 + A5
b)
=B7 * B9
c)
=Sum(C4:C15)
d)
= D3 / D6
43.
What are "formulas" classified as in spreadsheets?
a)
Math problems
b)
Labels
c)
Values
d)
Cells
44.
What are "numbers" classified as in a spreadsheet?
a)
Labels
b)
Formulas
c)
Values
d)
Cells
45.
The intersection of a row and column in a spreadsheet is called a __________.
a)
Cell
b)
Formula
c)
Label
d)
Value
46.
In spreadsheets, columns are marked with _________.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
47.
Is this a formula or a function?
=A1 + B5 + C10
=A1 + B5 + C10
a)
Formula
b)
Function
48.
Is this a formula or a function:
=Avg(C1:M1)
=Avg(C1:M1)
a)
Formula
b)
Function
49.
Is this a formula or a function:
=Sum(B3:B30)
=Sum(B3:B30)
a)
Formula
b)
Function
50.
Is this a formula or a function:
=D7 * E9
=D7 * E9
a)
Formula
b)
Function
51.
Is this a formula or a function?
=D4 / F8
=D4 / F8
a)
Formula
b)
Function
52.
Is it a formula or a function:
=Sum(E2:E25)
=Sum(E2:E25)
a)
Formula
b)
Function
53.
Gridlines are gray lines that divide the cells, rows, and columns in a spreadsheet.
a)
True
b)
False
54.
How would a telephone number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
55.
How would someone's social security number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
56.
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
57.
individual locations on a spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
58.
Individual pieces of information typed into the spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
59.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
60.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
61.
Classification used for cells that contain text or for numbers that will not be used in calculations
a)
Label
b)
Value
c)
Formula
d)
Function
62.
This classification indicates that the data has the potential to be used in calculations.
a)
Label
b)
Value
c)
Formula
d)
Function
63.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)
Function
64.
All formulas and functions begin with...
a)
=
b)
SUM
c)
Labels
d)
Text
65.
Cell value changes as the formula is copied
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
66.
Cell value remains static when copied to other locations
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
67.
Combination of an absolute and a relative cell
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
68.
This function adds the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
69.
This function determines the average of the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
70.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
71.
This function finds the lowest number in the range of cells.
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
72.
a file which contains one or more spreadsheets.
a)
Workbook
b)
Spreadsheet
c)
Cells
d)
Entry
Reset
