Which Microsoft Excel Function Can Be Used to Join Data

question 9

Multiple Choice

Which Microsoft Excel function can be used to join data tables together using a common element?

• A) =VLOOKUP()
• B) =SUMIF()
• C) =JOINIF()
• D) =FIND()

---

Definitions:

Business Transaction

Any activity or event that involves the exchange of goods, services, or funds between two or more parties that affects the financial position of a business.

Note

A written agreement or promissory note where one party agrees to pay another under specified conditions, often used in reference to loans or debts.

Assets

Resources owned by a business or individual deemed to have economic value and expected to provide future benefits.

Liabilities

Financial obligations or debts a company owes to others, due to be paid in the future.