Multiple Choice
What would you do to format all values as Currency in the Sum of Extended Price field no matter how you pivot the data?
A) Select Product.
B) Select Number Format and choose Currency in the list of options and then click OK.
C) Click the Show Values As tab and select Currency in this list and then click OK.
D) Click cancel and select the cells and then format as Currency on the Home tab.
Correct Answer:

Verified
Correct Answer:
Verified
Q11: Using the % of Grand Total Calculation
Q29: Which is an effective way to change
Q41: A(n)_ is a hierarchical structure used to
Q56: When the underlying data changes, a PivotTable
Q60: A Recommended PivotTable creates a PivotTable on
Q65: In a Subtotaled Worksheet, this is a
Q66: _ apply different formatting and color schemes
Q75: _ display the total values for each
Q76: A slicer can be formatted so the
Q92: A PivotChart has no filters available.