Marcos Has a PivotTable That Shows Revenue by Quarter

question 97

Multiple Choice

Marcos has a PivotTable that shows revenue by quarter. He wants to calculate the differences between the revenue for one quarter and another. What can he do?

• A) Ungroup the date field.
• B) Create a calculated item.
• C) Create a measure.
• D) Change the summary function to SUMGROUP.

---

Definitions:

Virtualization Support

A BIOS/UEFI option to enable or disable the capability of the computer to be used in a virtualization environment where more than one operating system can share the same hardware resources.

Hyper-V

A virtualization technology developed by Microsoft that allows for the creation and management of virtual machines on a Windows-based platform.

Clock Speed

The rate at which timing signals are sent to motherboard components (normally measured in MHz).

Single-Threaded Task

A single-threaded task is executed by a computer processor using a single sequence of instructions, meaning tasks are completed one at a time.