Adding more RAM to each workstation is the least expensive and most effective way to improve the performance of loading large files like a 2GB spreadsheet. RAM directly impacts how much data a workstation can hold in memory for fast access, and increasing it will help the spreadsheet load and process more quickly. Other options, like upgrading switches or moving to a shared database, may be more costly or less effective.
A . Buy faster networking switches may improve network speed but does not directly affect the local file processing speed.
B . Upgrade the operating system and applications may help, but adding RAM is typically a more cost-effective solution.
C . Move the file to a shared database is unnecessary for a single spreadsheet file.
Reference:
CompTIA A+ Certification Guide
Official CompTIA IT Fundamentals (ITF+) Study Materials