Skip to content

CMA Intermediate · Financial Management and Business Data Analytics · Data Processing, Organisation, Cleaning and Validation

A company's accounts payable system requires every PAN entered for a vendor to have 10 characters in the pattern five letters, four digits, one letter. A clerk types 'ABCDE12345' for a vendor. The system rejects it. Which validation check caught the error?

A format or pattern check caught it. The PAN must follow five letters, four digits and a final letter, but the entry ends with a digit instead of a letter. Range checks test numeric limits and completeness checks test missing fields, so neither applies here.

  1. AFormat (pattern) checkCorrect
  2. BRange check
  3. CCompleteness check
  4. DConsistency check across fields

Explanation

The expected pattern is five letters, four digits, then one letter. 'ABCDE12345' has five letters followed by five digits, so the last character breaks the pattern. Detecting a pattern violation is a format check, not a range check since no numeric limits are involved.

Did you get it right without looking?

One question tells you little. A timed set on Data Processing, Organisation, Cleaning and Validation shows your real accuracy, how long you take and where you lose marks.

Practise Data Processing, Organisation, Cleaning and ValidationFree diagnostic mock

More Data Processing, Organisation, Cleaning and Validation questions