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

Skip to question

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

Keywords: Data Types, Numerical Data, Categorical Data, Count, Average, Sum, Proportion, Rank $($Sort$)$

Decision$-$Making Context: Sometimes data types can cause unintentional errors or confusion in business analysis. Taking the time to assess and set the data type in an Excel worksheet can ease your data analysis work.

Access the text alternative for Lab $2-1$ Excel. Will open in a new tab or window. Internet connection required.

$-0$:$00$

$2$x

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: Lab $2\mathrm{.}1$ Data.xlsx

Specify the Question: How do data types affect the way I can analyze data in Excel? How many payments were due on which dates?

Obtain the Data: This lab uses the Excel file titled Lab $2\mathrm{.}1$ Data.xlsx$.$ The data file contains $200$ individual transactions representing the amount of money each customer $($column A$)$ owes $($column B$)$ and when the invoice is due $($column C$).$ All of these receivables are past their due date as of today$$s date, $12/31/2025.$

Analyze the Data: Refer to lab $2\mathrm{.}1$ in your text for additional instructions and steps.

Lab $2\mathrm{.}1$ Excel: Assessment Questions

Answer the following questions based on the details computed.