NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
A group of cells that can be referenced in a calculation
a)
range
b)
sorting
c)
sum
d)
average
2.
To arrange your data in a certain order, is to __________.
a)
sort
b)
organize
c)
make better
d)
help
3.
SUM and AVERAGE are types of ____________.
a)
funtions
b)
PDF
c)
Gadget
d)
Formula
4.
A funtion is an
a)
advanced formula.
b)
formula.
c)
row
d)
range
5.
Calculations consisting of numbers and mathematical operator.
a)
formula
b)
function
c)
range
d)
row
6.
A gadget is
a)
a small plug-in app
b)
Go Go Gadget
c)
Alejandro always copying
d)
diagram
7.
You can present your data graphically, using a
a)
chart
b)
print
c)
font
d)
sort
8.
To print a spreadsheet is to
a)
make a hard copy printout
b)
write ssomething
c)
save
d)
kkerw;ytnrf
9.
To collaborate with others, you can
a)
share your document with others
b)
talk
c)
print
d)
offline
10.
Where the row and column intersect
a)
cell
b)
line of intersection
c)
placeholder
d)
gadget
11.
Which way does a row go?
a)
horizontal
b)
vertical
c)
diaginol
12.
A column goes
a)
vertical
b)
horizontal
c)
diaginol
13.
the column letter, followed by the row number
a)
cell address
b)
row
c)
column
d)
cell
14.
A header is a
a)
specially formatted label
b)
the part where your brain is
15.
What performs a calculation in a spreadsheet?
a)
formula
b)
function
c)
add
d)
multiply
16.
A formula in a spreadsheet ...
a)
all of the above
b)
does a calculation
c)
shows up in the formula bar
d)
always begins with an =
17.
Which one below is NOT one of the five most-common Functions from the AutoSum Command?
a)
IF
b)
SUM
c)
MIN
d)
MAX
18.
If B3:J8 is given, what is it referring to?
a)
range of cells B3 through J8
b)
only cell J8
c)
only cells B3 and J8
d)
only cell B3
19.
At the bottom of the worksheet window which displays the name of the worksheet.
a)
sheet tab
b)
cell
c)
row
d)
worksheet
20.
In Excel, what is the result of
=1 + 3 * 2 / 2 - 1?
=1 + 3 * 2 / 2 - 1?
a)
3
b)
2
c)
4
d)
6
Reset
