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


Ans: Select Number Format and choose Currency in the list of options and then click OK.

Computer Science & Information Technology

You might also like to view...

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

13. Designers wrestle with the challenge of balancing processor performance with that of main memory and other computer components. 14. A straight comparison of clock speeds on different processors tells the whole story about performance. 15. Measures such as MIPS and MFLOPS have proven adequate to evaluating the performance of processors.

Computer Science & Information Technology

Explain in what circumstances penetrate-and-patch is a useful program maintenance strategy

What will be an ideal response?

Computer Science & Information Technology

Describe the issues involved with splitting cable connections.

What will be an ideal response?

Computer Science & Information Technology

A ____ statement is a specialized selection statement that can be used in place of an if-else chain where exact equality to one or more integer constants is required.

A. case B. break C. switch D. nested if

Computer Science & Information Technology