Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home
AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA = F V v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v DV Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 X V fx London Auto Centre 3 C D E F G H J K L M N O P Q R S T London Auto Centre! 3 Employee Salary per Week Day Date Employee Labour Sales Parts Sales Jim 1, 100.00 Thu 14-03-2024 423.15 120.96 5 Karl 875.0 Tue 28-05-202 Amanda 156.10 27.33 6 Amanda 925.00 Tue 23-04-202 Amanda 562.87 190.91 Mark 975.00 Fri 19-04-202 Karl 319.48 155.42 Mon 05-02-202 Karl 328.35 31.48 Hourly Shop Rate $ 65.00 Wed 29-05-202 Amanda 503.72 93.76 10 Profit Margin on Parts 15% Wed 21-02-2024 Mark 379.99 168.51 Thu 14-03-202 Karl 366.06 127.91 12 The garage is open Monday to Saturday 8:00 a.m. to 5:00 p.m. Wed 17-04-2024 Mark 356.54 101.71 Wed 10-04-202 Amanda 571.46 227.45 There are 4 employees Thu 25-01-202 Mark 288.22 80.16 15 Thu 02-05-202 Karl 366.32 128.63 16 They are paid a weekly salary as shown above Mon 04-03-202 Amanda 394.98 37.46 Thu 22-02-202 Amanda 531.97 67.92 18 Each employee has a one hour lunch break and one 15 minute Sat 24-02-202 Mark 393.54 33.50 9 break in the morning and one 15 minute break in the afternoon Sat 7-01-202 Amanda 146.47 98.40 Wed 28-02-2024 Mark 254.74 129.20 The employees are assigned the work as it comes in and Fri 5-03-2024 Amanda 553.91 53.89 all employees can do all of the required work. Fri 15-03-2024 Jim 542.95 110.12 Wed 03-01-2024 Jim 388.61 94.98 Labour sales are calculated based upon the time it takes to Sat 03-02-202 Amanda 476.54 94.93 do the work times the hourly shop rate. Tue 9-03-2024 Karl 319.04 154.26 Thu 1-03-2024 Jim 423.07 120.71 Parts sales will vary depending upon the type of work being Thu 21-03-2024 Mark 29.48 41.22 done on the vehicle. The employee only identifies what parts Mon 29-04-2024 Amanda 473.44 84.28 are needed and the shop owner, Tom, determines the selling Fri 26-01-2024 Jim 485.28 125.60 price to obtain the 15% profit margin on parts' sales Sat 02-03-2024 Karl 304.20 16.94 Tue 27-02-202 Mark 427.20 133.88 When comparing different garages close to his Tom found that Mon 15-04-2024 Jim 278.42 31.71 the average shop rates in those garages varied from $55.00 per Wed 28-02-2024 Amanda 398.44 47.14 hour to a maximum of $95.00 per hour. Fri 31-05-2024 Jim $69.15 217.51 Mon 11-03-2024 Jim 205.44 128.95 Wed 21-02-2024 Jim 398.34 46.84 Thu 1-02-2024 Amanda 502.37 188.61 Wed 05-06-2024 Karl 59.41 109.47 Thu 29-02-2024 Kar 345.37 72.55 Thu 4-01-2024 Mark 507.36 207.77 Fri 07-06-2024 Jim 386.98 189.91 Wed 4-02-2024 Mark 495.75 163.70 Mon 13-05-2024 Amanda 549.64 136.64 Wed 3-04-202 Mark 424.78 126.14 45 Tue 19-03-2024 Jim 22.74 119.67 Tue 23-01-2024 Mark 519 77 256 93 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA - V v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v DV Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 X V fx London Auto Centre A B C D E F G H J K L M N O P Q R S T 46 Tue 23-01-2024 Mark 19.77 56.93 47 Mon 01-04-2024 Amanda 399.53 50.20 48 Wed 13-03-2024 Mark 237.64 93.99 49 Thu 16-05-2024 Mark 104.70 65.03 50 Tue 13-02-2024 Karl 311.45 134.78 Fri 05-04-2024 Amanda 554.16 154.89 Mon 27-05-2024 Karl 348.35 80.16 Wed 17-04-202 Kar 318.06 151.69 Mon 08-04-202 Amanda $51.60 144.50 Tue 26-03-2024 Jim 415.22 96.36 Fri 10-05-2024 Karl 85.14 73.48 Fri 26-01-2024 Mark 407.41 72.96 Mon 05-02-2024 Amanda 532.77 70.94 Thu 15-02-2024 Amanda 515.96 241.60 Mon 03-06-2024 Jim 92.01 78.36 Sat 20-04-2024 Jim 508.65 12.77 Tue 05-03-2024 Mark 393.16 32.46 Mon 08-01-2024 Karl 261.34 26.28 Sat 01-06-2024 Jim 521.76 30.21 Wed 24-04-2024 Jim 413.78 91.96 Fri 19-01-2024 Mark 201.06 32.29 Wed 08-05-2024 Mark 481.60 12.55 68 Fri 15-03-2024 Mark 294.62 94.45 Mon 06-05-2024 Amanda 506.90 205.97 Fri 08-03-202 Karl 382.78 176.96 Tue 23-04-2024 Mark 266.27 35.41 Tue 06-02-2024 Amanda 405.86 68.42 Wed 06-03-2024 Mark 504.31 196.02 Tue 16-04-2024 Karl 304.89 118.60 Mon 5-01-2024 Karl 287.13 7.77 Fri 24-05-2024 Mark 433.78 155.33 Sat 01-06-2024 Kar 323.41 165.83 Wed 24-04-2024 Mark 454.53 226.89 Sat 11-05-2024 Mark 250.37 119.83 Tue 30-01-2024 Amanda 544.74 117.15 Fri 05-04-2024 Jim $21.55 29.46 Tue 21-05-2024 Mark 340.16 59.56 Fri 29-03-2024 N/A - Good Friday N/A - Good Friday Wed 03-04-202 Amanda 512.05 226.10 Tue 14-05-2024 Mark 27.83 75.64 Tue 04-06-202 Amanda 514.85 237.17 Thu 28-03-202 Mark 275.06 52.52 Tue 16-01-202 Amanda 193.15 154.11 Mon 03-06-2024 Karl 31.62 39.04 Wed 15-05-2024 Jim 546.11 22.58 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA E v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v DV Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 XV fx London Auto Centre A B C D E F G H J K L M N O P Q R S T 90 Wed 5-05-2024 Jim 546.11 22.58 Fri 01-03-2024 Amanda 436.38 163.97 Tue 6-03-202 Mark 373.06 147.98 Mon 18-03-2024 Jim 237.30 23.34 Wed 7-03-2024 Karl 293.10 91.02 Tue 23-01-2024 Amanda 510.96 221.80 Fri 9-03-2024 Amanda N/A - Good Friday N/A - Good Friday Wed 10-01-2024 Amanda 429.28 140.58 Fri 2-01-2024 Karl 265.71 34.36 Wed 22-05-2024 Amanda 506.50 204.42 Fri 2-01-2024 Amanda 497.19 169.07 Wed 06-03-2024 Amanda 404.11 63.33 Wed 27-03-2024 Mark 362.30 1 17.40 Sat 06-04-2024 Mark 359.91 110.83 Tue 23-04-2024 Kar 381.82 174.04 Wed 28-02-2024 Karl 263.21 29.69 Tue 14-05-2024 Karl 339.45 57.82 Thu 08-02-2024 Amanda 521.10 27.83 Thu 14-03-202 Amanda 147.20 200.95 Mon 19-02-2024 Mark N/A - Family Day |N/A - Family Day Mon 4-03-202 Karl 348.58 80.77 Thu 16-05-202 Amanda 404.74 65.15 Sat 25-05-202 Amanda 481.86 13.45 Tue 19-03-2024 Mark 212.42 49.47 Sat 18-05-2024 Mark 231.28 81.93 Tue 2-04-2024 Jim 388.88 195.83 Wed 10-01-2024 Jim 361.59 15.44 Fri 16-02-2024 Karl 281.50 65.74 Wed 08-05-2024 Jim 557.90 170.25 Sat 6-04-2024 Jim 563.83 94.95 Sat 16-03-2024 Mark 244.76 108.17 Mon 15-04-2024 Amanda 413.09 89.88 Sat 13-01-2024 Jim 398.26 46.63 Fri 26-04-2024 Jim 566.67 206.95 Thu 02-05-2024 Mark 209.89 45.48 Mon 01-04-2024 Mark 298.48 103.36 Sat 02-03-2024 Jim 434.18 156.63 Thu 21-03-2024 Amanda 556.02 162.52 Mon 26-02-2024 Jim 208.66 47.19 Thu 16-05-2024 Jim 552.21 146.99 Thu 09-05-2024 Jim 18.05 249.97 Tue 04-06-202 Jim 548.39 131.61 Thu 06-06-2024 Karl 84.62 72.37 Mon 27-05-2024 Amanda 524.92 41.72 Mon 20-05-2024 Karl N/A - Victoria Day N/A - Victoria Day Thu 18-04-2024 Amanda 478.90 103.08 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA E v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v DV Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 XV fx London Auto Centre A B C D E F G H J K L M N O P Q R S T 134 Mon 20-05-2024 Karl N/A - Victoria Day |N/A - Victoria Day 135! Thu 18-04-2024 Amanda 478.90 103.08 Sat 20-01-2024 Mark 512.50 27.88 Thu 29-02-2024 250.38 1 19.85 Thu 02-05-2024 Jim 458.47 34.86 Wed 03-01-2024 Amanda 478.29 100.95 Wed 20-03-2024 Jim 52.84 Fri 05-01-2024 Amanda 151.50 216.09 Wed 07-02-2024 Karl 356.34 01.17 Wed 21-02-2024 Karl 346.09 74.37 Thu 25-01-2024 Karl 314.56 42.67 Sat 03-02-2024 Mark 459.76 39.00 Tue 02-04-2024 Mark 329.77 34.75 Wed 10-01-2024 Mark 504.66 97.35 Fri 26-04-2024 Mark 296.01 97.65 Tue 09-04-2024 Amanda 419.72 110.22 Fri 0-05-2024 Jim 431.77 148.72 Wed 29-05-2024 Mark 205.8 39.38 Thu 11-04-202 Mark 301.55 110.60 Thu 25-04-2024 Jim 451.19 214.98 Thu 1-01-202 Jim 538.21 91.69 Fri 07-06-202 Mark 157.08 30.43 Fri 05-01-202 Karl 321.60 161.00 Wed 17-01-2024 Amanda 402.73 59.34 Thu 30-05-2024 Amanda 419.16 108.47 Thu 22-02-2024 Jim 561.45 84.98 Fri 09-02-2024 Amanda 402.31 58.13 Fri 19-01-2024 Jim 498.25 173.04 Mon 06-05-2024 Jim 235.15 17.43 Tue 2-01-2024 Karl 389.73 198.51 Fri 12-01-2024 Mark 216.92 56.77 Tue 21-05-2024 Jim 276.13 24.29 Thu 25-01-2024 Jim 475.18 90.25 Fri 19-04-2024 Mark 244.73 108.11 Fri 17-05-2024 Mark 411.64 85.51 Sat 04-05-2024 Mark 326.19 26.54 Sat 08-06-2024 Amanda 21.26 28.41 Wed 17-01-2024 Karl 290.08 84.25 Tue 30-04-2024 Amanda 537.04 87.20 Thu 30-05-2024 Jim 536.20 83.97 Sat 27-04-202 Amanda 16.66 44.39 Mon 15-04-202 Karl 328.54 31.90 Sat 11-05-2024 Jim 153.88 224.59 Mon 06-05-2024 Mark 278.01 58.51 Wed 31-01-2024 Amanda 571.72 228.56 Fri 12-01-2024 Jim 36.05 83.41 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA E v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v Q V Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 XV fx London Auto Centre B C D E F G H J K L M N O P Q R S T Mon 06-05-2024 Mark 278.07 58.57 178 Wed 31-01-2024 Amanda 571.72 Fri 2-01-2024 Jim 536.05 83.41 Fri $1-05-202 Karl 341.42 62.65 Mon 15-04-2024 Mark 330.81 37.16 Thu 4-04-202 Mark 364.27 122.88 Sat 10-02-2024 Jim 519.79 256.98 Fri 12-04-2024 Mark 281.91 66.62 Mon 29-04-2024 Jim 270.24 127.30 Sat 25-05-202 Jim 539.75 97.63 Fri 05-04-202 Karl 337.29 52.54 Thu 06-06-202 Amanda 467.35 63.79 Wed 07-02-202 Mark 400.13 51.91 Tue 9-01-2024 Mark 397.24 43.76 Thu 28-03-2024 Jim 572.96 233.90 Wed 4-01-2024 Jim 432.99 152.72 Wed 20-03-2024 Karl 348.95 81.72 Sat 09-03-2024 Amanda 473.59 84.82 Fri 31-05-202 Mark 444.74 192.41 Tue 05-03-2024 Amanda 192.32 151.04 Mon 25-03-2024 Amanda 192.12 150.31 Thu 8-01-2024 Mark 307.24 124.34 Sat 6-03-2024 Amanda 520.90 27.11 Thu 23-05-2024 Karl 357.76 105.00 Fri 1-03-2024 Mark 12.59 228.22 Fri 22-03-2024 Karl 382.21 175.24 Thu 11-04-2024 Jim 569.27 218.05 Mon 26-02-2024 Amanda 564.29 196.89 Fri 16-02-2024 Amanda 578.57 258.45 Sat 2-03-2024 Amanda 531.19 65.00 Sat 27-01-2024 Karl 344.20 69.60 Tue 16-01-2024 Mark 20.61 62.96 Thu 09-05-2024 Mark 421.19 14.81 Thu 04-04-2024 Amanda 13.49 91.09 Sat 16-03-2024 Karl 369.39 37.36 Sat 06-01-2024 Jim 336.27 50.10 Thu 25-04-2024 Karl 334.02 44.71 Thu 28-03-202 Karl 379.06 65.72 Mon 25-03-2024 Jim 312.23 15.12 Sat 08-06-2024 Karl 291.70 87.88 Mon 05-02-2024 Jim 201.96 30.52 Wed 15-05-2024 Karl 277.25 56.95 Fri 03-05-2024 Mark 336.44 50.49 Thu 23-05-2024 Amanda 554.75 157.31 Sat 03-02-2024 Karl 298.23 102.77 Mon 19-02-2024 Karl N/A - Family Day N/A - Family Day ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BI UV MVA v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v Q V Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 XV fx London Auto Centre A B C D E F G H J K L M N O P Q R S T Sat 3-02-2024 Kar 298.23 02.77 Mon 19-02-2024 Karl N/A - Family Day |N/A - Family Day Thu 16-05-2024 Kar 341.42 62.67 Tue 27-02-202 Kar 300.67 108.50 Wed 10-04-202 Karl 318.58 53.06 Wed 05-06-202 Amanda 423.72 122.77 Fri 05-01-202 Mark 274.54 51.49 Fri 9-01-202 Amanda 572.29 231.01 Mon 22-04-2024 Jim 338.28 116.89 Sat 30-03-2024 Karl 362.24 117.23 Fri 22-03-2024 Jim 504.63 97.23 Sat 04-05-2024 Jim 481.90 13.58 Thu 04-01-2024 Amanda 395.73 39.55 Sat 20-04-2024 Kar 366.54 129.26 Fri 16-02-2024 Jim 510.12 218.51 Sat 06-04-2024 Amanda 440.13 176.60 Sat 09-03-2024 Karl 79.29 61.15 Mon 11-03-2024 Mark 281.03 64.76 Fri 03-05-2024 Karl 297.25 100.52 Thu 07-03-2024 Karl 281.89 66.58 Thu 18-04-2024 Jim 369.98 139.06 Tue 21-05-2024 Kar 292.80 90.35 Wed 14-02-2024 Jim 504.86 198.11 Thu 15-02-2024 Karl 366.21 128.33 Tue 16-01-202 Jim 329.19 33.41 Sat 06-01-202 Mark 67.89 33.08 Tue 30-01-2024 Karl $50.13 34.78 248 Wed 7-01-2024 im 651.54 144.27 249 Sat 27-01-2024 Jim 479.10 103.80 250 Mon 03-06-2024 Amanda 501.80 186.42 Tue 23-01-2024 Karl $74.66 52.66 Mon 20-05-202 Mark N/A - Victoria Day |N/A - Victoria Day Tue 07-05-2024 Jim 401.27 55.15 Mon 27-05-2024 Jim 34.68 1.89 Tue 06-02-2024 Mark 65.68 34.31 Mon 29-04-202 Mark 429.70 41.94 Mon 29-01-2024 Mark 202.29 34.06 Wed 20-03-2024 Amanda 452.0 217.85 Tue 23-04-2024 Jim 470.00 72.66 Tue 05-03-202 Karl 317.46 150.12 Wed 21-02-2024 Amanda 100.00 51.55 Fri 31-05-2024 Amanda 393.54 33.49 Tue 28-05-2024 Mark 386.04 186.99 264 Thu 29-02-2024 Jim 453.81 24.31 265 Tue 7-02-2024 Amanda 537.55 89.16 266 Fri 16-02-2024 Mark 83.05 69.02 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA - V v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v Q V Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 X V fx London Auto Centre A B C D E F G H J K L M N O P Q R S T LI-UL-CULT 266 Fri 16-02-2024 Mark 283.05 69.02 267 Mon 08-04-2024 Jim 207.92 45.30 268 Fri 01-03-2024 Jim 398.95 48.57 269 Thu 08-02-2024 Karl 324.13 167.76 Sat 18-05-2024 Karl 374.46 52.07 Mon 27-05-2024 Mark 282.66 68.18 Tue 12-03-2024 Karl 272.67 47.77 Fri 26-04-202 Amanda 151.53 216.21 Fri 26-04-2024 Karl 368.12 133.75 Sat 13-01-2024 Mark 306.02 121.34 Wed 13-03-2024 Karl 85.47 185.22 Thu 0-05-2024 Mark 219.19 60.56 Wed 24-01-2024 Amanda 504.27 95.87 Sat 24-02-202 Amanda 499.79 178.84 Wed 01-05-2024 Jim 382.80 77.02 Mon 06-05-2024 Karl 272.29 47.01 Fri 23-02-2024 Mark 401.47 55.73 Mon 20-05-2024 Jim Victoria Day |N/A - Victoria Day Thu 06-06-2024 Jim 357.60 104.57 Wed 01-05-2024 Karl $14.38 42.20 Tue 23-01-2024 Jim 458.92 36.31 Fri 08-03-2024 Jim 566.16 204.77 288 Sat 06-01-202 Amanda 469.65 71.48 289 Sat 20-01-202 Karl 283.37 59.70 2901 Sat 17-02-202 Jim 357.69 04.79 Fri 07-06-2024 Karl 288.37 30.49 Thu 08-02-2024 Mark 362.96 19.22 Tue 20-02-202 Amanda 409.22 78.29 Sat 24-02-2024 Karl 357.60 04.57 Mon 25-03-2024 Karl 363.46 120.64 Sat 06-04-2024 Karl 303.83 116.05 Thu 23-05-2024 Jim 547.59 128.45 Sat 17-02-2024 Karl $17.03 149.03 Thu 15-02-2024 Jim 552.93 149.89 Fri 26-01-2024 Amanda 425.01 126.88 Sat 23-03-2024 Amanda 530.34 61.81 Sat 08-06-202 Mark 284.12 71.29 Thu 11-01-2024 Karl 299.63 106.05 Tue 20-02-202 Mark 380.49 170.03 Mon 08-01-2024 Jim 253.43 71.14 Fri 02-02-202 Mark $11.19 84.16 Thu 1-04-2024 Amanda 441.53 81.36 308 Thu 18-04-2024 Mark 366.06 127.91 309 Thu 29-02-2024 Amanda 418.09 105.14 Thu 07-03-2024 Jim 395.26 38.23 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA E v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v DV Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 XV fx London Auto Centre A B C D E F G H J K L M N O P Q R S T 25-U2-2024 Allianlua 410 . 05 100 . 14 Thu 07-03-2024 Jim 395.26 38.23 Mon 20-05-202 Amanda N/A - Victoria Day N/A - Victoria Day Thu 09-05-2024 Karl 281.60 65.96 Sat 23-03-2024 Mark 240.96 100.53 Fri 24-05-2024 Kar 299.93 06.76 Wed 06-03-2024 Karl 383.85 180.24 Fri 07-06-2024 Amanda 546.30 23.31 Tue 09-01-2024 Jim 470.47 74.25 Sat 24-02-2024 Jim 518.10 250.17 Mon 11-03-2024 Amanda 583.98 282.51 Fri 22-03-2024 Mark 372.70 146.94 Fri 03-05-2024 Jim 395.75 39.60 Tue 14-05-2024 Jim 391.90 29.01 Tue 28-05-2024 Jim 365.93 127.54 Wed 22-05-2024 Jim 461.27 43.87 Fri 17-05-2024 Jim 564.27 196.79 Sat 11-05-2024 Karl 288.38 80.52 Tue 04-06-2024 Mark 251.40 122.02 Tue 02-01-2024 Jim 27.26 28.98 Fri 26-01-202 Karl $12.02 36.23 Sat 20-04-2024 Mark 263.12 29.53 Thu 25-04-202 Mark 426.86 132.77 Tue 30-04-2024 Jim 454.77 227.76 Tue 02-04-202 Karl 278.21 58.93 Wed 27-03-2024 Amanda 189.65 41.33 Tue 30-01-2024 Mark 148.58 205.79 Fri 24-05-2024 Jim 136.46 164.23 Tue 13-02-2024 Mark 108.20 75.28 Tue 16-04-2024 Jim 481.84 13.37 Tue 26-03-2024 Amanda 428.99 139.64 Fri 05-01-2024 Jim 506.26 203.50 Mon 13-05-2024 Mark 339.98 59.10 Thu 25-01-2024 Amanda 484.84 124.02 Tue 12-03-2024 Amanda 510.05 218.25 Mon 13-05-2024 Jim 312.55 194.80 Tue 16-04-202 Mark 409.80 80.02 Tue 07-05-2024 Amanda 36.44 84.91 Fri 03-05-202 Amanda 543.28 111.42 348 Tue 30-04-202 Karl 383.47 179.06 349 Mon 04-03-202 Mark 309.69 130.38 350 Sat 10-02-202 Amanda 504.38 196.26 Wed 15-05-2024 Amanda 529.73 59.53 Fri 15-03-2024 Karl 315.75 45.73 Sat 20-01-2024 Amanda $18.68 106.97 354 Mon 01-04-2024 Karl 278.60 59.72 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BIUV MVA E F V v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v DV Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 XV fx London Auto Centre B C D E F G H J K L M N O P Q R S T Mon 01-04-2024 Karl 278.60 19.72 Thu 08-02-2024 Jim 337.01 51.87 Mon 13-05-2024 Karl 343.92 68.90 Thu 4-04-2024 Karl 330.75 37.02 Thu 15-02-2024 Mark 414.02 92.71 Tue 09-04-202 Karl 273.24 48.90 Wed 24-04-2024 Amanda 414.31 93.58 Tue 13-02-202 Amanda 525.31 43.15 Mon 29-04-202 Karl 353.90 94.66 Mon 5-02-2024 Mark 273.02 48.45 Wed 22-05-202 Karl 263.88 30.95 Wed 05-06-202 Jim 422.52 18.97 Wed 17-04-202 Jim 325.14 24.16 Mon 8-03-2024 Kar 359.34 09.29 Thu 23-05-2024 Mark 139.83 75.58 Thu 21-03-2024 Karl 282.21 67.25 Fri 29-03-2024 Jim N/A - Good Friday N/A - Good Friday Mon 15-01-2024 Jim 275.11 18.32 Tue 28-05-2024 Karl 267.88 38.45 Tue 12-03-2024 Mark 382.31 175.54 Thu 4-01-2024 Karl 283.5 69.98 Wed 08-05-2024 Amanda 537.31 38.23 Thu 25-04-2024 Amanda 444.5 191.85 Tue 07-05-2024 Mark 360.09 111.33 Sat 3-04-2024 Mark $69.69 138.24 Mon 22-04-2024 Amanda 106.21 69.44 Fri 05-04-2024 Mark 514.61 36.20 Mon 29-01-2024 Jim 225.38 93.31 Wed 17-04-2024 Amanda 406.98 71.70 Thu 07-03-2024 Amanda 436.30 63.72 Tue 09-01-2024 Karl 67.15 37.08 Fri 23-02-2024 Amanda 546.05 122.34 Thu 04-04-2024 Jim 418.71 107.09 Fri 17-05-2024 Karl 270.57 43.66 Wed 03-04-2024 Karl 373.84 150.25 Sat 20-04-2024 Amanda 541.01 02.53 Mon 12-02-2024 Mark 277.49 57.45 Thu 9-05-2024 Amanda 448.91 206.92 Tue 09-04-2024 Jim 501.62 185.77 Wed 31-01-2024 Jim 384.64 182.66 Sat 04-05-2024 Amanda 514.99 237.75 Sat 10-02-2024 Karl 337.29 52.55 Tue 13-02-202 Jim 536.40 84.77 Mon 19-02-202 Amanda N/A - Family Day | N/A - Family Day 398 Wed 03-01-202 Mark 321.04 159.51 an 10 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BI UV MVA - V v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v Q V Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 X V fx London Auto Centre A B C D E F G H J K L M N O P Q R S T 399 Tue 02-01-2024 Mark 205.92 39.4 400 Sat 30-03-2024 Mark $64.51 123.56 401 Mon 26-02-2024 Karl 387.54 191.64 Wed 31-01-2024 Karl 378.43 163.83 4031 Thu 02-05-202 Amanda 526.34 46.97 Tue 20-02-2024 Karl 263.37 29.99 Tue 16-01-202 Karl 279.13 60.81 Wed 8-02-2024 Jim 378.38 163.68 Thu 18-01-2024 Karl 264.71 32.49 Fri 0-05-2024 Amanda 584.19 83.44 Tue 30-01-2024 Jim 584.59 285.25 Sat 3-04-2024 Amanda 392.46 30.53 Fri 22-03-2024 Amanda 459.54 38.29 Wed 03-04-2024 Jim 531.20 65.04 Fri 02-02-2024 Amanda 458.29 34.29 Wed 22-05-2024 Mark 488.73 137.98 Sat 25-05-2024 Mark 357.28 103.69 Sat 01-06-2024 Amanda 429.07 139.90 Thu 28-03-2024 Amanda 164.84 55.52 Mon 11-03-2024 Karl 294.97 95.26 Sat 03-02-2024 Jim $69.35 37.26 Sat 27-01-2024 Mark 265.35 33.67 Tue 19-03-202 Amanda $58.90 174.37 Tue 07-05-2024 Karl 289.78 83.58 Sat 17-02-202 Amanda 429.01 139.71 Mon 08-04-202 Karl 25.03 23.92 Thu 01-02-202 Jim 382.42 175.87 Mon 1-04-202 Jin 270.42 127.94 Mon 22-01-2024 Karl 281.50 65.75 Wed 01-05-2024 Mark 334.26 45.27 Tue 05-03-2024 Jim 439.00 172.79 Fri 19-01-2024 Karl 387.00 189.97 Thu 1-01-2024 Amanda 560.86 182.52 Tue 14-05-2024 Amanda 197.87 71.62 Wed 3-03-2024 Jim 580.34 266.27 Fri 29-03-2024 Mark N/A - Good Friday N/A - Good Friday Mon 29-01-2024 Amanda 437.42 67.45 Sat 13-04-2024 Karl 286.25 75.88 Mon 25-03-2024 Mark 466.16 59.87 Fri 10-05-2024 Mark 285.32 73.87 439 Thu 07-03-2024 Mark 268.40 39.47 440 Sat 16-03-2024 Jim 505.10 199.04 441 Tue 04-06-2024 Kar 272.59 47.60 442 Mon 04-03-2024 Jim 325.81 66.21 443 Fri 01-03-2024 Karl 63.92 21.92 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA b v General Insert v x Delete Paste BI UV MVA - V v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v Q V Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 X V fx London Auto Centre A B C D E F G H J K L M N O P Q R S T 399 Tue 02-01-2024 Mark 205.92 39.4 400 Sat 30-03-2024 Mark $64.51 123.56 401 Mon 26-02-2024 Karl 387.54 191.64 Wed 31-01-2024 Karl 378.43 163.83 4031 Thu 02-05-202 Amanda 526.34 46.97 Tue 20-02-2024 Karl 263.37 29.99 Tue 16-01-202 Karl 279.13 60.81 Wed 8-02-2024 Jim 378.38 163.68 Thu 18-01-2024 Karl 264.71 32.49 Fri 0-05-2024 Amanda 584.19 83.44 Tue 30-01-2024 Jim 584.59 285.25 Sat 3-04-2024 Amanda 392.46 30.53 Fri 22-03-2024 Amanda 459.54 38.29 Wed 03-04-2024 Jim 531.20 65.04 Fri 02-02-2024 Amanda 458.29 34.29 Wed 22-05-2024 Mark 488.73 137.98 Sat 25-05-2024 Mark 357.28 103.69 Sat 01-06-2024 Amanda 429.07 139.90 Thu 28-03-2024 Amanda 164.84 55.52 Mon 11-03-2024 Karl 294.97 95.26 Sat 03-02-2024 Jim $69.35 37.26 Sat 27-01-2024 Mark 265.35 33.67 Tue 19-03-202 Amanda $58.90 174.37 Tue 07-05-2024 Karl 289.78 83.58 Sat 17-02-202 Amanda 429.01 139.71 Mon 08-04-202 Karl 25.03 23.92 Thu 01-02-202 Jim 382.42 175.87 Mon 1-04-202 Jin 270.42 127.94 Mon 22-01-2024 Karl 281.50 65.75 Wed 01-05-2024 Mark 334.26 45.27 Tue 05-03-2024 Jim 439.00 172.79 Fri 19-01-2024 Karl 387.00 189.97 Thu 1-01-2024 Amanda 560.86 182.52 Tue 14-05-2024 Amanda 197.87 71.62 Wed 3-03-2024 Jim 580.34 266.27 Fri 29-03-2024 Mark N/A - Good Friday N/A - Good Friday Mon 29-01-2024 Amanda 437.42 67.45 Sat 13-04-2024 Karl 286.25 75.88 Mon 25-03-2024 Mark 466.16 59.87 Fri 10-05-2024 Mark 285.32 73.87 439 Thu 07-03-2024 Mark 268.40 39.47 440 Sat 16-03-2024 Jim 505.10 199.04 441 Tue 04-06-2024 Kar 272.59 47.60 442 Mon 04-03-2024 Jim 325.81 66.21 443 Fri 01-03-2024 Karl 63.92 21.92 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Insert v Arial 11 AA b v General x Delete Sort & Find & Add-ins Analyze Paste BIUV MVA E F V v % 9 Conditional Format Cell Sensitivity Formatting as Table Styles Format v Q V Filter Select Data Font Alignment Number Styles Cells Sensitivity Add-ins Clipboard Editing Assistance A1 XV fx London Auto Centre B C D E F G H K M N O P Q R S T 443 Fri 01-03-2024 Karl 363.92 21.92 Wed 10-04-2024 Mark 351.23 87.63 Thu 04-01-2024 Jim 434.70 158.38 Thu 11-04-2024 Karl 325.08 24.03 Mon 2-02-2024 Karl 320.67 158.53 448 Sat 10-02-202 Mark 416.54 100.40 Wed 20-03-202 Mark 319.14 54.53 450 Sat 2-03-2024 Mark 293.49 91.90 Mon 19-02-202 Jim - Family Wed 29-05-202 Jim 417.59 103.60 Wed 1-05-2024 Amanda 413.67 91.64 Wed 27-03-202 Jim 367.17 31.03 Wed 24-01-2024 Mark 348.76 81.22 Thu 4-03-202 Mark 283.26 59.47 Thu 1-02-2024 Mark 37.65 53.43 Tue 02-01-2024 Amanda 178.23 100.75 Sat 04-05-202 Karl 08.63 127.76 Sat 27-04-2024 Mark 186.99 31.71 Ned 24-01-2024 Karl 36.84 51.45 Sat 09-03-202 Mark 459.2 37.27 Tue 30-04-202 Mark 414.0 32.85 Wed 03-01-2024 Karl 273.76 49.93 Mon 08-04-202 Mark 26.94 28.25 Sat 1-06-2024 Mark 303.42 15.06 Sat 13-01-2024 Amanda 75.36 90.85 468 Tue 26-03-202 Karl 306.95 23.62 469 Mon 26-02-2024 Mark 27.33 134.29 Wed 07-02-202 Amanda 193.72 56.19 Mon 22-01-202 Amanda 75.54 91.46 Wed 29-05-202 Karl 326.75 27.82 Sat 18-05-202 Jim 446.86 199.75 Mon 29-01-2024 Karl 69.33 41.25 Wed 24-04-202 Karl 286.95 77.38 Fri 9-04-202 Jim 473.16 83.32 Thu 18-01-2024 Amanda 197.82 71.44 Thu 18-01-202 Jim 390.73 25.83 Thu 30-05-2024 Karl $57.04 03.04 Sat 13-01-2024 Karl 290.14 84.39 Tue 09-04-2024 Mark 278.55 59.62 Tue 09-01-2024 Amanda 418.81 107.37 Wed 06-03-2024 Jim 572.6 232.77 Fri 09-02-202 Jim 503.82 194.12 Wed 10-01-2024 Karl 328.97 32.88 Thu 1-02-2024 Karl 342.52 65.41 487 Sat 17-02-2024 Mark 216.4 56.04 488 Thu 6-06-2024 Mark 434.81 158.74 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%AutoSave A A F ? C ... ACCT 3906 Jun 12 2024 Midterm Exam - TO POST Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate XLSTAT Cloud XLSTAT Free Comments Share Arial 11 AA g v General Insert v x Delete Paste BI UV MVA E - V v % 9 Conditional Format Cell Sort & Find & Sensitivity Add-ins Analyze Formatting as Table Styles Format v Q V Filter Select Data Clipboard Font Alignment Number Styles Cells Editing Sensitivity Add-ins Assistance A1 XV fx London Auto Centre B C D E F G H K M N O P Q R S T 508 Tue 21-05-202 Amanda 4/5.6/ 91.92 509 Mon 22-01-202 Mark 255.02 29.81 Fri 08-03-202 Amanda 576.80 250.68 Mon 12-02-2024 Jim 324.98 62.97 Thu 11-01-2024 Mark 302.4 12.73 Wed 8-05-2024 Karl 363.84 121.67 Fri 19-04-2024 Amanda 539.02 94.81 Fri 23-02-2024 Jim 382.93 177.42 Sat 25-05-2024 Karl 276.7 55.99 Mon 15-01-202 Mark 457.9 33.26 Tue 16-04-202 Amanda 416.3 99.94 Fri 17-05-2024 Amanda 498.73 174.86 Sat 23-03-2024 Karl 350.50 85.71 Thu 22-02-202 Karl 299.50 105.76 Fri 12-04-202 Jim 362.79 18.77 Mon 08-01-2024 Mark 465.16 56.56 Fri 12-04-202 Amanda 529.70 59.43 Sat 13-04-202 Jim 452.94 221.22 Fri 12-04-202 Karl 378.67 164.55 Mon 03-06-2024 Mark 230.29 80.12 Sat 09-03-2024 Jim 372.98 47.75 Sat 1-05-2024 Amanda 10.53 82.19 Wed 31-01-2024 Mark 232.95 35.0 Fri 02-02-2024 Karl 261.50 26.57 Sat 30-03-2024 Amanda 504.12 95.26 Sat 27-04-2024 Karl 294.75 94.77 Wed 07-02-2024 Jim 544.67 116.87 Sat 20-01-2024 Jim 143.7 188.91 Wed 15-05-2024 Mark 323.3 65.77 Sat 8-06-2024 Jim 163.95 52.58 Mon 8-03-2024 Mark 14.49 94.14 Wed 14-02-2024 Amanda 507.75 209.28 Mon 22-04-2024 Karl 370.09 139.37 Tue 20-02-2024 Jim 201.95 85.78 Mon 22-04-2024 Mark 423.51 122.11 Fri 08-03-2024 Mark 220.07 62.04 Sat 8-05-2024 Amanda 406.96 71.62 Sat 23-03-2024 Jim 458.42 34.70 Mon 18-03-2024 Amanda 570.58 223.65 Tue 27-02-2024 Jim 477.17 97.09 Thu 18-04-2024 Karl 379.71 167.66 Fri 24-05-2024 Amanda 518.02 249.84 Fri 09-02-2024 Karl 304.88 118.59 Mon 22-01-2024 Jim 328.59 77.19 553 ACCT 3906 Midterm Exam TO POST + Select destination and press ENTER or choose Paste 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started