WorksheetsSpreadsheet Basics
Total questions: 16
Worksheet time: 12mins
Name
Class
Date
1.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
2.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
3.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
4.
The letter at the top of each column is called a:
a)
cell reference
b)
row header
c)
column header
d)
range
5.
The number to the left of a row is called a:
a)
cell reference
b)
column header
c)
row header
d)
range
6.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
7.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
8.
Horizontal and vertical lines in a spreadsheet are called ____.
a)
rows
b)
graphs
c)
labels
d)
gridlines
9.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
10.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
11.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
12.
Multiple pages in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
13.
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)
14.
Which is an example of a cell reference is a spreadsheet?
a)
6C
b)
B9
c)
45
d)
fall
15.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
16.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
100 %
