Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you put the formulas used in excel? Instructions: Based on the data in the worksheet below, convert the data into Table and answer the
Can you put the formulas used in excel?
| Instructions: Based on the data in the worksheet below, convert the data into "Table" and answer the questions below. | ||||||||||||||
| Type answers into each cell with appropriate formats (need to be number, not text). No formulas in any cells. | ||||||||||||||
| (1) How much has Daniel been paid so far? | ||||||||||||||
| (2) What is the total payroll for all drivers so far? | ||||||||||||||
| (3) How many miles has Martin driven so far? | ||||||||||||||
| (4) How many miles has Travis driven so far? | ||||||||||||||
| (5) How many hours has the big truck been driven so far? | ||||||||||||||
| (6) What is the total payroll for hazardous material runs? | ||||||||||||||
| Company Name | Name | Hourly Rate | Phone | Run Date | Haz Mat | BigTruck | Start Time | End Time | Start Odom | End Odom | Miles | Hours | Payroll | |
| This and That | Martin | $15.00 | 888-1315 | 02-Jan-98 | No | No | 3:00:00 AM | 5:30:00 AM | 45555 | 45674 | 119 | 2.5 | $37.50 | |
| NimBob | Matthew | $10.00 | 650-5519 | 02-Jan-98 | No | No | 3:45:00 AM | 12:15:00 PM | 43816 | 44263 | 447 | 8.5 | $85.00 | |
| Manchesters Furniture | Travis | $14.00 | 650-2881 | 02-Jan-98 | No | Yes | 5:45:00 AM | 9:15:00 AM | 47908 | 48061 | 153 | 3.5 | $49.00 | |
| Micron Electronics | Kimberly | $15.00 | 650-2384 | 02-Jan-98 | No | Yes | 11:30:00 AM | 4:00:00 PM | 46844 | 47000 | 156 | 4.5 | $67.50 | |
| NimBob | Travis | $14.00 | 650-2881 | 02-Jan-98 | Yes | Yes | 3:30:00 PM | 5:00:00 PM | 62574 | 62623 | 49 | 1.5 | $21.00 | |
| Eligios | Matthew | $10.00 | 650-5519 | 03-Jan-98 | No | Yes | 12:30:00 AM | 7:45:00 AM | 48243 | 48573 | 330 | 7.25 | $72.50 | |
| Manchesters Furniture | Daniel | $12.00 | 992-4437 | 03-Jan-98 | No | Yes | 10:00:00 AM | 11:45:00 AM | 59285 | 59367 | 82 | 1.75 | $21.00 | |
| This and That | Kimberly | $15.00 | 650-2384 | 03-Jan-98 | No | No | 2:45:00 PM | 11:00:00 PM | 58871 | 59258 | 387 | 8.25 | $123.75 | |
| Gateway | Erin | $13.00 | 756-8381 | 04-Jan-98 | No | Yes | 4:45:00 AM | 1:45:00 PM | 61721 | 62129 | 408 | 9 | $117.00 | |
| Eligios | Charles | $16.00 | 842-7108 | 05-Jan-98 | No | No | 5:00:00 AM | 11:30:00 AM | 69184 | 69424 | 240 | 6.5 | $104.00 | |
| Super Cuts | Charles | $16.00 | 855-5698 | 05-Jan-98 | No | No | 6:15:00 AM | 3:15:00 PM | 41301 | 41581 | 280 | 9 | $144.00 | |
| Manchesters Furniture | Erin | $13.00 | 756-8381 | 05-Jan-98 | No | No | 11:30:00 AM | 7:45:00 PM | 48350 | 48675 | 325 | 8.25 | $107.25 | |
| Apple Corp. | Erin | $15.00 | 855-4751 | 05-Jan-98 | Yes | No | 12:00:00 PM | 10:45:00 PM | 52493 | 52872 | 379 | 10.75 | $161.25 | |
| Jerry's Pharmaceuticals | Tricia | $13.00 | 756-2863 | 06-Jan-98 | No | Yes | 5:45:00 AM | 3:15:00 PM | 62821 | 63424 | 603 | 9.5 | $123.50 | |
| Manchesters Furniture | Staci | $11.00 | 756-8117 | 06-Jan-98 | No | No | 6:15:00 AM | 8:00:00 AM | 63600 | 63666 | 66 | 1.75 | $19.25 | |
| Manchesters Furniture | Staci | $11.00 | 756-8117 | 06-Jan-98 | Yes | No | 7:45:00 AM | 11:45:00 AM | 43422 | 43547 | 125 | 4 | $44.00 | |
| Micron Electronics | Jeanette | $16.00 | 992-5480 | 06-Jan-98 | No | No | 10:45:00 AM | 7:00:00 PM | 51566 | 52000 | 434 | 8.25 | $132.00 | |
| Eligios | Jeanette | $16.00 | 992-5480 | 06-Jan-98 | Yes | Yes | 5:30:00 PM | 2:15:00 AM | 46135 | 46580 | 445 | 8.75 | $140.00 | |
| Micron Electronics | Tony | $15.00 | 994-7386 | 07-Jan-98 | No | Yes | 5:30:00 AM | 2:45:00 PM | 62105 | 62411 | 306 | 9.25 | $138.75 | |
| Micron Electronics | Staci | $11.00 | 756-8117 | 07-Jan-98 | No | No | 6:30:00 AM | 11:30:00 AM | 54294 | 54528 | 234 | 5 | $55.00 | |
| Apple Corp. | Erin | $15.00 | 678-4567 | 07-Jan-98 | No | No | 12:00:00 PM | 8:15:00 PM | 54583 | 54862 | 279 | 8.25 | $123.75 | |
| Eligios | Tricia | $13.00 | 756-2863 | 07-Jan-98 | No | Yes | 2:45:00 PM | 6:30:00 PM | 61414 | 61518 | 104 | 3.75 | $48.75 | |
| Micron Electronics | Charles | $16.00 | 842-7108 | 07-Jan-98 | No | Yes | 3:00:00 PM | 6:15:00 PM | 68492 | 68659 | 167 | 3.25 | $52.00 | |
| Eligios | Luke | $10.00 | 855-4686 | 07-Jan-98 | No | Yes | 7:15:00 PM | 4:00:00 AM | 57967 | 58396 | 429 | 8.75 | $87.50 | |
| Industrial Light and Magic | Matthew | $10.00 | 650-5519 | 08-Jan-98 | No | No | 11:45:00 AM | 5:45:00 PM | 40398 | 40750 | 352 | 6 | $60.00 | |
| Eligios | Erin | $15.00 | 678-4567 | 08-Jan-98 | No | Yes | 12:30:00 PM | 7:00:00 PM | 62064 | 62424 | 360 | 6.5 | $97.50 | |
| NimBob | Erin | $14.00 | 756-3201 | 08-Jan-98 | No | No | 12:45:00 PM | 2:30:00 PM | 58448 | 58524 | 76 | 1.75 | $24.50 | |
| Eligios | Tony | $15.00 | 994-7386 | 08-Jan-98 | No | Yes | 12:45:00 PM | 9:15:00 PM | 60825 | 61216 | 391 | 8.5 | $127.50 | |
| NimBob | Erin | $15.00 | 678-4567 | 08-Jan-98 | No | No | 1:45:00 PM | 7:15:00 PM | 50455 | 50654 | 199 | 5.5 | $82.50 | |
| Gateway | Tony | $15.00 | 994-7386 | 08-Jan-98 | No | Yes | 2:15:00 PM | 11:45:00 PM | 67926 | 68331 | 405 | 9.5 | $142.50 | |
| Jerry's Pharmaceuticals | Tricia | $13.00 | 756-2863 | 08-Jan-98 | Yes | Yes | 6:00:00 PM | 3:15:00 AM | 48594 | 48952 | 358 | 9.25 | $120.25 | |
| Manchesters Furniture | Charles | $16.00 | 842-7108 | 09-Jan-98 | Yes | No | 4:15:00 AM | 10:15:00 AM | 69993 | 70284 | 291 | 6 | $96.00 | |
| Eligios | Jeanette | $16.00 | 992-5480 | 09-Jan-98 | No | Yes | 10:15:00 AM | 3:45:00 PM | 68053 | 68377 | 324 | 5.5 | $88.00 | |
| Gateway | Luke | $10.00 | 855-4686 | 10-Jan-98 | No | Yes | 4:30:00 AM | 2:30:00 PM | 43443 | 43984 | 541 | 10 | $100.00 | |
| Jerry's Pharmaceuticals | Jeanette | $16.00 | 992-5480 | 10-Jan-98 | No | No | 5:00:00 AM | 3:45:00 PM | 67879 | 68555 | 676 | 10.75 | $172.00 | |
| Industrial Light and Magic | Staci | $11.00 | 756-8117 | 10-Jan-98 | No | No | 8:45:00 AM | 8:00:00 PM | 43460 | 44137 | 677 | 11.25 | $123.75 | |
| Super Cuts | Daniel | $12.00 | 992-4437 | 10-Jan-98 | No | No | 11:30:00 AM | 9:30:00 PM | 43970 | 44435 | 465 | 10 | $120.00 | |
| Jerry's Pharmaceuticals | Erin | $14.00 | 756-3201 | 10-Jan-98 | No | No | 12:30:00 PM | 6:00:00 PM | 58746 | 59061 | 315 | 5.5 | $77.00 | |
| This and That | Erin | $16.00 | 756-7578 | 10-Jan-98 | No | Yes | 1:45:00 PM | 8:30:00 PM | 40375 | 40662 | 287 | 6.75 | $108.00 | |
| Gateway | Staci | $11.00 | 756-8117 | 10-Jan-98 | No | No | 6:15:00 PM | 8:00:00 PM | 41347 | 41428 | 81 | 1.75 | $19.25 | |
| Apple Corp. | Luke | $10.00 | 855-4686 | 13-Jan-98 | No | No | 2:30:00 AM | 4:15:00 AM | 43200 | 43261 | 61 | 1.75 | $17.50 | |
| Eligios | Tricia | $13.00 | 756-2863 | 14-Jan-98 | No | No | 5:30:00 AM | 9:30:00 AM | 40067 | 40178 | 111 | 4 | $52.00 | |
| Apple Corp. | Daniel | $12.00 | 992-4437 | 14-Jan-98 | No | Yes | 6:15:00 AM | 8:45:00 AM | 48113 | 48244 | 131 | 2.5 | $30.00 | |
| Jerry's Pharmaceuticals | Erin | $13.00 | 756-8381 | 14-Jan-98 | No | No | 6:30:00 AM | 9:00:00 AM | 41671 | 41742 | 71 | 2.5 | $32.50 | |
| This and That | Matthew | $10.00 | 650-5519 | 14-Jan-98 | Yes | No | 9:30:00 AM | 12:15:00 PM | 48184 | 48325 | 141 | 2.75 | $27.50 | |
| Manchesters Furniture | Travis | $14.00 | 650-2881 | 14-Jan-98 | No | No | 12:15:00 PM | 8:30:00 PM | 48531 | 48841 | 310 | 8.25 | $115.50 | |
| This and That | Tricia | $13.00 | 756-2863 | 15-Jan-98 | Yes | No | 12:30:00 AM | 8:45:00 AM | 53750 | 53982 | 232 | 8.25 | $107.25 | |
| Apple Corp. | Martin | $15.00 | 888-1315 | 15-Jan-98 | Yes | No | 6:15:00 AM | 3:00:00 PM | 67885 | 68165 | 280 | 8.75 | $131.25 | |
| Super Cuts | Charles | $16.00 | 842-7108 | 15-Jan-98 | Yes | No | 10:00:00 AM | 5:45:00 PM | 61705 | 62023 | 318 | 7.75 | $124.00 | |
| Jerry's Pharmaceuticals | Tony | $15.00 | 994-7386 | 16-Jan-98 | No | No | 4:45:00 AM | 11:45:00 AM | 52481 | 52792 | 311 | 7 | $105.00 | |
| Gateway | Charles | $16.00 | 855-5698 | 16-Jan-98 | No | No | 5:00:00 AM | 8:45:00 AM | 68330 | 68427 | 97 | 3.75 | $60.00 | |
| Gateway | Charles | $16.00 | 842-7108 | 16-Jan-98 | Yes | Yes | 6:00:00 AM | 10:30:00 AM | 67479 | 67751 | 272 | 4.5 | $72.00 | |
| This and That | Staci | $11.00 | 756-8117 | 16-Jan-98 | Yes | No | 9:00:00 AM | 3:00:00 PM | 64291 | 64593 | 302 | 6 | $66.00 | |
| This and That | Martin | $15.00 | 888-1315 | 16-Jan-98 | Yes | No | 9:45:00 AM | 6:15:00 PM | 47732 | 48115 | 383 | 8.5 | $127.50 | |
| Eligios | Daniel | $12.00 | 992-4437 | 17-Jan-98 | Yes | No | 7:15:00 AM | 4:45:00 PM | 59773 | 60214 | 441 | 9.5 | $114.00 | |
| Eligios | Tony | $15.00 | 994-7386 | 18-Jan-98 | No | No | 7:30:00 AM | 11:45:00 AM | 69344 | 69456 | 112 | 4.25 | $63.75 | |
| Industrial Light and Magic | Shawn | $14.00 | 994-7393 | 18-Jan-98 | No | No | 8:45:00 AM | 3:45:00 PM | 69330 | 69615 | 285 | 7 | $98.00 | |
| This and That | Shawn | $14.00 | 994-7393 | 18-Jan-98 | No | No | 6:30:00 PM | 5:30:00 AM | 49933 | 50374 | 441 | 11 | $154.00 | |
| Manchesters Furniture | Tricia | $13.00 | 756-2863 | 19-Jan-98 | No | Yes | 4:30:00 AM | 6:15:00 AM | 61726 | 61787 | 61 | 1.75 | $22.75 | |
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
Databases And Information Systems 1 International Baltic Conference Dbandis 2020 Tallinn Estonia June 19 2020 Proceedings
Authors: Tarmo Robal ,Hele-Mai Haav ,Jaan Penjam ,Raimundas Matulevicius
1st Edition
303057671X, 978-3030576714
