Pivot Table

Question 1

What is a pivot table?

Answer 1

A tool in some spreadsheet applications that allows you to extract the
significance from a large, detailed data set and provide it as a summary. This summary might
include sums, averages, or other statistics.

Question 2

What is a One Dimensional Pivot Table?

Answer 2

Summarizes dataset either in Row layout or Column layout
for the selected data fields. One Dimensional Pivot tables are typically used when creating
frequency Distributions.

Question 3

What is a Frequency Distribution Table?

Answer 3

A table that summarizes values and their frequency. It’s a
useful way to organize data if you have a list of numbers that represent the frequency of a
certain outcome in a sample. A frequency distribution table has two columns. The first
column lists all the various outcomes that occur in the data, and the second column lists the
frequency of each outcome.

Question 4

What is a Two Dimensional Pivot Table?

Answer 4

Created by dragging and placing data fields in the Row
and Column areas. It further splits the data and gives more insight into data by generating a
different view of data.

Question 5

Steps to create a pivot table

Answer 5

It is important to format your data correctly,
otherwise, it will not generate correct results. Each data type should be laid out in a separate
column having a header on top, called adata field. Each data field should be formatted as text, number or date as per type of data it contains. There should be no merged cells in data
fields.
1. Click any cell in your dataset
2. Go to Insert tab, click on PivotTable in Tables group
3. Excel automatically selects your data set and by default creates a New Worksheet
where you want the Pivot table report to be placed. Alternatively, you can select to
use an Existing Worksheet and the location where you want the Pivot table report to
be placed. Press OK.
4. After inserting a Pivot Table, Excel generates the Report View pane on the left side
and lists all the data fields in the Pivot Table Field List panel on the right side. You
need to pick and drag data fields from the Field List panel and place them in Row
Labels, Column Labels, Filter and Values areas to generate their report view on the
left-hand side.
You can create single dimensional or two-dimensional Pivot tables by placing data fields in their respective Labels as per your requirement. Number fields are placed in the Values area to make a calculation, and other data fields are placed in Row, Column and Filter areas of the Pivot Table Fields list panel as per requirement.