BIS275 Advanced Excel (DeVry) Final Exam Review 2025 (Qns & Ans

BIS275

Advanced Excel

Final Exam Review (Qns & Ans)

2025



1. Which of the following functions is used to return the position
of a value within a range in Excel?
A. MATCH
B. LOOKUP
C. INDEX
D. OFFSET
ANS: A. MATCH



©2025

, Rationale: The `MATCH` function returns the relative
position of a value within a specified range, which is useful in
dynamic referencing.


2. What is the purpose of the Excel feature "Solver"?
A. To track changes in a workbook
B. To analyze scenarios using predefined parameters
C. To find the optimal solution for a problem using constraints
D. To automatically sort large datasets
ANS: C. To find the optimal solution for a problem using
constraints
Rationale: Solver is a tool for optimization tasks, such as
linear programming, by adjusting variables and adhering to
constraints.


3. Which type of cell reference changes when a formula is
copied to another cell?
A. Relative
B. Absolute
C. Mixed
D. Static
ANS: A. Relative

©2025

, Rationale: A relative reference adjusts based on its new
location when copied.


---


Fill-in-the-Blank Questions


4. The function _______ is used to calculate the internal rate of
return (IRR) for a series of cash flows.
ANS: IRR()
Rationale: The `IRR()` function computes the discount rate at
which the net present value (NPV) of cash flows becomes zero.


5. In a data table, the _______ function is used to calculate the
average of numerical values while ignoring empty cells.
ANS: AVERAGE()
Rationale: The `AVERAGE()` function calculates the mean
of a range, disregarding blank cells.


---


True/False Questions
©2025