ERP Assistant Interview Questions and Answers

Pivot tables are used in Excel to summarize and analyze data.

• Select the data range you want to analyze

• Go to the 'Insert' tab and click on 'PivotTable'

• Choose where you want the PivotTable to be placed

• Drag and drop fields into the 'Rows', 'Columns', and 'Values' areas to organize the data

• Apply filters and formatting as needed

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.

• Select the cell where you want the result to appear

• Type =VLOOKUP(

• Enter the value you want to search for

• Enter the range of cells where the value is located

• Enter the column number in the range containing the value to return

• Enter FALSE for an exact match or TRUE for an approximate match