Risk Assessment & Management Flashcards
7 cards from real Excel VBA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Risk Assessment & Management flashcards as text
In VBA-driven risk reporting, which event is most appropriate for automatically refreshing a risk summary table whenever the source data worksheet is activated?
Answer: Worksheet_Activate
Worksheet_Activate fires each time the user switches to that sheet, ensuring the risk summary reflects the latest data on every view.
A risk analyst needs to run 10,000 simulation iterations in VBA without freezing Excel. Which technique best maintains UI responsiveness during the loop?
Answer: Call DoEvents periodically inside the loop
Calling DoEvents at intervals yields control to Windows temporarily, allowing Excel to process pending messages and appear responsive.
Which VBA collection type is best suited for storing a dynamic list of unique risk identifiers where fast lookup by key is required?
Answer: Scripting.Dictionary
Scripting.Dictionary provides O(1) key-based lookup and enforces unique keys, making it ideal for mapping risk IDs to their records.
A VBA procedure writes risk assessment results to a closed workbook using early binding to Excel.Application. What must be true for this to work reliably?
Answer: A reference to the Microsoft Excel Object Library must be set in the VBA project
Early binding requires a reference to the target type library so VBA can resolve object types at compile time, not just runtime.
When a risk model macro needs to read configuration from a JSON file, which approach works in standard Excel VBA without third-party libraries?
Answer: Read the file as text and parse it manually with string functions
VBA has no native JSON parser, so reading the file as a text string and extracting values with InStr, Mid, or Split is the standard no-dependency approach.
A risk assessment workbook is shared across a team using OneDrive co-authoring. A VBA macro that modifies sheet protection may fail because:
Answer: Co-authoring mode restricts certain structural operations like protecting sheets
Co-authoring imposes restrictions on operations such as sheet protection that could conflict with simultaneous edits by other users.
To ensure a risk scoring formula recalculates only when relevant inputs change—not on every worksheet recalculation—a VBA UDF should avoid:
Answer: Calling Application.Volatile without necessity
Application.Volatile marks a UDF to recalculate on every worksheet change, adding overhead; omitting it allows Excel to recalculate only when the function's direct inputs change.