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
Q1: If you create a Recommended PivotTable on
Q4: If you would like to show a
Q8: You would like to see both average
Q9: Moving one of two fields from the
Q10: Which of the following is true about
Q12: You have a PivotTable with 2 fields
Q13: A(n)_ is an interactive table which uses
Q17: Which function is not a Subtotal function?
A)MAX
B)SUM
C)AGGREGATE
D)AVERAGE
Q18: Which of the following is not a
Q20: Grouping is _.
A)using a VLOOKUP function to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents