Question

Before you create a pivot table, it is important to
O create a databse
Osort a database
O filter a database
O format a database

Answer 1

Before you create a pivot table, it is important to sort a database

Osort a database

Explanation:

As first step on pivot table to be sorted with key data.  Pivot table can be achieved by using MS-excel.

Pivot table means it reorganising the column data and generated summarise column for selected sheet or range of column.  To generate statistics report pivot table function is used.

Normally for pivot table MS-excel tools been used. End user has import the relevant data to MS-EXCEL and do necessary sort with key data value. Once excel sheet data’s sort pivot table formula is applied.