File Edit View Insert Format Tools Data Window Help 39 A AutoSave OFF A B Home Insert Draw Page Layout Formulas Data Review View Automate Lab 2-1 Alt Data (2) Developer Tell me Calibri (Body) 11 AA = Paste A2 BIUS xfx We Fry it All Wrap Text General Merge & Center v $ %" D A B C 1 customer 2 Ve Fry it All InvoiceAmount Due Date 269.65 7/21/21 3 Ve Fry it All 456.16 7/22/21 4 aste of Thai 157.11 7/25/21 5 Grandma's Greasy Spoon 243.05 7/25/21 6 rewed Miracles 127.75 7/26/21 7 randma's Greasy Spoon 416.56 7/27/21 8 aste of Thail 492.93 7/27/21 9 ita Pan 98.73 7/28/21 10 Ve Fry it All 370.26 7/30/21 11 Ve Fry it All 235.79 8/1/21 12 Vok Delight 96.39 8/2/21 13 One in a Million 372.13 8/2/21 14 equila Taste 100.78 8/4/21 15 Ve Fry it All 217.81 8/5/21 16 ita Pan 320.1 8/6/21 17 ita Pan 480.96 8/6/21 18 One in a Million 256.1 8/8/21. 19 lanet of the Grapes 487.73 8/9/21 20 Grandma's Greasy Spoon 160.61 8/10/21 21 ita Pan 450.77 8/10/21 E A ABC #insert Delete Conditional Format Cel Formatting as Table Styles - Format v F Today's Dat G 12/31/21 File Edit View Insert Format Tools AutoSave OFF Data Window Help C Home Insert Draw Page Layout Formulas Data Review View Automate Calibri (Body) 11 A = Paste B I U v Lab 2-1 Alt Data (2) Developer Tell met Wrap Text General Merge & Center v $ % 9 A2 21 Pita Pan fx We Fry it All 22 Wok Delight A B C D 450.77 8/10/21 168.81 8/11/21 23 Wok Delight 261.41 8/11/21 24 Taste of Thai 221.42 8/12/21 25 Tequila Taste 268.95 8/13/21 26 The Godfather 220.19 8/14/21 27 The Godfather 492.03 8/14/21 28 Wok Delight 206.37 8/15/21 29 Tequila Taste 475.72 8/15/21 30 Tequila Taste 250.48 8/16/21 31 Brewed Miracles 270.87 8/16/21 32 Soup 'r Salad 96.17 8/17/21 33 Taste of Thai 130.84 8/17/21 34 Taste of Thai 299.84 8/17/21 35 Wok Delight 480.01 8/18/21 36 Pita Pan 77.93 8/19/21 37 Brewed Miracles 188.93 8/20/21 38 One in a Million 327.58 8/20/21 39 Tequila Taste 401.58 8/20/21 40 One in a Million 41 Grandma's Greasy Spoon 456.44 8/20/21 93.14 8/21/21 370 44 0/24/24 Sheet1 + AutoSave OFF 60 Lab 2-1 Alt Data (2) Developer Tell me Home Insert Draw Page Layout Formulas Data Review View Automate Calibri (Body) 11 A A Wrap Text General Paste BIU v Av Merge & Center $ - % A2 xvfx We Fry it All A B C D 41 Grandma's Greasy Spoon 93.14 8/21/21 42 Planet of the Grapes 270.11 8/21/21 43 The Godfather 298.01 8/21/21 44 Tequila Taste 423.7 8/21/21 45 Thai Tap 248.76 8/23/21 46 The Godfather 260.56 8/23/21 47 Thai Tap 393.55 8/24/21 48 Grandma's Greasy Spoon 202.62 8/25/21 49 Soup 'r Salad 164.42 8/28/21 95 50 Thai Tap 207.96 8/28/21 51 Thai Tap 97.89 8/29/21 52 Planet of the Grapes 238.52 8/30/21 53 Soup 'r Salad 419.62 8/31/21 54 Thai Tap 170.13 9/1/21 55 The Godfather 240.24 9/1/21 56 We Fry it All 146.01 9/4/21 57 Planet of the Grapes 146.91 9/4/21 58 Thai Tap 265.42 9/4/21 59 We Fry it All 251.98 9/5/21 60 The Godfather 374.15 9/5/21 61 The Godfather 52 Ann in Millian 129.08 9/6/21 100 12 0/6/21 4 Sheet1 + Ready T Accessibility: Investigate Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Automate Paste A2 Calibri (Body) BIU Xfx We Fry it All 11 A A = Lab 2-1 Alt Data (2) Developer Tell n General Wrap Text Merge & Center v $ % 9 A B. C D 61 The Godfather 62 One in a Million 129.08 9/6/21 180.42 9/6/21 63 One in a Million 218.29 9/6/21 64 We Fry it All 83.27 9/8/21 65 Brewed Miracles 297.8 9/8/21 66 Soup 'r Salad 363.68 9/8/21 67 Wok Delight 449.46 9/8/21 68 Pita Pan 121.66 9/10/21 69 Taste of Thai 463.07 9/10/21 70 Soup 'r Salad 386.33 9/11/21 71 Brewed Miracles 435.44 9/11/21 72 We Fry it All 124.53 9/12/21 73 We Fry it All 293.65 9/15/21 74 The Godfather 333.08 9/15/21 75 Wok Delight 113.31 9/16/21 76 One in a Million 86.04 9/17/21 77 Planet of the Grapes 256.71 9/20/21 78 Brewed Miracles 153.94 9/23/21 79 Tequila Taste 121.82 9/24/21 80 One in a Million 81 Pita Pan 346.05 9/25/21 474.9 9/27/21 < Ready Sheet1 * Acconcibiliti cel File Edit View Insert Format Tools Data Window Help AutoSave OFF Insert Draw Page Layout Formulas Data Review View Home X Calibri (Body) Pastel B I U v 11 A A v v Tu 101 1010 Automate Lab 2-1 Alt Data (2) Developer General Tell me Wrap Text Merge & Center $ % 9 v A2 81 Pita Pan A fx We Fry it All B C D 474.9 9/27/21 82 The Godfather 156.21 9/28/21 83 One in a Million 295.83 9/28/21 84 Thai Tap 419.99 9/28/21 85 Grandma's Greasy Spoon 135.53 9/29/21 86 Tequila Taste 175.47 9/29/21 87 Planet of the Grapes 296.67 9/29/21 88 We Fry it All 403.37 9/29/21 89 Thai Tap 137.21 9/30/21 90 Grandma's Greasy Spoon 466.73 9/30/21 91 Wok Delight 135.52 10/3/21 92 Pita Pan 210.66 10/3/21 93 Tequila Taste 235.76 10/3/21 94 Wok Delight 279.39 10/3/21 95 Soup 'r Salad 243.97 10/4/21 96 Brewed Miracles 372.58 10/5/21 97 Brewed Miracles 411.63 10/5/21 98 Pita Pan 421.4 10/6/21 99 Tequila Taste 481.53 10/6/21 100 Planet of the Grapes 86.54 10/8/21 101 Tequila Taste 139.95 10/8/21 Sheet1 + cel File Edit View Insert Format Home Tools Data Window Help AutoSave OFF C Insert Draw Page Layout Formulas Data Review View Calibri (Body) v Paste BIU 11 AA A Automate Lab 2-1 Alt Data (2) Developer Tell me General Wrap Text Merge & Center v $ % 9 A2 fx We Fry it All A B C D 101 Tequila Taste 102 Wok Delight 139.95 10/8/21 364.57 10/8/21 103 Thai Tap 282.43 10/9/21 104 Wok Delight 340.19 10/9/21 105 Brewed Miracles 87.35 10/10/21 106 Taste of Thai 241.31 10/10/21 107 Pita Pan 282.74 10/10/21 108 Pita Pan 137.64 10/12/21 109 Brewed Miracles 239.22 10/12/21 110 Grandma's Greasy Spoon 379.87 10/12/21 111 We Fry it All 427.37 10/13/21 112 Thai Tap 76.99 10/16/21 113 One in a Million 236.81 10/16/21 114 The Godfather 115 Taste of Thai 274.98 10/16/21 197.56 10/18/21 116 We Fry it All 176.1 10/19/21 117 Tequila Taste 217.37 10/19/21 118 Grandma's Greasy Spoon 304.32 10/19/21 119 Planet of the Grapes 182.14 10/20/21 120 One in a Million 270.09 10/20/21 121 Tequila Taste 289.5 10/20/21 ACE 30 10/20/21 Sheet1 + AutoSave OFF Home Insert Draw Page Layout Formulas Data Review Calibri (Body) 11 A A == v Paste B I U v A View Automate Wrap Text Lab 2-1 Alt Data (2) Developer Tell me General Merge & Center V $ % 9 A2 xfx We Fry it All A B. C D 121 Tequila Taste 289.5 10/20/21 122 Tequila Taste 455.29 10/20/21 123 Tequila Taste 345.41 10/21/21 124 Grandma's Greasy Spoon 228.17 10/22/21 125 Soup 'r Salad 137.09 10/23/21 126 Thai Tap 365.47 10/23/21 127 Pita Pan 367.17 10/23/21 128 Thai Tap 116.37 10/24/21 129 Brewed Miracles 351.37 10/24/21 130 Pita Pan 233.57 10/25/21 131 Soup 'r Salad 316.33 10/25/21 132 Taste of Thai 378.44 10/26/21 133 Brewed Miracles 108.36 10/29/21 134 Wok Delight 246.99 10/29/21 135 Brewed Miracles 331.45 10/30/21 136 Grandma's Greasy Spoon 337.14 10/30/21 137 Soup 'r Salad 228.37 10/31/21 138 Taste of Thai 108.87 11/3/21 139 One in a Million 406.68 11/3/21 140 Grandma's Greasy Spoon 501.78 11/3/21 141 Brewed Miracles 489.69 11/4/21 Sheet1 Ready insen Format Tools Data Window Help AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Automate Calibri (Body) 11 A A Wrap Text Lab 2-1 Alt Data (2) Developer Tell General Paste B I U v A Merge & Center v v $ % 9 A2 fx We Fry it All A B w. C D 141 Brewed Miracles 142 One in a Million 143 Taste of Thai 489.69 11/4/21 146.61 11/5/21 413.67 11/6/21 144 Tequila Taste 367.76 11/9/21 145 Planet of the Grapes 331.28 11/10/21 146 Planet of the Grapes 351.22 11/11/21 147 Thai Tap 450.57 11/11/21 148 Wok Delight 137.18 11/13/21 149 One in a Million 478.15 11/13/21 05 150 Wok Delight 231.43 11/15/21 151 Tequila Taste 326.47 11/15/21 152 Pita Pan 343.96 11/15/21 153 The Godfather 412.24 11/15/21 154 Thai Tap 319.79 11/16/21 155 Pita Pan 174.26 11/17/21 156 The Godfather 190.37 11/18/21 157 One in a Million 433.62 11/18/21 158 The Godfather 461.72 11/18/21 159 Planet of the Grapes 434.34 11/19/21 160 Taste of Thai 354.16 11/21/21 161 The Godfather 108.52 11/22/21 162 We En it All 47593 11/22/21 Sheet1 + Ready Accessibility: Investigate File Edit View Insert Format Tools Data Window Help AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Automate Lab 2-1 Alt Data (2) Developer Tell me Calibri (Body) 11 A A Wrap Text General Paste BIU A Merge & Center $ % A2 fx We Fry it All A B C D 161 The Godfather 108.52 11/22/21 162 We Fry it All 475.93 11/22/21 163 Soup 'r Salad 112.1 11/23/21 164 Planet of the Grapes 105.68 11/24/21 165 Grandma's Greasy Spoon 110.6 11/24/21 166 Planet of the Grapes 372.54 11/25/21 167 Thai Tap 232.33 11/26/21 168 The Godfather 352.31 11/27/21 169 Grandma's Greasy Spoon 355.08 11/27/21 170 Thai Tap 471.92 11/27/21 171 One in a Million 487.24 11/28/21 172 Wok Delight 319.02 11/29/21 173 Planet of the Grapes 408.65 11/29/21 174 We Fry it All 102.88 11/30/21 175 Planet of the Grapes 125.87 12/2/21 176 Taste of Thai 334.91 12/2/21 177 Planet of the Grapes 459.66 12/2/21 178 Tequila Taste 78.59 12/3/21 179 Soup 'r Salad 204.09 12/3/21 180 Planet of the Grapes 218.76 12/3/21 181 Taste of Thai 91.18 12/6/21 Sheet1 + Ready 17 AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Automate Calibri (Body) 11 v A A Pastel BIU 4A 101 1010 A2 fx We Fry it All Lab 2-1 Alt Data (2) Developer Tell me Wrap Text General Merge & Center v $ % 9 A B C D 181 Taste of Thai 182 One in a Million 91.18 12/6/21 125.14 12/6/21 183 The Godfather 436.62 12/6/21 184 The Godfather 87.37 12/8/21 185 Brewed Miracles 257.38 12/8/21 186 Pita Pan 394.56 12/8/21 187 Wok Delight 387.63 12/11/21 188 Soup 'r Salad 339.42 12/12/21 189 Wok Delight 469.88 12/12/21 190 Taste of Thai 278.25 12/13/21 191 Thai Tap 340.4 12/13/21 192 Brewed Miracles 219.35 12/14/21 193 Pita Pan 266.82 12/14/21 194 We Fry it All 327.29 12/14/21 195 One in a Million 103.84 12/15/21 196 Pita Pan 249.04 12/15/21 197 Wok Delight 419.69 12/16/21 198 Brewed Miracles 461.4 12/16/21 199 We Fry it All 345.81 12/18/21 200 Thai Tap 480.75 12/20/21 201 We Fry it All 482.44 12/22/21 Sheet1 + Ready Accessibility: Investigate 01. Required information [The following information applies to the questions displayed below.] Required: 1. Summarize the late accounts receivable by customer. Show the PivotTable. 2. Get the detailed receivables for the customer "Thai Tap." Ask the Question: How can we use PivotTables on the total detailed accounts receivables balance to get specific detail on Invoices due by customer? Master the Data: To begin, we have a list of 200 receivables on specific invoices that are all past their due date as of today's date of 12/31/2021. This is shown in the Excel file Lab 2-1 Data.xlsx. Software needed . Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-1 Alt Data.xlsx Perform the Analysis: Refer to Lab 2-1 Alternative in the text for instructions and Lab 2-1 steps for each of the lab parts. Share the Story: Now that we have the detail by customer, we can better follow up with them to help with collections. All employees interfacing with the client should have this detail when they talk and interact with that specific customer. Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. 1. Take a screenshot of the top 20 rows listing the total amount due by customer (from the PivotTable), and label it "Lab 2-1 Alt Submission 1" 2. Take a screenshot of Thai Tap invoices due, and label it "Lab 2-1 Alt Submission 2" upload a response file (15MB max) Required: 1. To get the pivot table summarizing invoice amounts by customer, the pivot table should have which specifications? Rows: [Days Late]; Values: [Customer] Rows: [Customer]; Values: [Days Late] Rows: [Customer]; ZValues: [Invoice Amount] Rows: [Invoice Amount]; [Values: [Customer] 2. What is the total receivables due for the customer Wok Delight? $5,107.25 O $3,958.44 O $7,732.45 $4,499.08 3. Which customer owes $3,935.20? Soup 'r Salad We Fry it All O Grandma's Greasy Spoon O The Godfather 4. How many detailed invoices does Thai Tap have? 18 17 20 21 5. What is the due date of the earliest invoice (most days past due) for Thai Tap included? O8/23/21 O8/24/21 9/4/21 O 8/21/21