MOAC – Excel Lesson 8Formulas & FunctionsKnowledge Assessments
Name: ______Date: ______Pd: ______
Matching -- Match each vocabulary term with its definition.
1
MOAC – Excel Lesson 8Formulas & FunctionsKnowledge Assessments
a. absolute cell reference
b. constant
c. external reference
d. formula
e. function
f. operand
g. mathematical operator
h. relative cell reference
i. mixed reference
j. scope
1
MOAC – Excel Lesson 8Formulas & FunctionsKnowledge Assessments
_____1.In formulas, cell references that change in relation to the location where they are moved or copied.
_____2.A predefined formula that performs calculations on values in a worksheet.
_____3.The components of a formula that identify the values to be used in the calculation.
_____4.Numbers or text values entered directly into a formula. These values are not calculated.
_____5.In a formula, a reference to a specifi c cell that does not change when the formula is copied or moved.
_____6.A reference to a cell or range on a worksheet in another Excel workbook.
_____7.An equation that performs calculations on values in a worksheet.
_____8.The formula component that specifies what calculations are to be performed.
_____9.A cell reference in which the column is absolute and the row is relative or vice versa.
____10.The location within which a name is recognized without qualification.
Multiple Choice -- Select the best response for the following statements. Place the correct answer on the blank provided.
_____1. Which of the following is not a mathematical operator?
a. _
b. _
c. _
d. *
_____2. Which function automatically totals cells directly above or to the left of the cell containing the formula?
a. COUNT
b. AutoFill
c. AutoSum
d. SUM
_____3. Which of the following shows a formula for an external reference?
a. _Sum(Expenses)
b. _Sum(B6:b10)
c. _Expenses!B7
d. _‘[Financial Obligations.xlsx]Sheet1’!$B$2
41
_____4. Which of the following shows a formula for a reference to another worksheet in the same workbook?
a. _Sum(Expenses)
b. _Sum(B6:b10)
c. _Expenses!B7
d. _‘[Financial Obligations.xlsx]Sheet1’!$B$2
_____5. Which of the following shows a formula that references a named range?
a. _Sum(Expenses)
b. _Sum(B6:b10)
c. _Expenses!B7
d. _‘[Financial Obligations.xlsx]Sheet1’!$B$2
_____6. Which character designates a cell reference as absolute?
a. ˆ
b. @
c. $
d. #
_____7. The COUNTA function
a. counts the number of cells in a range that contain values.
b. counts all cells in the range.
c. counts the number of cells that are not empty.
d. counts the text entries in the range.
_____8. The COUNT function is an example of a ______function.
a. logical
b. financial
c. statistical
d. text
_____9. Which of the following is an acceptable name for a named range?
a. C
b. C_Contracts
c. C/Contracts
d. C Contracts
_____10. Which of the following statements accurately describes the default selection for AutoSum?
a. By default, AutoSum totals all entries above the cell in which the formula is located.
b. By default, AutoSum calculates the total from the active cell to the first nonnumeric cell.
c. AutoSum does not have a default selection.
d. You must make the selection before clicking AutoSum.
1