Explain the advantages of using a PivotTable instead of a subtotal.

What will be an ideal response?


1. Answers may vary. You can group data into one or more categories and perform a variety of calculations without altering the original dataset, whereas the Subtotal feature inserts subtotal rows within the original dataset. An important benefit of a PivotTable is that it is dynamic: You can easily and quickly pivot, or rearrange, the data to see them from different angles, such as expanding or collapsing details, organizing and grouping data differently, and switching row and column categories.

Computer Science & Information Technology

You might also like to view...

Microsoft Word provides a tool to help you check grammar.

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

Computer Science & Information Technology

Identify one or two other popular or historical operating systems and compare their features with those of Linux.

What will be an ideal response?

Computer Science & Information Technology

The pointer, which appears as an arrow on the screen, indicates the position of the pointingdevice.

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

Computer Science & Information Technology

Sandy is replacing her broken laptop LCD screen with a new screen. During disassembly, she notices two cables that wrap around the screen and connect to the mini-PCIe card inside the laptop. ? What will happen if Sandy breaks one of these cables?

A. The laptop LCD screen will not have power. B. The laptop webcam will not function. C. She will not be able to connect to Wi-Fi with the laptop. D. The laptop sound will not work.

Computer Science & Information Technology