What is a pivot table in Microsoft Excel?
- a function to investigate formula errors and correct them
- a table containing data that is organized vertically
- a table containing data that is organized horizontally
- a function to automatically summarize, analyze, explore, and present data
| Explanation & Hint:
Pivot tables provide a way to automatically summarize, analyze, explore, and present data. Using the built-in tools you can identify trends, make comparisons between data items and create charts in different styles to visualize your data. Pivoting data can help you answer different questions and even experiment with your data to discover new trends and patterns. |