220-1102 · Question #802
A user has been adding data to the same spreadsheet for several years. After adding a significant amount of data, they are now unable to open the file. Which of the following should a technician do…
The correct answer is B. Increase the amount of RAM. When a spreadsheet grows in size due to continuous data entry, it can require more memory to process and open. If the file is not opening, it's likely due to insufficient system resources, specifically RAM. Increasing the amount of RAM will enhance the system's capability to…
Question
A user has been adding data to the same spreadsheet for several years. After adding a significant amount of data, they are now unable to open the file. Which of the following should a technician do to resolve the issue?
Options
- ARevert the spreadsheet to the last restore point.
- BIncrease the amount of RAM.
- CDefragment the storage drive.
- DUpgrade the network connection speed.
How the community answered
(21 responses)- A5% (1)
- B71% (15)
- C14% (3)
- D10% (2)
Explanation
When a spreadsheet grows in size due to continuous data entry, it can require more memory to process and open. If the file is not opening, it's likely due to insufficient system resources, specifically RAM. Increasing the amount of RAM will enhance the system's capability to handle larger files, allowing the spreadsheet to open. Other options, such as defragmenting the storage drive, upgrading network speed, or reverting to a restore point, do not directly address memory limitations and would not resolve the issue effectively.
Topics
Community Discussion
No community discussion yet for this question.