Which feature offers a different perspective on data with multiple categories?

Which feature offers a different perspective on data with multiple categories?

• A. Switch
• B. Pivot
• C. Filter
• D. Sort

Answer: (A)

When you’re dealing with data that has multiple categories, you want to see how the numbers look from different angles without changing the data itself. A switch feature is designed to flip between these different categorical perspectives, acting like a quick lens you can toggle. By switching the dimension you’re focusing on, you instantly view the same data organized in a new way—for example, seeing results by region in one view and by product category in another. This gives you a different perspective that helps reveal patterns or insights that might not be obvious from a single viewpoint. Pivot can also change how data is arranged, but the switch is specifically about flipping between perspectives or lenses, which is what the question is highlighting. Filter narrows the data you’re looking at, and sort changes the order, neither of which provides a new lens on the same dataset.

When you’re dealing with data that has multiple categories, you want to see how the numbers look from different angles without changing the data itself. A switch feature is designed to flip between these different categorical perspectives, acting like a quick lens you can toggle. By switching the dimension you’re focusing on, you instantly view the same data organized in a new way—for example, seeing results by region in one view and by product category in another. This gives you a different perspective that helps reveal patterns or insights that might not be obvious from a single viewpoint.

Pivot can also change how data is arranged, but the switch is specifically about flipping between perspectives or lenses, which is what the question is highlighting. Filter narrows the data you’re looking at, and sort changes the order, neither of which provides a new lens on the same dataset.