Excel VBA Risk Assessment & Management 2

Question 1

In Excel VBA risk modeling, which method best prevents a Monte Carlo simulation from producing identical results on every run?

Accepted Answer

Call Randomize before Rnd()

Answer

Calling Randomize (optionally with Timer) seeds the random number generator so each run produces a unique sequence.

Question 2

A VBA risk dashboard must highlight cells where a calculated probability exceeds a threshold stored in a named range called 'RiskLimit'. Which approach is most maintainable?

Accepted Answer

Reference the named range directly in the macro comparison

Answer

Referencing the named range directly keeps the threshold in one managed location that business users can update without touching VBA code.

Question 3

Which VBA statement correctly catches a division-by-zero error that may occur when calculating a risk ratio?

Accepted Answer

On Error GoTo ErrHandler

Answer

On Error GoTo ErrHandler redirects execution to a labeled error handler where division-by-zero (Err.Number 11) can be addressed.

Question 4

When building a risk scoring matrix in VBA, a nested Select Case structure is preferred over nested If/ElseIf because it:

Accepted Answer

Improves readability for multiple discrete score bands

Answer

Select Case clearly maps discrete score ranges to outcomes, making the risk banding logic easier to read and audit than deeply nested If/ElseIf.

Question 5

A risk analyst wants to log every VBA-calculated risk score to a new row in a 'RiskLog' sheet automatically. Which technique avoids overwriting existing entries?

Accepted Answer

Use Sheets("RiskLog").Cells(Rows.Count,1).End(xlUp).Offset(1,0)

Answer

Finding the last used row and offsetting by one appends entries without disturbing existing log data.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Risk Assessment & Management 2