220-1102 Software Troubleshooting Practice Question
A user reports that a specific Microsoft Office add-in causes Excel to crash when opening any spreadsheet. The technician disables the add-in and Excel works fine. However, the user needs the add-in. The technician checks the add-in's compatibility and finds it is designed for 32-bit Office but the user has 64-bit Office installed. What is the best solution?
⚠ Common exam trap
A common mix-up: candidates assume reinstalling Office in 32-bit mode is the simplest fix, overlooking that the user may have chosen 64-bit Office for a reason (e.g., large Excel workbooks) and that a targeted add-in upgrade is less disruptive and more appropriate.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Install the 64-bit version of the add-in if available
The best solution is to install the 64-bit version of the add-in if available, because the add-in is compiled specifically for the 32-bit Office architecture and will not load or function correctly in a 64-bit Office environment. Since the user needs the add-in and the 64-bit Office installation is already in place, obtaining a native 64-bit version resolves the compatibility issue without requiring a full Office reinstallation or workarounds that do not address the core architecture mismatch.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Install the 64-bit version of the add-in if available
Why this is correct
Excel is a 64-bit process that cannot load a 32-bit add-in DLL into its address space; the module's bitness must match the host. Installing the vendor's 64-bit version of the add-in directly resolves this mismatch and is the least disruptive fix. If no 64-bit version exists, you would need to consider moving to 32-bit Office instead.
- ✗
Reinstall Office in 32-bit mode
Why it's wrong here
Reinstalling Office in 32-bit mode would indeed allow a 32-bit add-in to run, but it forces a complete uninstall/reinstall of the entire Office suite and may break other 64-bit-only integrations or remove the ability to work with very large workbooks (the main reason 64-bit Office exists). It is a heavy-handed workaround, not a fix for the add-in itself. Since the question asks for the best minimal solution, this is not the preferred answer.
- ✗
Run Excel in compatibility mode for an earlier version
Why it's wrong here
Excel's compatibility mode is a document-level setting that limits features to an older file format or UI; it has no effect on the process architecture of the Excel application itself. A 32-bit add-in is a native code component that requires a 32-bit host, regardless of whether the file is in .xls or .xlsx compatibility mode. Thus, this option addresses a completely unrelated layer of the application stack.
- ✗
Use a Windows compatibility troubleshooter on the add-in
Why it's wrong here
The Windows compatibility troubleshooter applies shims like virtualized registry writes, emulated resolutions, or running as administrator for legacy executables. It does not and cannot recompile or translate a 32-bit add-in's machine code into 64-bit. The add-in is loaded in-process into Excel, so the OS loader will still reject it with a 'bad image' error before the troubleshooter's settings are even relevant.
Visual reference
Go deeper
Related to this question
About these practice questions
This 220-1102 question is part of Courseiva's 925-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This 220-1102 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the 220-1102 exam.