Required information (The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Calculate the grand totals of Customer Count, Sum of Invoice Amount, and Count of Due Date. 2. Subtotal the accounts receivable by date in a pivot table. Ask the Question: How do data types affect the way I can analyze data in Excel? Master the Data: To begin, we have a list of 200 receivables that are all past their due date as of today's date of 12/31/2021. This is shown in the Excel file Lab 3-1 Data.xlsx. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 3-1 Alt Data.xlsx Perform the Analysis: Refer to Lab 3-1 Alternate in the text for instructions and Lab 3-1 steps for each of the lab parts. Share the Story: You have analyzed the data types in this report, viewed summary statistics in Excel's status bar, and created summary statistics using Excel's pivot tables. Part 1: Upload Your Files Part 2: Assessment E Today's Date 1 1 Customer 2 Lord of the Fries 3 Lord of the Fries 4 Thai Me Up 5 Lard Have Mercy 6 Brewed Awakening 7 Lard Have Mercy 8 Thai Me Up 9 Pita Pan 10 Lord of the Fries 11 Lord of the Fries 12 Wok this Way 13 Juan in a Million 14 Tequila Mockingbird 15 Lord of the Fries 16 Pita Pan 17 Pita Pan 18 Juan in a Million 19 Planet of the Grapes 20 Lard Have Mercy 21 Pita Pan 22 Wok this Way 23 Wok this Way 24 Thai Me Up 25 Tequila Mockingbird 26 The Codfather 27 The Codfather 28 Wok this Way 29 Tequila Mockingbird 30 Tequila Mockingbird 31 Brewed Awakening InvoiceAmount Due Date 269.65 7/21/21 456.16 7/22/21 157.11 7/25/21 243.05 7/25/21 127.75 7/26/21 416.56 7/27/21 492.93 7/27/21 98.73 7/28/21 370.26 7/30/21 235.79 8/1/21 96.39 8/2/21 372.13 8/2/21 100.78 8/4/21 217.81 8/5/21 320.1 8/6/21 480.96 8/6/21 256.1 8/8/21 487.73 8/9/21 160.61 8/10/21 450.77 8/10/21 168.81 8/11/21 261.41 8/11/21 221.42 8/12/21 268.95 8/13/21 220.19 8/14/21 492.03 8/14/21 206.37 8/15/21 475.72 8/15/21 250.48 8/16/21 270.87 8/16/21 U21 2 Nin Com Soup 3 Thai Me Up 34 Thai Me Up 35 Wok this Way 6 Pita Pan 7 Brewed Awakening 8 Juan in a Million 9 Tequila Mockingbird 0 Juan in a Million 11 Lard Have Mercy 12 Planet of the Grapes 13 The Codfather 14 Tequila Mockingbird 5 Thai Tanic 6 The Codfather 7 Thai Tanic 18 Lard Have Mercy 19 Nin Com Soup 0 Thai Tanic 1 Thai Tanic -2 Planet of the Grapes 3 Nin Com Soup 4 Thai Tanic 55 The Codfather 6 Lord of the Fries -7 Planet of the Grapes 78 Thai Tanic 9 Lord of the Fries 50 The Codfather 1 The Codfather -2 96.17 130.84 299.84 480.01 77.93 188.93 327.58 401.58 456.44 93.14 270.11 298.01 423.7 248.76 260.56 393.55 202.62 164.42 207.96 97.89 238.52 419.62 170.13 240.24 146.01 146.91 265.42 251.98 374.15 8/17/21 8/17/21 8/17/21 8/18/21 8/19/21 8/20/21 8/20/21 8/20/21 8/20/21 8/21/21 8/21/21 8/21/21 8/21/21 8/23/21 8/23/21 8/24/21 8/25/21 8/28/21 8/28/21 8/29/21 8/30/21 8/31/21 9/1/21 9/1/21 9/4/21 9/4/21 9/4/21 9/5/21 9/5/21 9/6/21 916/21 129.08 Duanin Million 1912 63 Juan in a Million 64 Lord of the Fries 65 Brewed Awakening 66 Nin Com Soup 67 Wok this Way 68 Pita Pan 69 Thai Me Up 70 Nin Com Soup 71 Brewed Awakening 72 Lord of the Fries 73 Lord of the Fries 74 The Codfather 75 Wok this Way 76 Juan in a Million 77 Planet of the Grapes 78 Brewed Awakening 79 Tequila Mockingbird 80 Juan in a Million 81 Pita Pan 82 The Codfather 83 Juan in a Million 84 Thai Tanic 85 Lard Have Mercy 86 Tequila Mockingbird 87 Planet of the Grapes 88 Lord of the Fries 89 Thai Tanic 90 Lard Have Mercy 91 Wok this Way 92 Pita Pan 93 Tequila Mockingbird 218.29 83.27 297.8 363.68 449.46 121.66 463.07 386.33 435.44 124.53 293.65 333.08 113.31 86.04 256.71 153.94 121.82 346.05 474.9 156.21 295.83 419.99 135.53 175.47 296.67 403.37 137.21 466.73 135.52 210.66 235.76 9/6/21 9/8/21 9/8/21 9/8/21 9/8/21 9/10/21 9/10/21 9/11/21 9/11/21 9/12/21 9/15/21 9/15/21 9/16/21 9/17/21 9/20/21 9/23/21 9/24/21 9/25/21 9/27/21 9/28/21 9/28/21 9/28/21 9/29/21 9/29/21 9/29/21 9/29/21 9/30/21 9/30/21 10/3/21 10/3/21 10/3/21 386.33 435.44 124.53 293.65 333.08 113.31 86.04 256.71 153.94 121.82 346.05 Soup 'r Salad Brewed Miracles We Fry it All We Fry it All The Godfather Wok Delight 5 One in a Million Planet of the Grapes Brewed Miracles Tequila Taste One in a Million Pita Pan The Godfather One in a Million Thai Tap Grandma's Greasy Spoon Tequila Taste Planet of the Grapes We Fry it All - Thai Tap Grandma's Greasy Spoon Wok Delight Pita Pan Tequila Taste Wok Delight Soup 'r Salad Brewed Miracles Brewed Miracles 3 Pita Pan Tequila Taste o Planet of the Grapes 1 Tequila Taste 2 Wok Delight 3 Thai Tap 474.9 156.21 295.83 419.99 135.53 175.47 296.67 403.37 137.21 466.73 135.52 210.66 235.76 279.39 243.97 372.58 411.63 421.4 481.53 86.54 139.95 364.57 282.43 9/11/21 9/11/21 9/12/21 9/15/21 9/15/21 9/16/21 9/17/21 9/20/21 9/23/21 9/24/21 9/25/21 9/27/21 9/28/21 9/28/21 9/28/21 9/29/21 9/29/21 9/29/21 9/29/21 9/30/21 9/30/21 10/3/21 10/3/21 10/3/21 10/3/21 10/4/21 10/5/21 10/5/21 10/6/21 10/6/21 10/8/21 10/8/21 10/8/21 10/9/21 125 Nin Com Soup 126 Thai Tanic 127 Pita Pan 128 Thai Tanic 129 Brewed Awakening 130 Pita Pan 131 Nin Com Soup 132 Thai Me Up 133 Brewed Awakening 134 Wok this Way 135 Brewed Awakening 136 Lard Have Mercy 137 Nin Com Soup 138 Thai Me Up 139 Juan in a Million 140 Lard Have Mercy 141 Brewed Awakening 142 Juan in a Million 143 Thai Me Up 144 Tequila Mockingbird 145 Planet of the Grapes 146 Planet of the Grapes 147 Thai Tanic 148 Wok this Way 149 Juan in a Million 150 Wok this Way 151 Tequila Mockingbird 152 Pita Pan 153 The Codfather 154 Thai Tanic 155 Pita Pan 137.09 365.47 367.17 116.37 351.37 233.57 316.33 378.44 108.36 246.99 331.45 337.14 228.37 108.87 406.68 501.78 489.69 146.61 413.67 367.76 331.28 351.22 450.57 137.18 478.15 231.43 326.47 343.96 412.24 319.79 174.26 10/23/21 10/23/21 10/23/21 10/24/21 10/24/21 10/25/21 10/25/21 10/26/21 10/29/21 10/29/21 10/30/21 10/30/21 10/31/21 11/3/21 11/3/21 11/3/21 11/4/21 11/5/21 11/6/21 11/9/21 11/10/21 11/11/21 11/11/21 11/13/21 11/13/21 11/15/21 11/15/21 11/15/21 11/15/21 11/16/21 11/17/21 156 The Codfather 157 Juan in a Million 158 The Codfather 159 Planet of the Grapes 160 Thai Me Up 161 The Codfather 162 Lord of the Fries 163 Nin Com Soup 164 Planet of the Grapes 165 Lard Have Mercy 166 Planet of the Grapes 167 Thai Tanic 168 The Codfather 169 Lard Have Mercy 170 Thai Tanic 171 Juan in a Million 172 Wok this Way 173 Planet of the Grapes 174 Lord of the Fries 175 Planet of the Grapes 176 Thai Me Up 177 Planet of the Grapes 178 Tequila Mockingbird 179 Nin Com Soup 180 Planet of the Grapes 181 Thai Me Up 182 Juan in a Million 183 The Codfather 184 The Codfather 185 Brewed Awakening 186 Pita Pan 190.37 433.62 461.72 434.34 354.16 108.52 475.93 112.1 105.68 110.6 372.54 232.33 352.31 355.08 471.92 487.24 319.02 408.65 102.88 125.87 334.91 459.66 78.59 204.09 218.76 91.18 125.14 436.62 87.37 257.38 394.56 11/18/21 11/18/21 11/18/21 11/19/21 11/21/21 11/22/21 11/22/21 11/23/21 11/24/21 11/24/21 11/25/21 11/26/21 11/27/21 11/27/21 11/27/21 11/28/21 11/29/21 11/29/21 11/30/21 12/2/21 12/2/21 12/2/21 12/3/21 12/3/21 12/3/21 12/6/21 12/6/21 12/6/21 12/8/21 12/8/21 12/8/21 187 Wok this Way 188 Nin Com Soup 189 Wok this Way 190 Thai Me Up 191 Thai Tanic 192 Brewed Awakening 193 Pita Pan 194 Lord of the Fries 195 Juan in a Million 196 Pita Pan 197 Wok this Way 198 Brewed Awakening 199 Lord of the Fries 200 Thai Tanic 201 Lord of the Fries 387.63 339.42 469.88 278.25 340.4 219.35 266.82 327.29 103.84 249.04 419.69 461.4 345.81 12/11/21 12/12/21 12/12/21 12/13/21 12/13/21 12/14/21 12/14/21 12/14/21 12/15/21 12/15/21 12/16/21 12/16/21 12/18/21 12/20/21 12/22/21 480.75 482.44 Required: 1. What is the Data Type of the Customer column in this dataset? O Nominal O Ratio O Ordinal O Interval 2. What is the Data Type of the Invoice Amount column in this dataset? O Ordinal O Interval Nominal O Ratio 3. Select the summary measure(s) that is/are provided for the InvoiceAmount column in Excel's status bar. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answers and double click the box with the question mark to empty the box for a wrong answers. Any boxes left with a question mark will be automatically graded as incorrect.) ? Count ? Proportion ? Average ? Sum nnnnnnnnn 4. How many Customer invoices are due on 8/20/2021? 01 4 2 3 5. What is the grand total of all invoices due? 200 808.94 56,381.41 169,144.34