A brand manager in a consumer food products organization suspected that several days of the point-of-sale data on the spreadsheet from one grocery chain were missing.

A brand manager in a consumer food products organization suspected that several days of the point-of-sale data on the spreadsheet from one grocery chain were missing.

The best approach for detecting missing rows in spreadsheet data would be to:
A . Sort on product identification code and identify missing product identification codes.
B . Review store identification code and identify missing product identification codes.
C . Compare product identification codes for consecutive periods.
D . Compare product identification codes by store for consecutive periods.

Answer: D