D388 BUS 2250
Fundamentals of Spreadsheets & Data
Presentations
Comprehensive OA Review (Qns & Ans)
2025
1. Which of the following functions is used in Excel to calculate
the Internal Rate of Return (IRR) for a series of cash flows?
- A) PMT
- B) IRR
- C) NPV
- D) RATE
ANS: B) IRR
©2024/2025
, Rationale: The IRR function is specifically built to calculate the
internal rate of return for a specified series of cash flows.
2. What is the primary purpose of using a pivot table in
spreadsheet analysis?
- A) To perform complex mathematical calculations
- B) To summarize and analyze large datasets
- C) To create graphical data presentations
- D) To automate task processes
ANS: B) To summarize and analyze large datasets
Rationale: Pivot tables are powerful tools for summarizing,
analyzing, exploring, and presenting summary data.
3. In Excel, the _____ function returns a value representing the
number of periods in an investment or loan.
- A) NPV
- B) PMT
- C) NPER
- D) RATE
ANS: C) NPER
©2024/2025
, Rationale: NPER calculates the number of periods for an
investment or loan based on periodic constant payments and a
constant interest rate.
4. Which chart type is most appropriate for displaying the trends
of stock prices over time?
- A) Pie Chart
- B) Line Chart
- C) Bar Chart
- D) Scatter Plot
ANS: B) Line Chart
Rationale: Line charts are ideal for showing trends over time,
which is important for tracking stock prices.
5. In Excel, absolute cell references are indicated by:
- A) Just the column letter
- B) Just the row number
- C) A dollar sign before both the column letter and the row
number
- D) A colon between cell references
©2024/2025
, ANS: C) A dollar sign before both the column letter and the
row number
Rationale: Absolute cell references freeze the column and row
when copying formulas.
6. When using conditional formatting, which of the following
could be a valid rule?
- A) Highlight cells that contain dates older than yesterday.
- B) Fill cells with no formatting.
- C) Create a line graph.
- D) Automate table creation.
ANS: A) Highlight cells that contain dates older than
yesterday.
Rationale: Conditional formatting is used to change cell
formatting based on specific conditions.
7. What does the VLOOKUP function perform in a spreadsheet
application?
- A) Searches for a value in a column row-wise.
- B) Searches for a value in a row column-wise.
- C) Summarizes data in a pivot table.
©2024/2025
Fundamentals of Spreadsheets & Data
Presentations
Comprehensive OA Review (Qns & Ans)
2025
1. Which of the following functions is used in Excel to calculate
the Internal Rate of Return (IRR) for a series of cash flows?
- A) PMT
- B) IRR
- C) NPV
- D) RATE
ANS: B) IRR
©2024/2025
, Rationale: The IRR function is specifically built to calculate the
internal rate of return for a specified series of cash flows.
2. What is the primary purpose of using a pivot table in
spreadsheet analysis?
- A) To perform complex mathematical calculations
- B) To summarize and analyze large datasets
- C) To create graphical data presentations
- D) To automate task processes
ANS: B) To summarize and analyze large datasets
Rationale: Pivot tables are powerful tools for summarizing,
analyzing, exploring, and presenting summary data.
3. In Excel, the _____ function returns a value representing the
number of periods in an investment or loan.
- A) NPV
- B) PMT
- C) NPER
- D) RATE
ANS: C) NPER
©2024/2025
, Rationale: NPER calculates the number of periods for an
investment or loan based on periodic constant payments and a
constant interest rate.
4. Which chart type is most appropriate for displaying the trends
of stock prices over time?
- A) Pie Chart
- B) Line Chart
- C) Bar Chart
- D) Scatter Plot
ANS: B) Line Chart
Rationale: Line charts are ideal for showing trends over time,
which is important for tracking stock prices.
5. In Excel, absolute cell references are indicated by:
- A) Just the column letter
- B) Just the row number
- C) A dollar sign before both the column letter and the row
number
- D) A colon between cell references
©2024/2025
, ANS: C) A dollar sign before both the column letter and the
row number
Rationale: Absolute cell references freeze the column and row
when copying formulas.
6. When using conditional formatting, which of the following
could be a valid rule?
- A) Highlight cells that contain dates older than yesterday.
- B) Fill cells with no formatting.
- C) Create a line graph.
- D) Automate table creation.
ANS: A) Highlight cells that contain dates older than
yesterday.
Rationale: Conditional formatting is used to change cell
formatting based on specific conditions.
7. What does the VLOOKUP function perform in a spreadsheet
application?
- A) Searches for a value in a column row-wise.
- B) Searches for a value in a row column-wise.
- C) Summarizes data in a pivot table.
©2024/2025
