NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet Basics
Total questions: 20
Worksheet time: 3mins
Name
Class
Date
1.
The intersection of a row and column in a spreadsheet is called a __________.
a)
Cell
b)
Formula
c)
Label
d)
Value
2.
In spreadsheets, columns are marked with _________.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
3.
In spreadsheets, rows are marked with _____.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
4.
All spreadsheet formulas begin with which symbol?
a)
=
b)
^
c)
$
d)
#
5.
Which of the following is an example of a cell reference or cell address?
a)
C
b)
9
c)
B4
d)
=A1+A2
6.
Which symbol on the computer represents the multiplication sign?
a)
/
b)
-
c)
+
d)
*
7.
Which symbol on the computer represents the division sign?
a)
/
b)
-
c)
+
d)
*
8.
What are "words" classified as in a spreadsheet?
a)
values
b)
formulas
c)
labels
d)
cells
9.
What are "numbers" classified as in a spreadsheet?
a)
Labels
b)
Formulas
c)
Values
d)
Cells
10.
Which of the following is an example of a "function"?
a)
=A2 + A5
b)
=B7 * B9
c)
=Sum(C4:C15)
d)
= D3 / D6
11.
What are "formulas" classified as in spreadsheets?
a)
Math problems
b)
Labels
c)
Values
d)
Cells
12.
Is this a formula or a function?
=A1 + B5 + C10
=A1 + B5 + C10
a)
Formula
b)
Function
13.
Is this a formula or a function:
=Avg(C1:M1)
=Avg(C1:M1)
a)
Formula
b)
Function
14.
Is this a formula or a function:
=Sum(B3:B30)
=Sum(B3:B30)
a)
Formula
b)
Function
15.
Is this a formula or a function:
=D7 * E9
=D7 * E9
a)
Formula
b)
Function
16.
Is this a formula or a function?
=D4 / F8
=D4 / F8
a)
Formula
b)
Function
17.
Is it a formula or a function:
=Sum(E2:E25)
=Sum(E2:E25)
a)
Formula
b)
Function
18.
Gridlines are gray lines that divide the cells, rows, and columns in a spreadsheet.
a)
True
b)
False
19.
How would a telephone number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
20.
How would someone's social security number be classified in a spreadsheet?
a)
Label
b)
Value
c)
Formula
Reset
