!\ Required information\ Lab 2.1 Alternative: 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.1 to the Alt Lab 2.1 Data.xlsx dataset. Open Excel file Alt Lab 2.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.1 Data.xIsx\ Analyze the Data: Refer to lab 2.1 in your text for additional instructions and steps.\ Lab 2.1 Alternate: Assessment Questions\ Answer the following questions based on the details computed.\ \\\\table[[Question],[1. How many customers have invoices due on 7/25/2025?],[2. How many days have invoices due from 4 different customers?],[. What is the total invoice amount due in July, 2025 ? (Round to 2 decimal places.)],[4. What amount is due on

(8)/(17)/2025

? (Round to 2 decimal places.)],[5. What is the total invoice amount due in November, 2025 ? (Round to 2 decimal places.)]]

Required information Lab 2.1 Alternative: 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.1 to the Alt Lab 2.1 Data.xIsx dataset. Open Excel file Alt Lab 2.1 Data.xIsx. Required: 1. Calculate the grand totals of Customer Count, Sum of InvoiceAmount, and Count of Due Date. 2. Subtotal the accounts receivable by date in a pivot table. 3. Add in conditional formatting to the count of the Customer field. 4. Create a line chart representing customer orders by day. Data: Alt Lab 2.1 Data.xIsx Analyze the Data: Refer to lab 2.1 in your text for additional instructions and steps. Lab 2.1 Alternate: Assessment Questions Answer the following questions based on the details computed