Protiviti India Member Article Assistant Interview Questions and Answers

Vlookup is a function in Excel that allows you to search for a value in a column and return a corresponding value from another column.

• Vlookup stands for vertical lookup.

• It is commonly used to find specific data in large datasets.

• The function requires four arguments: lookup value, table array, column index number, and range lookup.

• The lookup value is the value you want to search for.

• The table array is the range of cells...read more

Internal audit provides valuable insights into an organization's operations, risk management, and control processes.

• Internal audit helps identify and mitigate risks within an organization.

• It provides assurance to management and stakeholders that internal controls are effective.

• Internal auditors play a crucial role in ensuring compliance with laws, regulations, and company policies.

• They help improve operational efficien...read more

Internal audit is conducted by company's own employees while statutory audit is conducted by external auditors as per legal requirements.

• Internal audit is voluntary while statutory audit is mandatory.

• Internal audit is conducted to assess and improve internal controls and processes while statutory audit is conducted to ensure compliance with legal requirements.

• Internal audit is conducted throughout the year while statut...read more