Pergunta de entrevista da empresa Grant Thornton

Do you have basic accounting knowledge, and can you explain the VLOOKUP function and how to use Pivot Tables in Excel?

Resposta da entrevista

Sigiloso

28 de fev. de 2025

Yes, I have a solid understanding of accounting principles, including financial statements, auditing procedures, and general ledger reconciliation. For VLOOKUP, I explained that it is a function used to look up a value in a column and return a corresponding value from another column. I provided an example: "If I have a table with employee IDs and salaries, I can use =VLOOKUP(Employee_ID, Table, 2, FALSE) to fetch an employee's salary based on their ID." For Pivot Tables, I described how they help summarize and analyze large datasets efficiently. I mentioned a common use case: "If I have a dataset with thousands of transactions, I can use a Pivot Table to quickly group sales by region, filter by product category, and generate summary statistics without modifying the original data."