Question

The first step in creating a pivot Table is to choose the range of data which will form the pivot table:

Answer 1

Answer:

1. Create a Pivot Table in Excel 2003

2. Select a cell in the database.

3. Choose Data>PivotTable and PivotChart

Report.

4. Select 'Microsoft Excel List or Database',

click next.

5. For the range, type your range name,

e.g. database.

6. Click Next.

7. Click the Layout button.Drag field buttons to

the row, column and data areas.