WorksheetsExcel Formula Practice
Total questions: 13
Worksheet time: 7mins
Name
Class
Date
1.
In the picture, why is D2 through D5 placed in paranthesis?
a)
So Excel knows to total the cells before performing the next operation.
b)
So the total of the cells can be multiplied rather than added.
2.
Which response best completes the following statement: A formula is used to
a)
perform calculations or other actions.
b)
find averages.
3.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
4.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
5.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
6.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
7.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
8.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
9.
_____ are vertical.
a)
Rows
b)
Columns
10.
________ are horizontal
a)
Rows
b)
Columns
11.
Choose a formula that adds the values in A3 and A4
a)
=A3/A4
b)
=A3-A4
c)
=A3+A4
12.
Choose a formula that subtracts the values in A4 from A3
a)
=A3-27
b)
=A3-A4
c)
=A3+A4
13.
Choose a formula that divides the values in A3 by 27
a)
=A3^27
b)
=A3/27
c)
=A3*27
100 %
