Spreadsheet risk assessment quiz
Think about a spreadsheet that you're familiar with.
For each question below, select the answer that best describes that spreadsheet.
When you've answered all the questions, click the "Assess risk" button to calculate an indication of the spreadsheet's level of risk.
About this quiz
This quiz rates risk as either Critical, High, Medium, or Low. The rating is only indicative.
The assessment is a weighted average of your answers. Particularly risky factors – such as critical importance, high complexity, and lack of testing – have greater weight. Risk is partly offset by the use of good practices and controls.
As a follow-up, you might be interested in our presentation Making better spreadsheets: Why 95% of spreadsheets contain errors, and what we can do about it.
The questions are based on research into spreadsheet risk factors, specifically:
- Risk assessment for spreadsheet developments: Choosing which models to audit.
- Spreadsheet risk, awareness, and control.
- Controls over spreadsheets for financial reporting in practice.
For more information about how we can help you manage your spreadsheet risk, please contact us.