mediumMultiple ChoiceObjective-mapped
FC0-U71 Practice Question: That a spreadsheet application crashes whenever…
A user reports that a spreadsheet application crashes whenever they try to use a specific macro. The technician needs to identify the cause. Which of the following should the technician check first?
⚠ Common exam trap
A common mix-up: candidates assume a hardware or system-level issue (like RAM or OS version) is the root cause, when the problem is specifically tied to the execution of a single macro, making the macro code the most logical first check.
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
✓
The macro code for errors.
The macro code is the most direct cause of the crash because macros are custom scripts (often VBA) that execute within the application. If the code contains syntax errors, infinite loops, or attempts to access invalid objects, it will cause the application to terminate unexpectedly. Checking the code first follows the principle of isolating the specific change or action that triggers the fault.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The macro code for errors.
Why this is correct
A bug or error in the macro code can cause the application to crash when executed.
- ✗
The version of the operating system.
Why it's wrong here
OS version issues would affect the application overall, not just macro execution.
- ✗
The file format of the spreadsheet.
Why it's wrong here
File format issues might prevent opening the file, but would not cause a crash only when using a macro.
- ✗
The amount of RAM available.
Why it's wrong here
Insufficient RAM would cause slowdowns or crashes across the system, not specifically when running a macro.
Go deeper
Related to this question
About these practice questions
One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This FC0-U71 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 FC0-U71 exam.