MISY 5325 — MIDTERM EXAM || MOST RECENT EXAM 2026|2027 ACTUAL
COMPLETE REAL EXAM QUESTIONS AND CORRECT ANSWERS
(VERIFIED ANSWERS) ALREADY GRADED A+ | GUARANTEED
SUCCESS!! NEWEST EXAM | JUST RELEASED!! Texas A&M University
–Corpus Christi (TAMUCC)
Which type of cell reference remains unchanged when a formula is
copied to another cell?
A. Relative reference
B. Absolute reference
C. Mixed reference
D. Circular reference
Answer: B. Absolute reference
Rationale: An absolute reference, such as $A$1, locks both the column
and row. When the formula is copied, the reference remains $A$1. A
relative reference changes according to its new location, while a mixed
reference locks either the row or column.
In Excel, what does the cell reference A1 represent?
A. Absolute reference
B. Mixed reference
C. Relative reference
D. External reference
Answer: C. Relative reference
,Rationale: A1 is a relative reference because neither the column nor
the row is locked. When a formula containing A1 is copied to another
location, Excel adjusts the reference based on the new position.
What does $A$1 represent in an Excel formula?
A. Relative reference
B. Absolute reference
C. Mixed reference D. Range reference
Answer: B. Absolute reference
Rationale: The dollar signs lock both components of the reference. $A$1
always points to column A, row 1, regardless of where the formula is
copied.
What does $A1 represent?
A. Completely relative reference
B. Completely absolute reference
C. Mixed reference with the column locked
D. Mixed reference with the row locked
Answer: C. Mixed reference with the column locked
Rationale: The $ before A locks the column, while the absence of $
before 1 leaves the row relative. Thus, when copied vertically, the row
can change, but the column remains
,A.
What does A$1 represent?
A. Mixed reference with the row locked
B. Mixed reference with the column locked
C. Absolute reference
D. Relative reference
Answer: A. Mixed reference with the row locked
Rationale: The dollar sign before 1 prevents the row from changing
when the formula is copied. The column remains relative and can
change when the formula is copied horizontally.
Which Excel function adds numbers in a specified range?
A. COUNT
B. SUM
C. AVERAGE
D. MAX
Answer: B. SUM
Rationale: SUM adds numerical values. For example, =SUM(B2:B10) adds
all numeric values in cells B2 through B10.
Which function calculates the arithmetic mean of a group of numbers?
, A. SUM
B. COUNT
C. AVERAGE
D. MEDIANIF
Answer: C. AVERAGE
Rationale: AVERAGE adds the numerical values and divides the result
by the number of numerical values included. It is commonly used to
calculate average sales, grades, costs, or other quantitative measures.
Which function returns the largest value in a range?
A. HIGH
B. MAX
C. LARGEVALUE
D. TOP
Answer: B. MAX
Rationale: MAX identifies the highest numerical value in a specified
range. For example, =MAX(C2:C20) returns the largest value in that range.
Which function returns the smallest numerical value in a range?
A. MIN
B. LOW
C. SMALLVALUE
D. BOTTOM
COMPLETE REAL EXAM QUESTIONS AND CORRECT ANSWERS
(VERIFIED ANSWERS) ALREADY GRADED A+ | GUARANTEED
SUCCESS!! NEWEST EXAM | JUST RELEASED!! Texas A&M University
–Corpus Christi (TAMUCC)
Which type of cell reference remains unchanged when a formula is
copied to another cell?
A. Relative reference
B. Absolute reference
C. Mixed reference
D. Circular reference
Answer: B. Absolute reference
Rationale: An absolute reference, such as $A$1, locks both the column
and row. When the formula is copied, the reference remains $A$1. A
relative reference changes according to its new location, while a mixed
reference locks either the row or column.
In Excel, what does the cell reference A1 represent?
A. Absolute reference
B. Mixed reference
C. Relative reference
D. External reference
Answer: C. Relative reference
,Rationale: A1 is a relative reference because neither the column nor
the row is locked. When a formula containing A1 is copied to another
location, Excel adjusts the reference based on the new position.
What does $A$1 represent in an Excel formula?
A. Relative reference
B. Absolute reference
C. Mixed reference D. Range reference
Answer: B. Absolute reference
Rationale: The dollar signs lock both components of the reference. $A$1
always points to column A, row 1, regardless of where the formula is
copied.
What does $A1 represent?
A. Completely relative reference
B. Completely absolute reference
C. Mixed reference with the column locked
D. Mixed reference with the row locked
Answer: C. Mixed reference with the column locked
Rationale: The $ before A locks the column, while the absence of $
before 1 leaves the row relative. Thus, when copied vertically, the row
can change, but the column remains
,A.
What does A$1 represent?
A. Mixed reference with the row locked
B. Mixed reference with the column locked
C. Absolute reference
D. Relative reference
Answer: A. Mixed reference with the row locked
Rationale: The dollar sign before 1 prevents the row from changing
when the formula is copied. The column remains relative and can
change when the formula is copied horizontally.
Which Excel function adds numbers in a specified range?
A. COUNT
B. SUM
C. AVERAGE
D. MAX
Answer: B. SUM
Rationale: SUM adds numerical values. For example, =SUM(B2:B10) adds
all numeric values in cells B2 through B10.
Which function calculates the arithmetic mean of a group of numbers?
, A. SUM
B. COUNT
C. AVERAGE
D. MEDIANIF
Answer: C. AVERAGE
Rationale: AVERAGE adds the numerical values and divides the result
by the number of numerical values included. It is commonly used to
calculate average sales, grades, costs, or other quantitative measures.
Which function returns the largest value in a range?
A. HIGH
B. MAX
C. LARGEVALUE
D. TOP
Answer: B. MAX
Rationale: MAX identifies the highest numerical value in a specified
range. For example, =MAX(C2:C20) returns the largest value in that range.
Which function returns the smallest numerical value in a range?
A. MIN
B. LOW
C. SMALLVALUE
D. BOTTOM
