Excel-Audit Tool

file cannot be easily converted into Excel

• XML
• CSV
• PDF
• TEXT

function is used to calculate the present values of all future cashflows.

• FV
• PV
• NPV
• IRR

is the rate of discounting at which NPV=0

• FV
• PV
• NPV
• IRR

If Guess parameter is not specified by the user in IRR,Excel assumes it to be

• 9%
• 14%
• 10%
• 13%

In case if the cash flows occur unevenly,then we may use and in excel

• PV & IRR
• XNPV & XIRR
• NPV & IRR
• None of the above

Function is used for calculating depreciation as per Written Down Value Method

• SLN
• DB
• All the Above
• None of the above

Function can be used while verifying depreciation expense claimed by the auditee

• DB
• SLN
• All the Above
• None of the above

Function is used for calculationg maturity dates

• Date
• Month
• NetworkDays
• None of the above

In EOMONTH() , if the second argument(months) is defined as 2 it will yield month end date

• before 2 months
• after 2 months
• #N/A
• None of the above

Will the EOMONTH() will take the leap year factor into account?

• YES
• NO