Required information

Lab $2\mathrm{.}1$ Alternate: Identifying and Working with Different Data Types $($LO $2-5)$

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

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.