Lab 2.1 Excel A
Saved
5
1
points
Skipped
eBook
Print
Required information
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: Lab 2.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.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.1 in your text for additional instructions and steps.
References
Answer the following questions based on the details computed.
Question
1. What is the data type of the Due Date column in this dataset?
2. Which measure is provided in Excel's status bar when selecting multiple Customers?
3. Which measure is NOT provided in Excel's status bar when selecting multiple Due Dates?
4. What amount is due on 12/2/2025? (Round to 2 decimal places.)
5. How many invoices are due in July?
Answer
IBA Lab2-1_Data
Formulas
Data Review
View
Tell me
11
A A
==
Wrap Text v
General
Merge & Center
$ % 9
AutoSave OFF
ABG ...
Home
Insert Draw Page Layout
Calibri (Body)
B
I
U ▾
C1
A
×
✓
fx
Due Date
Help
Save & Exit
Submit
Paste
747 12 12/13/25
Smine
H&M
61228
12/0/05
Shell D Company
Pre
52525
917/75
115/25
www
29 United Parcel Service
MLM
5235
Deere & Company
101141 anes
200
130474
23 Samsung Group
14788
3/07/25
12 Pinche
C
SOBDS
3814 11/74/75
M
11/5/25
35/75
13892 14
Mort et Chandon
58187 12/14/25
95787 11/29/95
37943
99435
Semen
20
30304
52 Kallogg Company
3505
53 Me
8005
7819
120011
325 08
28/25
751.44
125
Mercedes-beny
471 33
2/05/05
Caterpillar
3505
11/16/95
Data
Today'sDate
12/31,05
Cell
Conditional Format
Formatting as Table Styles
Insert
Delete
Format
Sort &
Filter
AA
AN
AC
AQ
Share
Q
Find &
Select L>
!
2
Required information
Part 1 of 2
5
points
Skipped
eBook
Print
References
Question 2
く
ப
Q Search
[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:
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.xlsx
Analyze the Data: Refer to lab 2.1 in your text for additional instructions and steps.
Upload one Word or PDF document containing all of your screenshots for this Lab using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF.
To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment
format.
1. Take a screenshot of the first several rows in the pivot table, paste it into a Word document named "Alt Lab 2.1 Submission", and label the
screenshot Submission 1.
2. Take a screenshot of the Line Chart, paste it into the Word document named "Alt Lab 2.1 Submission", and label the screenshot Submission 2.
L>
Excel File Edit View Insert Format Tools Data Window Help
lab 2.1
g
©
Search
Fri 5:36 PM
8%
Q
EE
Q
AutoSave OFF
ABC...
IBA Lab2-1_Alt_Data
Home
Insert Draw Page Layout
Formulas Data Review View
Tell me
Share
Calibri (Body)
11
A A
Συ
ab Wrap Text
General
× TTX v
v
Av
Paste
B I U▾
Merge & Center
$ % 9
+0.00
Conditional Format Cell
Formatting as Table Styles
Insert Delete
Format
Sort &
Filter
AW73
×
fx
Land of the Fres
The Me Up
5 Land Have Merry
Brewed Awakening
Land Have Merry
The Me Up
Land of the Fres
34 Tegula Mockinge
25 The Cafeter
Land Have Mercy
Panet of the Grapes
Tegula Mockinged
The Tane
Planet of the Grapes
The Tank
The Cafe
The Me Up
>>
Ready
Sheet1
21781 S
480%25
2561
221.428/13/es
22019 8/14/25
250
270.87 4/24/25
13705
456
2075
41.78/21/25
303 42 8/25
+
Accessibility: Investigate
QS Formula Bar
M
All
AG
Comments
Find &
Analyze
Select
Data
50% !
3
Required information
Part 2 of 2
5
points
Skipped
eBook
[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:
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.xlsx
Analyze the Data: Refer to lab 2.1 in your text for additional instructions and steps.
Print
Answer the following questions based on the details computed.
Question
References
1. How many customers have invoices due on 10/13/2025?
2. How many days have invoices due from 3 different customers?
3. What is the total invoice amount due in September, 2025? (Round to 2 decimal places.)
4. What amount is due on 9/29/2025? (Round to 2 decimal places.)
5. What is the total invoice amount due in August, 2025? (Round to 2 decimal places.)
Answer
. AutoSave OFF
ABC ...
IBA Lab2-1 Alt_Data
Formulas Data Review
View
Tell me
11
A A ==
445
Home Insert
Draw Page Layout
X
Pastel
Calibri (Body)
BIU
AW73
x✓ fx
+
הן
499 01/25
172.13025
Tep Magted
2171
The Cher
Tequila Mockingbed
1001 M
50.77
es 40s
20637/11/2
475701/25
17 M
48016/s
779
404
82
14 01/0
2011 AUS
205622
1955 82425
2002 2525
1642 75
23452025
18042
1
2129
05
1216
wwww
29545 52525
Sheet1
31525
+
N
a
Share
Comments
Wrap Text
General
Merge & Center
$ % 9
+000
Conditional Format
Formatting as Table
Cell
Styles
Insert
Delete
Format
Sort &
Find &
Filter
Select
Analyze
Data
w
