WorksheetsExcel Functions & Formulas Re-Cap
Total questions: 10
Worksheet time: 8mins
Name
Class
Date
1.
All formulas must begin with
a)
equal sign
b)
plus sign
c)
minus sign
d)
asterisk
2.
What symbol means to multiply?
a)
equal sign
b)
asterisk
c)
diagonal
d)
minus
3.
What symbol means to divide?
a)
equal sign
b)
asterisk
c)
diagonal
d)
minus
4.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A2+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
5.
Formulas cannot contain spaces.
a)
True
b)
False
6.
Cells that run from the top to bottom (VERTICALLY) in a worksheet and are identified by letters
a)
active cell
b)
cell
c)
column
d)
name box
7.
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
a)
external reference
b)
absolute cell reference
c)
cell reference
d)
constant
8.
Which formulas will add up the numbers for a given range?
a)
COUNT
b)
SUM
c)
AVERAGE
d)
MIN
9.
What is the correct formula to find the Total Salary for Mr. Edwards?
a)
=SUM(B10:D10)
b)
B10+D10
c)
=AVERAGE(B10-D10)
d)
D10..B10
10.
=A1+5
Is this a function or a formula?
Is this a function or a formula?
a)
Formula
b)
Function
100 %
