Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
A constant (text or number) or cell reference used in a formula.
Adjusts to its new location when copied or moved.
A symbol that indicates the type of calculation to perform.
Does not change when copied or moved to a new cell.
Cell reference that contain both relative and absolute references.
Responses:
Relative cell reference
Operand
Operator
Mixed cell reference
Absolute cell reference
Correct Answer:
Premises:
Responses:
A constant (text or number) or cell reference used in a formula.
Adjusts to its new location when copied or moved.
A symbol that indicates the type of calculation to perform.
Does not change when copied or moved to a new cell.
Cell reference that contain both relative and absolute references.
Premises:
A constant (text or number) or cell reference used in a formula.
Adjusts to its new location when copied or moved.
A symbol that indicates the type of calculation to perform.
Does not change when copied or moved to a new cell.
Cell reference that contain both relative and absolute references.
Responses:
Related Questions
Q1: The formula = E6/4 is an example
Q8: Consider the formula =B3+5. In this formula,
Q10: To switch to manual calculation, click the
Q15: To make all formulas visible, click the
Q23: The results of the calculation appear in
Q24: When you need to edit a worksheet
Q36: The sequence used to calculate the value
Q39: Please briefly describe these three summary calculation
Q42: When the formula =$A$3+$A$4 in cell A5
Q45: COUNT CELLS determine how many entries are