Lab Insight: Apply the same steps in Lab $2\mathrm{.}1$ to the Alt Lab $2\mathrm{.}1$ Data.xlsx dataset. Open Excel file Alt Lab $2\mathrm{.}1$ Data.xlsx$.$

Required:

Calculate the grand totals of Customer Count, Sum of InvoiceAmount, and Count of Due Date.

Subtotal the accounts receivable by date in a pivot table.

Add in conditional formatting to the count of the Customer field.

Create a line chart representing customer orders by day.

Data: Alt Lab $2\mathrm{.}1$ Data.x$|$sx

Analyze the Data: Alternate Labs don't have step$-$by$-$step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab.

Answer the following questions based on the details computed.

$\backslash$table$[[$Question$,$Answer$],[1.$ How many customers have invoices due on $\frac{10}{13}\frac{?}{2025}?,],[2.$ How many days have invoices due from $4$ different customers?,$],[3.$ What is the total invoice amount due in December, $2025?($Round to $2$ decimal places.$),],[4.$ What amount is due on $\frac{7}{25}\frac{?}{2025}?($Round to $2$ decimal places.$),],[5.$ What is the total invoice amount due in August, $2025?($Round to $2$ decimal places.$),]]$