,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.
, 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.
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EmilioOchieng. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
