What is internal audit? What is pivot table, how to use vlookup. What is ptp process.

Question

Accepted Answer

Internal audit is an independent, objective assurance and consulting activity designed to add value and improve an organization's operations.

Internal audit evaluates the effectiveness of an organization's risk management, control, and governance processes.
Pivot table is a data summarization tool used in spreadsheet programs like Excel. It allows you to quickly summarize and analyze large amounts of data.
VLOOKUP is a function in Excel that allows you to search for a specific value in a table and return a corresponding value from a different column in the same table.
PTP process stands for Procure-to-Pay process. It is a set of activities that involve purchasing goods or services from a vendor and paying for them.
Internal audit helps organizations achieve their objectives by bringing a systematic, disciplined approach to evaluate and improve the effectiveness of risk management, control, and governance processes.
Pivot table is useful for analyzing large datasets and identifying patterns and trends.
VLOOKUP is commonly used in financial analysis and accounting to match data from different sources.
PTP process involves several steps such as requisition, purchase order, goods receipt, invoice verification, and payment processing.

Top Ernst & Young Analyst interview questions & answers