220-1202 · Question #47
Every time a user loads a specific spreadsheet, their computer is temporarily unresponsive. The user also notices that the title bar indicates the applications are not responding. Which of the…
The correct answer is D. File size and related memory utilization. A very large or complex spreadsheet can consume excessive RAM and CPU cycles, causing the application to hang or become unresponsive. By checking the file's size and monitoring how much memory Excel (or the spreadsheet program) uses when opening it, the technician can confirm…
Question
Every time a user loads a specific spreadsheet, their computer is temporarily unresponsive. The user also notices that the title bar indicates the applications are not responding. Which of the following would a technician most likely inspect?
Options
- AAnti-malware logs
- BWorkstation repair options
- CBandwidth status as reported in the Task Manager
- DFile size and related memory utilization
How the community answered
(41 responses)- A15% (6)
- B2% (1)
- C7% (3)
- D76% (31)
Explanation
A very large or complex spreadsheet can consume excessive RAM and CPU cycles, causing the application to hang or become unresponsive. By checking the file's size and monitoring how much memory Excel (or the spreadsheet program) uses when opening it, the technician can confirm whether resource exhaustion is the culprit and take steps - like simplifying the file or adding RAM - to resolve the issue.
Topics
Community Discussion
No community discussion yet for this question.