NEW
Font size
S
M
L
XL
WorksheetsExcel Formulas/Functions
Total questions: 20
Worksheet time: 13mins
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.
c)
So the calculation will be done last.
2.
If the parenthesis is removed, what will 9.5% be multiplied by?
a)
D2 +D3+D4+D5
b)
D5
c)
D2
d)
None
3.
Which response best completes the following statement: A formula is used to
a)
perform calculations or other actions.
b)
find averages.
c)
Look Up data
4.
The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.
a)
total
b)
Sum
c)
percentage
5.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
6.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
7.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
8.
By default, all cell references are _________ references.
a)
Absolute
b)
Relative
9.
Unlike _________ references, _________ references do not change when copied or filled.
a)
Absolute, Relative
b)
Relative, Absolute
10.
An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.
a)
%
b)
$
c)
&
d)
#
11.
When calculating the tax per item the formula to use it
a)
= Total * sales tax%
b)
= Total +(Total * sales tax%)
12.
Generally speaking, the total from the sales tax formula represents
a)
The total of the cells (rows or columns) being calculated
b)
The total of sales tax being calculated
13.
In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.
a)
relative
b)
relational
14.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
15.
If you want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
Relative
16.
The most common way to identify a cell reference is
a)
$D2
b)
$D$2
c)
D$2
d)
D2$
17.
The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.
a)
range containing data
b)
Price of the item being looked for
18.
When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.
a)
True
b)
False
19.
The LOOKUP function in Excel is used to search one column of data and find data in the _______ row
a)
Corresponding
b)
Value
20.
The LookUp function has three arguments. First ___________ then data to search and finally, results column
a)
Value to Look Up
b)
Value to Calculate
Reset
