1.

What is a Pivot table? Write its usage.

Answer»

One of the basic TOOLS for data analysis is the Pivot Table. With this feature, you can quickly summarize large DATASETS in Microsoft Excel. Using it, we can turn columns into rows and rows into columns. Furthermore, it permits grouping by any field (column) and applying advanced CALCULATIONS to them. It is an extremely easy-to-use program since you just drag and drop rows/columns headers to build a report. Pivot tables consist of FOUR different sections: 

  • Value Area: This is where values are reported. 
  • Row Area: The row areas are the headings to the left of the values. 
  • Column Area: The headings above the values area make up the column area. 
  • Filter Area: Using this filter you may drill down in the data set. 


Discussion

No Comment Found

Related InterviewSolutions