IS 160
Spreadsheets
LATEST MIDTERMS REVIEW
Q&S
©2024/2025
,1. Multiple Choice: What function would you use to combine text
from different cells into one cell?
a) TEXTJOIN
b) CONCATENATE
c) MERGE
d) COMBINE
Answer: b) CONCATENATE. Rationale: CONCATENATE is
used to combine text from multiple cells into one cell in
spreadsheets.
2. Fill-in-the-Blank: The ______ function is used to calculate the
internal rate of return for a series of cash flows.
Answer: IRR. Rationale: The IRR function is used in
spreadsheets to calculate the internal rate of return for a series of
cash flows, which is essential in financial analysis.
3. True/False: The VLOOKUP function can be used to search for
a value in the first column of a table and return a value in the
same row from a specified column.
Answer: True. Rationale: VLOOKUP is designed to vertically
search the first column of a table for a key and return the value
from a specified column in the same row.
©2024/2025
, 4. Multiple Response: Which of the following functions can be
used for error handling in spreadsheets? (Select all that apply)
a) IFERROR
b) ISERROR
c) ONERROR
d) ERRORCHECK
Answers: a) IFERROR, b) ISERROR. Rationale: IFERROR
and ISERROR are both functions used in spreadsheets to handle
errors by specifying a return value or action if an error is
encountered.
5. Multiple Choice: To conditionally format cells based on a
certain criteria, which feature would you use?
a) Conditional Formatting
b) Format Painter
c) Cell Styles
d) Data Validation
Answer: a) Conditional Formatting. Rationale: Conditional
Formatting is used to automatically apply formatting to cells that
meet specific criteria in spreadsheets.
6. Fill-in-the-Blank: A ______ is a pre-defined calculation used to
perform complex tasks in spreadsheets.
©2024/2025
Spreadsheets
LATEST MIDTERMS REVIEW
Q&S
©2024/2025
,1. Multiple Choice: What function would you use to combine text
from different cells into one cell?
a) TEXTJOIN
b) CONCATENATE
c) MERGE
d) COMBINE
Answer: b) CONCATENATE. Rationale: CONCATENATE is
used to combine text from multiple cells into one cell in
spreadsheets.
2. Fill-in-the-Blank: The ______ function is used to calculate the
internal rate of return for a series of cash flows.
Answer: IRR. Rationale: The IRR function is used in
spreadsheets to calculate the internal rate of return for a series of
cash flows, which is essential in financial analysis.
3. True/False: The VLOOKUP function can be used to search for
a value in the first column of a table and return a value in the
same row from a specified column.
Answer: True. Rationale: VLOOKUP is designed to vertically
search the first column of a table for a key and return the value
from a specified column in the same row.
©2024/2025
, 4. Multiple Response: Which of the following functions can be
used for error handling in spreadsheets? (Select all that apply)
a) IFERROR
b) ISERROR
c) ONERROR
d) ERRORCHECK
Answers: a) IFERROR, b) ISERROR. Rationale: IFERROR
and ISERROR are both functions used in spreadsheets to handle
errors by specifying a return value or action if an error is
encountered.
5. Multiple Choice: To conditionally format cells based on a
certain criteria, which feature would you use?
a) Conditional Formatting
b) Format Painter
c) Cell Styles
d) Data Validation
Answer: a) Conditional Formatting. Rationale: Conditional
Formatting is used to automatically apply formatting to cells that
meet specific criteria in spreadsheets.
6. Fill-in-the-Blank: A ______ is a pre-defined calculation used to
perform complex tasks in spreadsheets.
©2024/2025
