Kantar Quality Assurance Analyst Interview Questions and Answers

Creating tables in Excel involves defining column headers, entering data, and formatting the table.

• Define column headers by selecting the first row and entering the header names

• Enter data in the rows below the header row

• Select the data and click on the 'Insert Table' button in the 'Insert' tab

• Format the table by selecting a style and adjusting column widths

• Add or remove rows and columns as needed

A pivot table is a data summarization tool used in Excel to analyze and present data in a more organized manner.

• Select the data range you want to summarize

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

• Choose the location where you want to place the PivotTable

• Drag and drop the fields you want to summarize into the Rows and Columns areas

• Add any necessary calculations or filters to the PivotTable