Which of the following statements regarding Excel data and Pivot Tables is incorrect?

Excel features can be used to replicate a database.

In order to correctly use the subtotals feature, the user must first sort the data by the column for which the subtotal will be figured for.

Report filters and slicers can be used to filter the data found in a Pivot Table.

To sort Excel data, the columns being sorted need to be adjacenthside$-$by$-$side$).$

To create a Pivot Table, you need to specify the dimensions by which you wish to view the information. The result of this is that you can see relationships in the data.