P $2-7($LO $2\mathrm{.}4)$ The Chapter $2$ Problem dataset contains a list...

Skip to question

$[$The following information applies to the questions displayed below.$]$

The Chapter $2$ Problem dataset contains a list of outstanding invoices for a fictional company, but the data aren$$t ready for analysis yet. Using this data file, take the following steps to validate and clean the data for completeness and integrity in Excel:

P $2-7($LO $2\mathrm{.}4)-$ Part d$-2$

d$.$ iv$.$ Explain how viewing the data in a pivot table can help you better understand the dataset. How might management use this pivot table?