1.) In a Sales Bill file the Sales Head would like to know the quantity, value and percentage of sales product wise in the value buckets of 0-0.5 million, 0.5 million to 5 million and 5 million & above. How would this report be developed in IDEA?

a.) Group Records

b.) Straitification

c.) Chart

2.) In an Inventory Movement file you have been sought out to prepare a plant wise /material wise aging statement based on the last movement date for each item. How would this be done in IDEA?

a.) Key Value Aging

b.) agining-chart

c.) detailed aging

3.) In a Payroll Distribution file the Payroll In charge would like a standard report of location wise / designation wise / grade wise employee count of new joinees and leavers. How would this analysis be conducted through IDEA?

a.) Gap Detection

b.) Control Total

c.) Duplicate Key Detection