Match the Following Calculated Field Settings with the Corresponding Description

question 32

Short Answer

Match the following calculated field settings with the corresponding description:
I.Slicer
II.Filter
III.Calculated Field
IV.PivotChart
V.Slicer caption
A.An interactive graphical representation of the data in a PivotTable
B.Text that displays in the header at the top of the slicer window
C.A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
D.A user-defined field that does not exist in the original dataset
E.Excludes particular categories or values

---

Definitions:

Acquisition Differential

The difference between the cost of acquiring a company and the sum of the fair market values of the identifiable assets acquired minus liabilities assumed.

Equity Method

An accounting technique used to record investments in other companies, where the investment is initially recorded at cost and adjusted thereafter for the investor's share of the investee's net income or loss.

Patents

Intellectual property rights granted to an inventor, providing exclusive rights to use, sell, or manufacture the invention for a certain period.

Equipment

Tangible personal property used in operations, such as machinery or office hardware, that is not intended for sale.