Morgan Stanley Interview Question

Test the sorting and filtering feature of excel sheet through automation, especially using QTP or VBScript. The excel might contain millions of records, and the code should be optimized to perform the checks in the minimum possible time with accurate results