Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable, how would you find out how many of each type of candy bar you have?

A. Drag Item to both the VALUES and the ROWS area.
B. Drag Price to the ROWS and Item to the VALUES area.
C. Drag Item to the COLUMNS area.
D. Drag Item to the ROWS areas.


Answer: A

Computer Science & Information Technology

You might also like to view...

Why is redundancy of data undesirable?

What will be an ideal response?

Computer Science & Information Technology

____ is the ability to use the same expression to denote different operations.

A. Inheritance B. Encapsulation C. Polymorphism D. Composition

Computer Science & Information Technology

The primary key can only be a single field.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

You find the jQuery UI category on the Dreamweaver ____.

A. Application bar B. Insert panel C. Property inspector D. status bar

Computer Science & Information Technology