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:

Focused

Concentrating on a specific task or goal with attention and effort.

Flexible

This attribute refers to the ability to be easily modified or adapted to new conditions, in contexts ranging from work hours to product design.

Near-term Activities

Tasks or projects that are scheduled to be completed or take place in the immediate future.

Overall Strategies

Comprehensive approaches taken by businesses to achieve their long-term objectives and ensure growth.