NEW
Font size
S
M
L
XL
WorksheetsExcel
Total questions: 24
Worksheet time: 16mins
Name
Class
Date
1.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
2.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
3.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
4.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
5.
In an excel forumula it means divide
a)
Forwardslash
b)
Backwards
c)
Skip
d)
Multiply
6.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
7.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
8.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
9.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
10.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
11.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
12.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
13.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
14.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
15.
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)
16.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
17.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
18.
A mathematical operation is called a _____.
a)
formula
b)
range
c)
label
d)
graph
19.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
20.
Highlighting items within a spreadsheet is called selecting.
a)
True
b)
False
21.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
22.
Which of the following is an example of a "function"?
a)
=A2 + A5
b)
=B7 * B9
c)
=Sum(C4:C15)
d)
= D3 / D6
23.
Is this a formula or a function:
=Avg(C1:M1)
=Avg(C1:M1)
a)
Formula
b)
Function
24.
Is this a formula or a function:
=D7 * E9
=D7 * E9
a)
Formula
b)
Function
Reset
