Using audit data analytics with IDEA:

1.) An employee master file contains a listing of employees with their birth dates and service joining dates. You have been called upon to compute their retirement date and filter out employees retiring in 2015 for computation of retirement benefits payout. Which @Function in IDEA will allow us to compute the retirement date from the birth date?

a.) Both @dtodays and @daystod

b.) @daystod

c.) @strip

2.) You have been provided with a direct expense ledger statement. Every transaction contains a narration, where payments may be made by cash or check. Hence the narration may contain the words cash or check. You have been called upon to make an expense wise cash/bank type wise summary of entries. Which @Function in IDEA will you employ to capture the types 'cash'/'bank' in a separate field?

a.) @isini

b.) @remove

c.) @both isini and @if

An insurance claims file contains a field 'Claim Number' which is a combination of the branch, year, month, category and claim number. The category of the claim - fire, marine, burglary and more is not available as a separate field in the file. How would you prepare the data for a category based summary of claims using IDEA?

a.) @right

b.) @ltrim

c.) @mid