1.

What is the use of PIVOT TABLE?

Answer»

Preparation of reports using Pivot Tables: 

A Pivot Table is a way to present information in a report format. A Pivot Table report provides enhanced layout, attractive and formatted report with improved readability. There are two types of data table. 

1. One-Variable Data Table (One – Variable ) 

2. Two-Variable Data Table (Two-Variable) 

  • The one variable Data Table allows us to identify a single decision variable in our model and see how changing the values for that variable affects the values calculated by one or more formulas in our model.
  • The two variable Data table allows us to specify two decision variables and a variety of inputs and only a single formula.


Discussion

No Comment Found

Related InterviewSolutions