1/27/26, 1:52 PM BTM 200 - Excel Chapter 2
BTM 200 - Excel Chapter 2 Actual Exam 2026-2027 Latest
version with complete questions and accurate detailed
answers \verified 100% Graded A+
1) Semi-selection or pointing
A) indicates a cells relative location from the cell containing the formula.
B) indicates a cell's specific location and the reference does not
change when you copy the formula.
C) is the process of using the mouse to select cells while building a
formula.
D) creates an Equals (=) sign.
Answer: C
2) A formula in Excel must begin with
A) a cell's specific location.
B) a cells relative location.
C) both an absolute and a relative cell reference.
D) an Equals (=) sign.
Answer: D
/ 1/18
,1/27/26, 1:52 PM BTM 200 - Excel Chapter 2
3) A relative cell reference
A) indicates a cell's specific location and the reference does not
change when you copy the formula.
B) contains both an absolute and a relative cell reference.
C) indicates a cells relative location from the cell containing the
formula; the reference changes when you copy the formula.
D) occurs when a formula directly or indirectly refers to the cell
containing the formula.
Answer: C
4) An absolute cell reference
A) causes a potential error.
B) indicates a cell's specific location and the reference does not
change when you copy the formula.
C) occurs when a formula directly or indirectly refers to the cell
containing the formula.
D) contains both an absolute and a relative cell reference.
Answer: B
5) A mixed cell reference
A) occurs when a formula directly or indirectly refers to the cell
containing the formula.
B) causes a potential error.
C) contains absolute or relative cell references, but not both.
D) contains both an absolute and a relative cell reference.
Answer: D
/ 2/18
, 1/27/26, 1:52 PM BTM 200 - Excel Chapter 2
6) A circular reference
A) is a predefined formula that performs a calculation.
B) is a rule that governs the structure and components for functions.
C) occurs when a formula directly or indirectly refers to the cell
containing the formula.
D) is an input such as a cell reference or a value needed to complete a
function.
Answer: C
7) Excel displays a green arrow in the top left corner of a cell if it detects a
A) cell reference or a value.
B) rule that governs components of functions.
C) potential error.
D) predefined formula that performs a calculation.
Answer: C
8) A function is a
A) predefined formula that performs a calculation.
B) cell reference or a value.
C) list of values and defined names as you enter a spreadsheet.
D) set of rules that govern the structure and components for a formula.
Answer: A
/ 3/18
BTM 200 - Excel Chapter 2 Actual Exam 2026-2027 Latest
version with complete questions and accurate detailed
answers \verified 100% Graded A+
1) Semi-selection or pointing
A) indicates a cells relative location from the cell containing the formula.
B) indicates a cell's specific location and the reference does not
change when you copy the formula.
C) is the process of using the mouse to select cells while building a
formula.
D) creates an Equals (=) sign.
Answer: C
2) A formula in Excel must begin with
A) a cell's specific location.
B) a cells relative location.
C) both an absolute and a relative cell reference.
D) an Equals (=) sign.
Answer: D
/ 1/18
,1/27/26, 1:52 PM BTM 200 - Excel Chapter 2
3) A relative cell reference
A) indicates a cell's specific location and the reference does not
change when you copy the formula.
B) contains both an absolute and a relative cell reference.
C) indicates a cells relative location from the cell containing the
formula; the reference changes when you copy the formula.
D) occurs when a formula directly or indirectly refers to the cell
containing the formula.
Answer: C
4) An absolute cell reference
A) causes a potential error.
B) indicates a cell's specific location and the reference does not
change when you copy the formula.
C) occurs when a formula directly or indirectly refers to the cell
containing the formula.
D) contains both an absolute and a relative cell reference.
Answer: B
5) A mixed cell reference
A) occurs when a formula directly or indirectly refers to the cell
containing the formula.
B) causes a potential error.
C) contains absolute or relative cell references, but not both.
D) contains both an absolute and a relative cell reference.
Answer: D
/ 2/18
, 1/27/26, 1:52 PM BTM 200 - Excel Chapter 2
6) A circular reference
A) is a predefined formula that performs a calculation.
B) is a rule that governs the structure and components for functions.
C) occurs when a formula directly or indirectly refers to the cell
containing the formula.
D) is an input such as a cell reference or a value needed to complete a
function.
Answer: C
7) Excel displays a green arrow in the top left corner of a cell if it detects a
A) cell reference or a value.
B) rule that governs components of functions.
C) potential error.
D) predefined formula that performs a calculation.
Answer: C
8) A function is a
A) predefined formula that performs a calculation.
B) cell reference or a value.
C) list of values and defined names as you enter a spreadsheet.
D) set of rules that govern the structure and components for a formula.
Answer: A
/ 3/18
