Data Quality Investigation
Audit a messy order extract with formulas: count blanks, numbers stored as text, duplicate IDs, stray spaces, bad values and future dates, then score the data.
What you will practise: Use COUNT-family functions, SUMPRODUCT and TRIM to detect the most common data defects, and report how much of the data can be trusted.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.