Why might spreadsheets be insufficient for advanced data analysis?

• A. They are too expensive
• B. They may not support custom analysis or dynamic visualizations that change in real time
• C. They offer every feature needed
• D. They are designed only for word processing

Answer: (B)

Spreadsheets are a solid tool for quick calculations, but advanced data analysis requires flexibility to run custom analyses and to present visualizations that update in real time as data changes. They often can’t support complex models, iterative experimentation, or automated, live dashboards without manual fiddling or external add-ons. Large datasets can also push performance limits, making scalable, reproducible workflows difficult. Tools designed for analytics allow direct integration with live data sources, more robust modeling capabilities, and automated updates, which is why they’re preferred for sophisticated analysis. So the main idea is that spreadsheets fall short because they don’t readily support custom analyses or dynamic, real-time visualizations.