produce a report of valid customer orders containing ONLY the columns shown in Figure $1.$ Figure $1$

Include summary information $($i$.$e$.,$ totals and averages$)$ at the bottom of last $4$ columns.

Format the columns so that the report fits on a maximum of $3$ pages with column headings repeated on page $2.$ Customer Name State Item Description Qty Product Cost Tax Shipping Cost Total Cost

Data in each column must be properly aligned and formatted. Headings should be bolded. Summary info should be italicized.

The customer orders should be sorted based on Total Cost from largest to smallest.

The professionalism and quality of your report's formatting will be evaluated as part of your grade.

$2)$ List customer orders containing errors $($if any$).$ Provide a brief $(2-4$ words$)$ explanation of the each error found.

$3)$ Calculate the average weight of an order in the sample. Round to $2$ decimal places.

$4)$ Produce a pivot table showing unit sales for each category. Sort the table from largest to smallest.

$5)$ Produce a pivot table of shipping costs summarized by category $($rows$)$ and DC it is shipped from $($columns$).$ Sort the table from smallest

to largest.