mediumMultiple Choice
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 macro that crashes the application points to faulty code, such as an infinite loop, invalid reference or unhandled error. Inspecting the macro's code first isolates the defect before considering permissions, add-ins or file corruption.
- ✗
The version of the operating system.
Why it's wrong here
An operating system version mismatch would affect the whole application's stability, not one specific macro. The macro's code, security settings or dependencies are the direct cause. OS version is tempting because compatibility issues do crash software, but that would manifest across many features, not reproducibly on a single macro.
- ✗
The file format of the spreadsheet.
Why it's wrong here
File format governs compatibility of stored data and features, not the execution of a macro already running inside the document. A macro crash points to the macro code, permissions or referenced components. File format is tempting because legacy formats can disable macros, but that blocks execution rather than crashing the application mid-run.
- ✗
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.