QuestionQ5

Software Troubleshooting

A user has added data to the same spreadsheet over several years. After adding a substantial amount of data, they can no longer open the file. What should a technician do to resolve the problem?

  • A Revert the spreadsheet to the last restore point.
  • B Increase the amount of RAM.
  • C Defragment the storage drive.
  • D Upgrade the network connection speed.
Explanation

A spreadsheet that has grown large enough that the application can no longer load it typically means the workstation lacks sufficient memory to process the file into working memory. Adding RAM gives the application the headroom it needs to open and render the full dataset. Reverting to a restore point would sacrifice the very data the user needs, and defragmenting storage or upgrading network speed has no bearing on an application's ability to load a file into memory.

Community Discussion

No comments yet. Be the first to start the discussion!