1.) The Value Added Tax (VAT) levied on inter-state and intra-state sales can be checked for accuracy using -

a.) Direct Extraction

b.) Random Sampling

c.) Field Manipulation

2.) How to detect same receiver getting multiple cash deposits on the same date from different senders where the cash receipts all end with 9?

a.) Direct Extraction

b.) Save As

c.) both Direction Extraction and Benford's Law

3.) How to do corridor analysis - high number of money movements between Country A and State D in the U.S. - potential corridor for terror financing within the same year and month -

a.) Direct Extraction

b.) Summarization

c.) Field Manipulation

4.) In a prominent food chain you have been invited to examine the monthly sales of newly opened westerly outlets vis-a-vis the sales of similar outlets in the South region. The Senior Management would like to rule out the possibility of defalcations, skimming, teeming and lading etc. How would you set up IDEA to provide indicators of branches/outlets deeming an investigation?

a.) Pivot Table

b.) Correlation

c.) Indexed Extraction

5.) 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

6.) 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

7.) 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