Critical Thinking Questions Case 6-2

question 48

Multiple Choice

Critical Thinking Questions Case 6-2
Your supervisor, the accounting manager, asks you to insert the current month's sales estimates by product, which is located in an Excel worksheet, into a sales report you are creating in Publisher to send to each manager electronically.
Which of the following integration methods should you use to allow each sales manager to change the estimates for his or her department in a what-if analysis using the worksheet object in the sales report?

• A) copy and paste
• B) embedding
• C) linking
• D) attaching

---

Definitions:

Future Cash Flows

The estimated amount of money to be received or paid out over a specified future period by an investment or business operation.

Stockbroker

A professional who buys and sells stocks and other securities on behalf of clients in exchange for a fee or commission.

Securities

Financial instruments that represent an ownership position in a publicly traded corporation (stock), a creditor relationship with a governmental body or a corporation (bond), or rights to ownership as represented by an option.

Collateral

An asset that a borrower offers to a lender as security for a loan.