Which statement describes a limitation of spreadsheets for real-time analytics?

• A. They may not support dynamic visualizations that change in real time
• B. They automatically pull data from databases
• C. They support unlimited concurrent users
• D. They are ideal for streaming data

Answer: (A)

Real-time analytics rely on data and visuals that update as new information arrives. Spreadsheets update their charts and dashboards only when you refresh or when their calculations rerun, which introduces delay. That makes dynamic visuals that change in real time difficult to achieve in a spreadsheet environment. While some spreadsheets can connect to databases or support collaboration, automatic real-time data pulling, unlimited concurrent edits, or handling streaming data are not their strong suits. These tasks are better served by specialized tools designed for continuous data ingestion and low-latency visualization.