NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet Basics
Total questions: 17
Worksheet time: 9mins
Name
Class
Date
1.
a file which contains one or more spreadsheets.
a)
Workbook
b)
Spreadsheet
c)
Cells
d)
Entry
2.
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
3.
individual locations on a spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
4.
Individual pieces of information typed into the spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
5.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
6.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
7.
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
8.
This classification indicates that the data has the potential to be used in calculations.
a)
Label
b)
Value
c)
Formula
d)
Function
9.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)
Function
10.
All formulas and functions begin with...
a)
=
b)
SUM
c)
Labels
d)
Text
11.
Cell value changes as the formula is copied
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
12.
Cell value remains static when copied to other locations
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
13.
Combination of an absolute and a relative cell
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
14.
This function adds the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
15.
This function determines the average of the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
16.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
17.
This function finds the lowest number in the range of cells.
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
Reset
