Where Would You Access the Manage Relationships Dialog Box to Create

question 70

Multiple Choice

Where would you access the Manage Relationships dialog box to create a data model in Excel?

• A)Relationships on the Data tab
• B)Data Models on the Analyze tab
• C)Layout on the Design tab
• D)Joins on the Data tab

---

Definitions:

WACC

The Weighted Average Cost of Capital is a method of determining a corporation's cost of capital, with each capital category being weighted in accordance with its relative proportion.

IRR

Internal Rate of Return; a financial metric used to evaluate the profitability of potential investments, representing the discount rate that makes the net present value of all cash flows equal to zero.

Cash Flow

A measure of the amount of cash and cash-equivalents being transferred into and out of a business.

Project

An individual or collaborative enterprise planned and designed to achieve a specific goal.