Portia Wants to Create a Calculated Measure in Excel

question 12

Multiple Choice

Portia wants to create a calculated measure in Excel.To do this,she creates a PivotChart report using the data stored in an Analysis Services cube.Next,she clicks on a tab "A" and then in group "B," she chooses OLAP Tools > MDX Calculated Measure to open the New Calculated Measure dialog box.What can A and B be in the procedure?

• A) A-Design tab,B-Data group
• B) A-Developer tab,B-Code group
• C) A-Analyze tab,B-Calculations group
• D) A-Design tab,B-Table Style Options group

---

Definitions:

Security for a Loan

Collateral or assets pledged by a borrower to secure a loan, providing a lender assurance of repayment.

Blanket Liens

A security interest covering nearly all types of collateral owned by the debtor.

Compensating Balance

A minimum balance that must be maintained in a bank account, often required by banks in return for loans or as a condition for obtaining certain services.

Effective Annual Cost

This term refers to the total cost of borrowing on an annual basis, including interest and any fees, taking compounding into account.