NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet Basics
Total questions: 26
Worksheet time: 14mins
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 is an example of a cell reference is a spreadsheet?
a)
6C
b)
B9
c)
45
d)
fall
14.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
15.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
16.
Text, symbols, dates, or numbers not used in a calculation
a)
Value
b)
Label
c)
Function
d)
Formula
17.
A number that is entered into a spreadsheet and used for calculations
a)
Value
b)
Label
c)
Function
d)
Formula
18.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
19.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
20.
Sum, average, count, maximum value, and minimum value are examples of what?
a)
a. Formulas
b)
b. Calculations
c)
c. Functions
d)
d. Spreadsheet data
21.
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
a)
a. Formulas
b)
b. Conditional formatting
c)
c. Functions
d)
d. Spreadsheet data
22.
Which of these are not an example of how MS Excel can be used?
a)
a. Budget
b)
b. Research Paper
c)
c. Track sales
d)
d. Track Inventory
23.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
24.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d. Average
25.
A spreadsheet program is used to store data in:
a)
a. a database.
b)
b. a text document.
c)
c. rows and columns.
d)
d. letters and numbers.
26.
Which of the following is an example of a cell reference?
a)
a. Column C
b)
b. =SUM
c)
c. Row 1
d)
d. A5
Reset
