Question: Questions for sheet ; Customer InvoiceAmount Due Date IBM 406.57 10/3/2025 PepsiCo 747.12 12/15/2025 Smirnoff 373.59 9/12/2025 3M 1415.76 11/27/2025 Canon 308.63 11/30/2025 Intel Corporation
Questions for sheet ;
| Customer | InvoiceAmount | Due Date |
| IBM | 406.57 | 10/3/2025 |
| PepsiCo | 747.12 | 12/15/2025 |
| Smirnoff | 373.59 | 9/12/2025 |
| 3M | 1415.76 | 11/27/2025 |
| Canon | 308.63 | 11/30/2025 |
| Intel Corporation | 526.42 | 9/29/2025 |
| H&M | 1117.75 | 10/5/2025 |
| American Express | 612.28 | 12/3/2025 |
| Shell Oil Company | 1348.39 | 9/8/2025 |
| Home Depot | 1442.24 | 12/20/2025 |
| Porsche | 890.02 | 9/29/2025 |
| Burberry | 1158.98 | 9/11/2025 |
| AT&T | 439.83 | 11/5/2025 |
| Porsche | 1440.03 | 8/18/2025 |
| Porsche | 999.24 | 9/15/2025 |
| Beko | 1183.68 | 12/8/2025 |
| BMW | 812.62 | 8/16/2025 |
| United Parcel Service | 461.81 | 9/23/2025 |
| Deere & Company | 1011.41 | 10/30/2025 |
| Beko | 653.44 | 8/5/2025 |
| Citigroup | 1204.74 | 8/20/2025 |
| Samsung Group | 1409.63 | 12/12/2025 |
| General Electric | 1478.8 | 7/27/2025 |
| Nokia | 656.28 | 12/3/2025 |
| Citigroup | 1056.92 | 11/27/2025 |
| Xerox | 377.6 | 12/2/2025 |
| Starbucks | 1259.97 | 9/28/2025 |
| Coca-Cola | 1476.09 | 8/14/2025 |
| 3M | 331.8 | 11/24/2025 |
| Ralph Lauren | 1122.46 | 9/5/2025 |
| Porsche | 838.18 | 10/3/2025 |
| The Walt Disney Company | 387.23 | 9/6/2025 |
| KFC | 1389.2 | 9/10/2025 |
| MTV | 685.1 | 10/31/2025 |
| Vodafone | 1424.71 | 9/27/2025 |
| Harley-Davidson | 772.14 | 12/8/2025 |
| Moet et Chandon | 981.87 | 12/14/2025 |
| Canon | 957.07 | 11/29/2025 |
| Yahoo! | 694.29 | 11/15/2025 |
| Avon | 279.42 | 8/21/2025 |
| Gap Inc. | 994.35 | 10/30/2025 |
| VISA | 230.98 | 10/16/2025 |
| Honda Motor Company | 419.86 | 10/8/2025 |
| Kleenex | 1249.67 | 7/27/2025 |
| Audi | 1469.06 | 11/4/2025 |
| Credit Suisse | 541.26 | 9/6/2025 |
| Siemens AG | 1427.79 | 11/22/2025 |
| Intel Corporation | 893.4 | 9/8/2025 |
| Nintendo | 1093.72 | 10/8/2025 |
| Chase | 1031.88 | 11/15/2025 |
| Kellogg Company | 654.88 | 9/6/2025 |
| Microsoft | 289.16 | 8/2/2025 |
| Hermes | 392.53 | 8/17/2025 |
| Zara | 1447.32 | 12/22/2025 |
| Xerox | 899.53 | 8/17/2025 |
| Mastercard | 717.65 | 10/12/2025 |
| Johnson & Johnson | 1385.16 | 11/18/2025 |
| Jack Daniel's | 723.94 | 10/10/2025 |
| Hyundai | 1220.03 | 11/3/2025 |
| Amazon.com | 664.25 | 8/12/2025 |
| eBay | 481.84 | 8/10/2025 |
| L'Oreal | 731.9 | 10/4/2025 |
| Nissan Motor | 1162.88 | 12/11/2025 |
| Johnson & Johnson | 1210.11 | 9/29/2025 |
| Intel Corporation | 715.55 | 8/30/2025 |
| Blackberry | 1369.32 | 8/20/2025 |
| MasterCard | 982.75 | 8/20/2025 |
| Nissan Motor | 325.08 | 10/29/2025 |
| Adidas | 887.48 | 9/28/2025 |
| Siemens AG | 751.44 | 8/16/2025 |
| Mercedes-benz | 471.33 | 7/25/2025 |
| Caterpillar Inc. | 1442.87 | 8/6/2025 |
| Pampers | 1303.01 | 11/19/2025 |
| General Electric | 770.13 | 9/20/2025 |
| Toyota Motor Coporation | 1091.05 | 9/8/2025 |
| Apple Inc. | 848.22 | 10/10/2025 |
| HSBC | 806.86 | 8/13/2025 |
| Bucci | 1110.77 | 7/30/2025 |
| Bucci | 1427.16 | 8/15/2025 |
| eBay | 1180.65 | 8/24/2025 |
| Nintendo | 249.81 | 9/8/2025 |
| Pizza Hut | 768.3 | 8/8/2025 |
| Corona | 810.28 | 10/20/2025 |
| Beko | 1062.48 | 11/21/2025 |
| Oracle Corporation | 1434.44 | 11/13/2025 |
| Morgan Stanley | 1241.01 | 11/6/2025 |
| Google Allianz | 326.61 | 11/3/2025 |
| Toyota Motor Coporation | 894.04 | 8/21/2025 |
| The Walt Disney Company | 364.97 | 9/10/2025 |
| SAP | 288.5 | 8/17/2025 |
| Jack Daniel's | 696.98 | 11/26/2025 |
| Kellogg Company | 296.18 | 7/28/2025 |
| Samsung Group | 438.02 | 9/4/2025 |
| IBM | 1038.16 | 9/25/2025 |
| Mercedes-benz | 960.3 | 8/6/2025 |
| McDonald's | 1004.74 | 12/2/2025 |
| Volkswagen Group | 1139.62 | 10/12/2025 |
| eBay | 834.76 | 12/13/2025 |
| 1054.12 | 10/24/2025 | |
| Kia Motors | 262.04 | 10/10/2025 |
| IBM | 440.72 | 9/4/2025 |
| PepsiCo | 781.68 | 8/23/2025 |
| Smirnoff | 273.55 | 12/6/2025 |
| 3M | 1264.21 | 10/6/2025 |
| Canon | 1020.57 | 10/9/2025 |
| Intel Corporation | 824.93 | 10/16/2025 |
| H&M | 311.53 | 12/15/2025 |
| American Express | 868.49 | 10/20/2025 |
| Shell Oil Company | 1103.29 | 11/9/2025 |
| Home Depot | 710.44 | 10/16/2025 |
| Porsche | 707.28 | 10/3/2025 |
| Burberry | 411.64 | 9/30/2025 |
| AT&T | 755.95 | 9/5/2025 |
| Porsche | 339.92 | 9/16/2025 |
| Porsche | 1309.85 | 12/6/2025 |
| Beko | 336.31 | 11/23/2025 |
| BMW | 1384.21 | 12/16/2025 |
| United Parcel Service | 1234.88 | 10/5/2025 |
| Deere & Company | 506.43 | 8/11/2025 |
| Beko | 993.83 | 11/10/2025 |
| Citigroup | 411.27 | 10/23/2025 |
| Samsung Group | 546.41 | 10/20/2025 |
| General Electric | 1236.73 | 11/15/2025 |
| Nokia | 235.76 | 12/3/2025 |
| Citigroup | 1101.52 | 10/23/2025 |
| Xerox | 1463.2 | 8/9/2025 |
| Starbucks | 684.5 | 10/22/2025 |
| Coca-Cola | 949 | 10/25/2025 |
| 3M | 1117.61 | 11/25/2025 |
| Ralph Lauren | 383.24 | 7/26/2025 |
| Porsche | 1461.73 | 11/28/2025 |
| The Walt Disney Company | 1368.48 | 7/22/2025 |
| KFC | 592.69 | 10/18/2025 |
| MTV | 1135.33 | 10/26/2025 |
| Vodafone | 1053.65 | 11/11/2025 |
| Harley-Davidson | 808.94 | 7/21/2025 |
| Moet et Chandon | 740.98 | 10/29/2025 |
| Canon | 784.24 | 8/11/2025 |
| Yahoo! | 1378.98 | 12/2/2025 |
| Avon | 880.95 | 9/15/2025 |
| Gap Inc. | 623.89 | 8/28/2025 |
| VISA | 1096.4 | 10/23/2025 |
| Honda Motor Company | 720.71 | 9/1/2025 |
| Kleenex | 259.61 | 10/8/2025 |
| Audi | 729.16 | 7/25/2025 |
| Credit Suisse | 810.32 | 8/21/2025 |
| Siemens AG | 1505.35 | 11/3/2025 |
| Intel Corporation | 317.05 | 11/24/2025 |
| Nintendo | 412.91 | 10/12/2025 |
| Chase | 660.57 | 8/14/2025 |
| Kellogg Company | 1116.4 | 8/2/2025 |
| Microsoft | 1225.94 | 11/29/2025 |
| Hermes | 658.05 | 12/14/2025 |
| Zara | 979.4 | 11/15/2025 |
| Xerox | 959.38 | 11/16/2025 |
| Mastercard | 1282.1 | 10/13/2025 |
| Johnson & Johnson | 325.56 | 11/22/2025 |
| Jack Daniel's | 607.87 | 8/25/2025 |
| Hyundai | 1065.24 | 11/27/2025 |
| Amazon.com | 510.38 | 9/1/2025 |
| eBay | 522.79 | 11/17/2025 |
| L'Oreal | 800.47 | 12/14/2025 |
| Nissan Motor | 1037.44 | 12/18/2025 |
| Johnson & Johnson | 349.12 | 10/24/2025 |
| Intel Corporation | 1351.7 | 11/11/2025 |
| Blackberry | 1352.32 | 8/10/2025 |
| MasterCard | 1444.58 | 10/6/2025 |
| Nissan Motor | 631.99 | 10/3/2025 |
| Adidas | 619.12 | 8/15/2025 |
| Siemens AG | 258.13 | 9/17/2025 |
| Mercedes-benz | 707.38 | 8/1/2025 |
| Caterpillar Inc. | 468.63 | 9/28/2025 |
| Pampers | 796.25 | 9/4/2025 |
| General Electric | 1365.88 | 10/20/2025 |
| Toyota Motor Coporation | 746.29 | 8/23/2025 |
| Apple Inc. | 1271.11 | 8/21/2025 |
| HSBC | 293.66 | 8/29/2025 |
| Bucci | 528.29 | 10/19/2025 |
| Bucci | 700.7 | 10/25/2025 |
| eBay | 406.6 | 9/29/2025 |
| Nintendo | 493.27 | 8/28/2025 |
| Pizza Hut | 1259.08 | 12/16/2025 |
| Corona | 1400.18 | 9/30/2025 |
| Beko | 365.46 | 9/24/2025 |
| Oracle Corporation | 302.34 | 8/4/2025 |
| Morgan Stanley | 847.28 | 10/9/2025 |
| Google Allianz | 912.97 | 10/19/2025 |
| Toyota Motor Coporation | 233.8 | 8/19/2025 |
| The Walt Disney Company | 1021.21 | 12/13/2025 |
| SAP | 411.54 | 11/13/2025 |
| Jack Daniel's | 1258.86 | 8/31/2025 |
| Kellogg Company | 571.12 | 11/18/2025 |
| Samsung Group | 1306.32 | 9/11/2025 |
| IBM | 262.1 | 12/8/2025 |
| Mercedes-benz | 1018.25 | 12/12/2025 |
| McDonald's | 652.11 | 10/19/2025 |
| Volkswagen Group | 566.79 | 8/20/2025 |
| eBay | 1036.24 | 10/21/2025 |
| 1300.85 | 11/18/2025 | |
| Kia Motors | 375.42 | 12/6/2025 |
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.XIsX 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.xIsx. 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. Answer the following questions based on the details computed
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help