Which of the following can be accomplished by using a PivotTable to conduct a data audit? Select all that apply.

Responses

Identify and remove unnecessary records from the underlying dataset.

Identify and remove unnecessary records from the underlying dataset.

Identify unusual patterns in a dataset.

Identify unusual patterns in a dataset.

Summarize value ranges such as the date range that is included in a dataset.

Summarize value ranges such as the date range that is included in a dataset.

Modify and replace values in the underlying dataset.

Modify and replace values in the underlying dataset.

Count data such as names or transaction numbers.