The question:

What other information would help Charlie evaluate the appropriateness of the time recorded?

AutoSave OFF case Home Insert Draw Page Layout Formulas Data Data Review View Tell me Connections Properties Edit Linics 2. > Get Data Data from Picture Refresh All Stocks Currencies Geography Sort E G12 fx G 1 + A B C D F 1 Time Ticket Start Time End Time Time Worke-1 Job Number Employee 2 1438 9:53 AM 11:54 AM 0:00 12343 3 1025 1439 11:34 AM 12:53 PM 0.00 4 12330 1007 1440 9:53 AM 9:55 AM 0.00 S 1441 12330 1102 7:29 AM 12:58 PM 0:00 6 12349 1442 1043 7:41 AM 7:49 AM 0:00 12322 1100 7 1443 8:46 AM 8:56 AM 0:00 8 12350 1444 1015 11:19 AM 12:53 PM 0:00 9 12332 1120 1445 11:49 AM 11:57 AM 0:00 12307 1055 10 1446 8:14 AM 11:48 AM 0.00 11 12333 1447 1070 10:43 AM 10:47 AM 0:00 12 12318 1448 1027 7:01 AM 10:59 AM 0:00 13 12312 1449 1038 10:16 AM 11 36 AM 0:00 24 12346 1450 8:57 AM 8:58 AM 1039 15 0:01 12340 1451 1070 8:42 AM 10:43 AM 0:01 26 1452 12325 1080 8:28 AM 8:52 AM 0:01 27 1453 12309 1042 8:17 AM 11:27 AM 0.01 12318 18 1454 1010 11:03 AM 12:30 PM 001 19 12317 1010 1455 11:00 AM 12:58 PM 0:09 12317 20 1456 1037 11 01 AM 12:18 PM 0:01 21 12321 1014 1457 7:57 AM 8:58 AM 22 0:01 12335 1007 1458 9:13 AM 12:23 PM 001 23 1459 12345 1062 8:42 AM 9:42 AM 24 0:02 12340 1094 1460 10:49 AM 12:59 PM 0:02 12330 1011 25 1461 9:59 AM 12:50 PM 0:02 26 12304 1047 1462 9:45 AM 12:51 PM 27 0:02 12338 1104 1463 10:59 AM 12:59 PM 0:02 1464 12321 1079 8.16 851 AM 0:02 12337 29 1465 1093 8.46 AM 8:50 AM 0:02 50 12343 1466 1032 7:49 AM 7:55 AM 0:02 12328 1073 11 1467 11:21 AM 11:42 AM 0:02 12336 12 1468 1010 7:03 AM 8:30 AM 0.02 12325 1107 3 1469 10:55 AM 12:59 PM 0:02 12300 1047 1470 9:11 AM 12:54 PM 0:02 12347 1007 15 1471 10:28 AM 12:45 PM 0-03 12347 36 1035 1472 8:14 AM 10:28 AM 0.03 12333 1008 27 1473 9:59 AM 10:59 AM 0:03 12309 1094 18 1474 11:47 AM 12:51 PM 0:03 12345 1057 19 1475 8:27 AM 10:59 AM 0-03 12331 10 1476 1061 10:28 AM 10:30 AM 003 12329 1034 -1 1477 8:23 AM 11:28 AM 0:03 12322 1109 2 1478 11:26 AM 12.43 PM 0:03 12331 1035 3 1479 7:26 AM 9:30 AM 0.03 4 1115 1480 10:03 AM 12:18 PM 0:04 12301 5 1481 9:21 AM 0:48 AM 1058 004 12347 6 1482 1036 8:47 AM 11:54 AM 0:04 12311 7 1483 1015 738 AM 8:56 AM 0.04 12300 1094 8 1484 8:40 AM 10:45 AM 0:04 12337 9 1485 1085 8:52 AM 11:54 AM 0:04 0 1486 12341 1010 11:49 AM 12:52 PM 0:04 12302 - 1076 Data 1 - Job Cost Totals Data 2 - Materials Requisitions Ready 12318 Data 3 - Labor Time Tickets Data 4 Get Data from Picture ILS Refresh All E Properties Edit Links Data Stocks Currencies Geography 612 + f fo B C G H + 52 Sa 54 55 56 57 58 59 60 61 52 63 64 55 56 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 99 90 91 92 93 94 95 95 97 98 99 109 101 A IN 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1499 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 11:23 AM 12:57 PM 8:03 AM 11:36 AM 8:07 AM 9:07 AM 9:47 AM 12:53 PM 11:39 AM 11:45 AM 11:36 AM 11:59 AM 7:51 AM 8:58 AM 9:35 AM 9:43 AM 7:05 AM 10:40 AM 7:57 AM 11:58 AM 9:50 AM 10:54 AM 11:40 AM 11:43 AM 7:09 AM 7:12 AM 11:07 AM 12:09 PM 9:59 AM 9:59 AM 11:23 AM 12:40 PM 7:19 AM 8:43 AM 9:49 AM 11:58 AM 11:06 AM 11:57 AM 7:37 AM 10:55 AM 10:40 AM 10:53 AM 9:14 AM 10:49 AM 9:59 AM 11:59 AM 10:34 AM 12:56 PM 9:46 AM 11:58 AM 7:31 AM 11:40 AM 8:24 AM 9:54 AM 8:03 AM 8:15 AM 10:50 AM 11:50 AM 8:42 AM 8:51 AM 10:30 AM 12:52 PM 7:27 AM 12:38 PM 10:51 AM 12:52 PM 9:44 AM 9:46 AM 9:16 AM 10:58 AM 9:25 AM 9:28 AM 7:00 AM 11:09 AM 8:06 AM 10:38 AM 8:20 AM 10:21 AM 10:59 AM 12:59 PM 8:54 AM 8:54 AM 7:54 AM 7:56 AM 10:15 AM 11:23 AM 7:30 AM 9:49 AM 9.52 AM 12:58 PM 8:14 AM 11:33 AM 10:06 AM 10:33 AM 7:47 AM 12:53 PM 7:07 AM 12:32 PM 9:03 AM 9:12 AM Data 1 - Job Cost Totals D E F WE 0:04 12314 1097 0:04 12302 1078 0:04 12313 1010 0:04 12331 1032 0:05 12345 1050 0:05 12309 1046 0:05 12308 1003 0:05 12339 1025 0:05 12343 1054 0:05 12304 1071 0:05 12337 1067 0:05 1230B 1100 0:05 12322 1065 0:06 12312 1063 0:06 12310 1117 0:06 12314 1055 0:06 12313 1070 0.00 12342 1057 0:06 12325 1101 0:08 12344 1088 0:06 12329 1072 0:06 12329 1004 0:07 12322 1015 0:07 12304 1058 0:07 12348 1100 0:08 12340 1120 0:08 12332 1048 0:08 12343 1116 0:08 12329 1007 0:08 12300 1092 0:08 12303 1048 0:08 12343 1119 0:08 12320 1038 0:08 12348 1119 0:09 12335 1069 0.09 12309 1073 0:09 12325 1084 0:09 12318 1100 0:09 12338 1115 0:09 12331 1101 0:09 12320 1090 0:09 12337 1033 0:09 12343 1009 0:09 12331 1037 0:10 12317 1048 0:10 12332 1005 0.10 12312 1091 0-10 12345 1019 0:10 12310 1013 0:10 12325 1056 Data 2 - Materials Requisitions Ready Data 3 - Labor Time Ticket Connections E Properties GOT Stocks Currencies Refresh All Data from Picture Geography Edit linics A G 538 1095 + 105 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 339 140 141 142 143 144 145 146 247 148 149 150 151 1 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 B C 9:41 AM 9:50 AM 8:47 AM 8:51 AM 8:58 AM 11:59 AM 9:20 AM 12:52 PM 8:36 AM 8:53 AM 9:06 AM 12:21 PM 7:07 AM 11:28 AM 10:25 AM 11 53 AM 7:54 AM 10:58 AM 10:38 AM 11:45 AM 9.16 AM 12:36 PM 10:52 AM 11:53 AM 9:10 AM 12:42 PM 7:29 AM 12:35 PM 9:29 AM 10:44 AM 8:31 AM 12:47 PM 11:06 AM 11:32 AM 8:36 AM 8:36 AM 3:05 AM 11:10 AM 11:55 AM 11:55 AM 9:58 AM 11:58 AM 7:00 AM 10:10 AM 10:19 AM 11:57 AM 8:44 AM 12:45 PM 11:58 AM 11:59 AM 7:12 AM 12:28 PM 7:11 AM 8:59 AM 7:56 AM 9:56 AM 10:48 AM 10:58 AM 9:47 AM 12:48 PM 10:50 AM 11:55 AM 8:21 AM 9:33 AM 11:47 AM 12:58 PM 11:22 AM 11:49 AM 7:43 AM 12:52 PM 11:56 AM 11:57 AM 7:57 AM 11:57 AM 11:25 AM 12:34 PM 11:24 AM 11:58 AM 9:11 AM 10:59 AM 9:02 AM 9:44 AM 9:16 AM 12:18 PM 11:52 AM 11:56 AM 8:01 AM 9:58 AM 9:19 AM 11:34 AM 7:17 AM 10:49 AM 8:48 AM 8:54 AM 7:42 AM 11:49 AM 9:32 AM 11:52 AM 7:21 AM 11:50 AM TANARA AL Data 1 - Job Cost Totals D E F 0:11 12344 1032 0:11 12316 1026 0:11 12328 1059 0:11 12322 1108 0:11 12314 1082 0:11 12318 1044 0:12 12350 1056 0:12 12328 1118 0:12 12310 0:12 12314 1082 0:13 12301 1067 0:13 12338 1042 0:13 12304 1032 0:18 12323 1084 0.13 12329 1049 0:13 12328 1001 0.13 12309 1102 0:13 12344 1008 0:14 12300 1037 0:14 12315 1057 0:14 12350 1106 0:14 12316 1069 0:14 12338 1091 0:14 12347 1054 0:15 12304 1081 0:16 12303 1009 0:16 12318 1061 0:16 12301 1032 0:17 12338 1051 0:18 12327 1071 0:19 12331 1048 0:19 12334 1056 0:19 12339 1029 0:19 12323 1078 0:19 12343 1041 0:20 12305 1016 0:20 12350 1064 0:21 12305 1111 0:21 12308 1002 0:21 12333 1027 0:21 12307 1018 0:23 12318 1020 0:23 12336 1104 0:23 12334 1105 0:23 12300 1115 0.24 12326 1104 0 24 12330 1087 0.24 12324 1032 0:24 12348 1096 0:24 12309 1024 13 Data 2 - Materials Requisitions Data 3-Labor Time Ticket Ready AutoSave OFT A82 case Data Draw Page Layout Insert Formulas Data Home Review View Tell me 15 Connections Properties Edit Links Currencies Stocks Geography Data from Picture Refresh All Filt Sort x x K 172 1567 152 1588 153 1589 154 1590 155 1591 156 1592 157 1593 158 1594 159 1595 160 1596 161 1597 162 1598 163 1599 164 1600 165 1601 166 1602 167 1603 1681604 169 1605 170 1606 171 1607 1608 173 1609 174 1610 175 1611 176 1612 177 1013 178 1614 179 1615 180 1616 181 1817 1618 183 1619 184 1620 185 1621 186 1622 187 1623 188 1624 189 1625 190 1625 191 1627 192 1628 193 1629 194 1630 195 1631 196 1632 1633 198 1634 199 1635 200 1636 201 1637 C D IZAM 11:50 AM 0:24 7:40 AM 10:41 AM 0:25 10:04 AM 10:35 AM 0:25 10:35 AM 11:55 AM 0:25 8:01 AM 11:39 AM 0:25 11:01 AM 11:00 AM 0.26 11:23 AM 12:51 PM 0:26 11:06 AM 11:11 AM 0:26 8:44 AM 12:45 PM 0:21 8:06 AM 8:25 AM 0.27 8:20 AM 10:35 AM 0:27 9:40 AM 12:49 PM 0:27 8:23 AM 11:42 AM 0:28 8:05 AM 9:28 AM 0:31 9:11 AM 10:43 AM 0:32 11:30 AM 12:42 PM 0:32 11:18 AM 11:50 AM 0:33 8:16 AM 12:18 PM 0:34 8:27 AM 11:29 AM 0:35 7:45 AM 11:45 AM 0.35 9:59 AM 11:59 AM 0:35 9:56 AM 11:58 AM 0:35 8:11 AM 12:19 PM 0:35 10.17 AM 11:25 AM 0:35 8:30 AM 12:41 PM 0-38 11:53 AM 11:57 AM 0:40 10:30 AM 10:49 AM 0.41 9:51 AM 11:52 AM 0.42 9:08 AM 9:20 AM 0:45 11:21 AM 11:45 AM 0:45 10:32 AM 10:34 AM 0:45 9:26 AM 9:35 AM 0:46 11:48 AM 11:51 AM 0:51 7:33 AM 11:49 AM 0:55 8.32 AM 11:52 AM 1:00 11:52 AM 11:58 AM 1:00 8.34 AM 12:43 PM 1:00 8:59 AM 12:59 PM 1:00 10:16 AM 10:51 AM 1:00 7:50 AM 9:52 AM 1:00 9:23 AM 11:51 AM 1:00 10:01 AM 12:52 PM 1:00 8.42 AM 10:43 AM 1:00 9:12 AM 10:18 AM 1:00 7:34 AM 12:51 PM 1:00 11:51 AM 11:58 AM 1:00 10:04 AM 12:33 PM 1.00 9:18 AM 11:49 AM 1:00 8.51 AM 11:54 AM 1:00 11:15 AM 11:26 AM 1:00 10:56 AM 11:57 AM 1:00 Data 1 - Job Cost Totals G 1230 1024 12306 1038 12306 1035 12345 1065 12341 1102 12309 1012 12330 1023 12339 1095 12320 1079 12332 1013 12304 1054 12323 1022 12338 1041 12334 1048 12322 1017 12328 1100 12320 1070 12348 1098 12333 1052 12306 1042 12300 1027 12347 1120 12309 1082 12309 1114 12311 1050 12336 1027 12311 1068 12338 1111 12300 1080 12306 1032 12328 1059 12314 1031 12309 1028 12317 1023 12343 1086 12317 1058 12350 1024 12340 1055 12339 1043 12309 1108 12345 1084 12314 1098 12301 1109 12334 1009 12331 1097 12329 1013 12336 1020 12327 1008 12318 1074 12327 1046 12334 1047 Data 2 - Materials Requisitions 182 - 197 Data 3 - Labor Time Tickets Ready Data Insert Home Draw Page Layout Formulas Data Review View Connections E Properties Edit Links Stocles Refresh All Currencies Geography Data from Picture 12 B E F H 552 853 1112 654 655 656 657 658 659 660 661 662 563 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 579 680 681 682 683 684 685 686 687 688 689 690 591 692 693 694 695 696 697 698 699 700 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2528 2129 2130 2131 2132 2133 2134 2135 2136 2137 7:11 AM 8:34 AM 11:54 AM 12:58 PM 7:08 AM 10:49 AM 7:03 AM 8:09 AM 11:12 AM 12:20 PM 7:46 AM 12:55 PM 7:17 AM 10:19 AM 7.31 AM 9:48 AM 10.02 AM 12:50 PM 11:06 AM 11:21 AM 9:50 AM 10:52 AM 10:07 AM 11:22 AM 9:14 AM 9:46 AM 11:28 AM 11:44 AM 9:14 AM 10:26 AM 8:39 AM 11:40 AM 8:06 AM 11:25 AM 7:25 AM 9:54 AM 9:12 AM 11:21 AM 7:27 AM 10:43 AM 7:04 AM 8:31 AM 9.47 AM 10:47 AM 11:50 AM 12:59 PM 7:16 AM 10:52 AM 10:35 AM 10:45 AM 9:38 AM 10:48 AM 8:33 AM 11:36 AM 9:59 AM 11:59 AM 9:41 AM 9:55 AM 7:10 AM 8:59 AM 11:42 AM 12:52 PM 10:36 AM 10:43 AM 11:29 AM 12:56 PM 8:47 AM 12:50 PM 8:17 AM 11:46 AM 9:18 AM 12:50 PM 7:43 AM 9:43 AM 8:52 AM 9:55 AM 10:21 AM 11:50 AM 7:21 AM 12:34 PM 8:48 AM 12:54 PM 7:01 AM 11:36 AM 7:34 AM 7:39 AM 8:38 AM 11:48 AM 8:48 AM 10:53 AM 9 55 AM 12:56 PM 7:27 AM 7:39 AM 7:39 AM 9:47 AM 7:11 AM 12:18 PM 10 28 AM 10:54 AM Data 1 - Job Cost Totals 4:03 12327 1068 4:06 12325 1073 4:07 12349 1074 4:07 12335 1050 4:08 12313 1106 4:09 12303 1109 4:09 12323 1056 4:09 12322 1039 4:10 12310 1093 4:11 12346 1033 4:12 12323 4:13 12326 1073 4-15 12324 1045 4:16 12316 1015 4:16 12308 1043 4:16 12345 1059 4:16 12324 1049 4:21 12313 1025 4.24 12312 1016 4.25 12311 1040 4.29 12312 1074 4:33 12319 1097 4:35 12315 1093 4:42 12345 1114 4:45 12347 1033 4:48 12337 1084 4:50 12341 1010 5:00 12300 1025 5:03 12330 1008 5:06 12334 1080 5:06 12304 1104 5.07 12300 1117 5:07 12309 1040 5:08 12321 1057 5:08 12340 1099 5:09 12313 1000 5:09 12335 1026 5:11 1062 5:13 12318 1014 5:16 12324 1088 5:17 12320 1088 5.17 12314 1083 5.17 12336 1029 5:18 12339 1099 5:20 12303 1102 5:25 12340 1093 5:27 12340 1038 5:20 12319 1026 5:35 12305 1115 5:46 12320 1012 Data 2 - Materials Requisitions 12317 101 Data 3-Labor Time Ready Charlie Anderson, Thoni's CFO, is concerned that some employees may not be appropriately recording the time worked on specific jobs. Sort the labor time tickets by time worked. What do you notice? B 1 , . EE E 3 99 = 1 TT: O Words e Textbook and Media What other information would help Charlie evaluate the appropriateness of the time recorded? AutoSave OFF case Home Insert Draw Page Layout Formulas Data Data Review View Tell me Connections Properties Edit Linics 2. > Get Data Data from Picture Refresh All Stocks Currencies Geography Sort E G12 fx G 1 + A B C D F 1 Time Ticket Start Time End Time Time Worke-1 Job Number Employee 2 1438 9:53 AM 11:54 AM 0:00 12343 3 1025 1439 11:34 AM 12:53 PM 0.00 4 12330 1007 1440 9:53 AM 9:55 AM 0.00 S 1441 12330 1102 7:29 AM 12:58 PM 0:00 6 12349 1442 1043 7:41 AM 7:49 AM 0:00 12322 1100 7 1443 8:46 AM 8:56 AM 0:00 8 12350 1444 1015 11:19 AM 12:53 PM 0:00 9 12332 1120 1445 11:49 AM 11:57 AM 0:00 12307 1055 10 1446 8:14 AM 11:48 AM 0.00 11 12333 1447 1070 10:43 AM 10:47 AM 0:00 12 12318 1448 1027 7:01 AM 10:59 AM 0:00 13 12312 1449 1038 10:16 AM 11 36 AM 0:00 24 12346 1450 8:57 AM 8:58 AM 1039 15 0:01 12340 1451 1070 8:42 AM 10:43 AM 0:01 26 1452 12325 1080 8:28 AM 8:52 AM 0:01 27 1453 12309 1042 8:17 AM 11:27 AM 0.01 12318 18 1454 1010 11:03 AM 12:30 PM 001 19 12317 1010 1455 11:00 AM 12:58 PM 0:09 12317 20 1456 1037 11 01 AM 12:18 PM 0:01 21 12321 1014 1457 7:57 AM 8:58 AM 22 0:01 12335 1007 1458 9:13 AM 12:23 PM 001 23 1459 12345 1062 8:42 AM 9:42 AM 24 0:02 12340 1094 1460 10:49 AM 12:59 PM 0:02 12330 1011 25 1461 9:59 AM 12:50 PM 0:02 26 12304 1047 1462 9:45 AM 12:51 PM 27 0:02 12338 1104 1463 10:59 AM 12:59 PM 0:02 1464 12321 1079 8.16 851 AM 0:02 12337 29 1465 1093 8.46 AM 8:50 AM 0:02 50 12343 1466 1032 7:49 AM 7:55 AM 0:02 12328 1073 11 1467 11:21 AM 11:42 AM 0:02 12336 12 1468 1010 7:03 AM 8:30 AM 0.02 12325 1107 3 1469 10:55 AM 12:59 PM 0:02 12300 1047 1470 9:11 AM 12:54 PM 0:02 12347 1007 15 1471 10:28 AM 12:45 PM 0-03 12347 36 1035 1472 8:14 AM 10:28 AM 0.03 12333 1008 27 1473 9:59 AM 10:59 AM 0:03 12309 1094 18 1474 11:47 AM 12:51 PM 0:03 12345 1057 19 1475 8:27 AM 10:59 AM 0-03 12331 10 1476 1061 10:28 AM 10:30 AM 003 12329 1034 -1 1477 8:23 AM 11:28 AM 0:03 12322 1109 2 1478 11:26 AM 12.43 PM 0:03 12331 1035 3 1479 7:26 AM 9:30 AM 0.03 4 1115 1480 10:03 AM 12:18 PM 0:04 12301 5 1481 9:21 AM 0:48 AM 1058 004 12347 6 1482 1036 8:47 AM 11:54 AM 0:04 12311 7 1483 1015 738 AM 8:56 AM 0.04 12300 1094 8 1484 8:40 AM 10:45 AM 0:04 12337 9 1485 1085 8:52 AM 11:54 AM 0:04 0 1486 12341 1010 11:49 AM 12:52 PM 0:04 12302 - 1076 Data 1 - Job Cost Totals Data 2 - Materials Requisitions Ready 12318 Data 3 - Labor Time Tickets Data 4 Get Data from Picture ILS Refresh All E Properties Edit Links Data Stocks Currencies Geography 612 + f fo B C G H + 52 Sa 54 55 56 57 58 59 60 61 52 63 64 55 56 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 99 90 91 92 93 94 95 95 97 98 99 109 101 A IN 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1499 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 11:23 AM 12:57 PM 8:03 AM 11:36 AM 8:07 AM 9:07 AM 9:47 AM 12:53 PM 11:39 AM 11:45 AM 11:36 AM 11:59 AM 7:51 AM 8:58 AM 9:35 AM 9:43 AM 7:05 AM 10:40 AM 7:57 AM 11:58 AM 9:50 AM 10:54 AM 11:40 AM 11:43 AM 7:09 AM 7:12 AM 11:07 AM 12:09 PM 9:59 AM 9:59 AM 11:23 AM 12:40 PM 7:19 AM 8:43 AM 9:49 AM 11:58 AM 11:06 AM 11:57 AM 7:37 AM 10:55 AM 10:40 AM 10:53 AM 9:14 AM 10:49 AM 9:59 AM 11:59 AM 10:34 AM 12:56 PM 9:46 AM 11:58 AM 7:31 AM 11:40 AM 8:24 AM 9:54 AM 8:03 AM 8:15 AM 10:50 AM 11:50 AM 8:42 AM 8:51 AM 10:30 AM 12:52 PM 7:27 AM 12:38 PM 10:51 AM 12:52 PM 9:44 AM 9:46 AM 9:16 AM 10:58 AM 9:25 AM 9:28 AM 7:00 AM 11:09 AM 8:06 AM 10:38 AM 8:20 AM 10:21 AM 10:59 AM 12:59 PM 8:54 AM 8:54 AM 7:54 AM 7:56 AM 10:15 AM 11:23 AM 7:30 AM 9:49 AM 9.52 AM 12:58 PM 8:14 AM 11:33 AM 10:06 AM 10:33 AM 7:47 AM 12:53 PM 7:07 AM 12:32 PM 9:03 AM 9:12 AM Data 1 - Job Cost Totals D E F WE 0:04 12314 1097 0:04 12302 1078 0:04 12313 1010 0:04 12331 1032 0:05 12345 1050 0:05 12309 1046 0:05 12308 1003 0:05 12339 1025 0:05 12343 1054 0:05 12304 1071 0:05 12337 1067 0:05 1230B 1100 0:05 12322 1065 0:06 12312 1063 0:06 12310 1117 0:06 12314 1055 0:06 12313 1070 0.00 12342 1057 0:06 12325 1101 0:08 12344 1088 0:06 12329 1072 0:06 12329 1004 0:07 12322 1015 0:07 12304 1058 0:07 12348 1100 0:08 12340 1120 0:08 12332 1048 0:08 12343 1116 0:08 12329 1007 0:08 12300 1092 0:08 12303 1048 0:08 12343 1119 0:08 12320 1038 0:08 12348 1119 0:09 12335 1069 0.09 12309 1073 0:09 12325 1084 0:09 12318 1100 0:09 12338 1115 0:09 12331 1101 0:09 12320 1090 0:09 12337 1033 0:09 12343 1009 0:09 12331 1037 0:10 12317 1048 0:10 12332 1005 0.10 12312 1091 0-10 12345 1019 0:10 12310 1013 0:10 12325 1056 Data 2 - Materials Requisitions Ready Data 3 - Labor Time Ticket Connections E Properties GOT Stocks Currencies Refresh All Data from Picture Geography Edit linics A G 538 1095 + 105 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 339 140 141 142 143 144 145 146 247 148 149 150 151 1 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 B C 9:41 AM 9:50 AM 8:47 AM 8:51 AM 8:58 AM 11:59 AM 9:20 AM 12:52 PM 8:36 AM 8:53 AM 9:06 AM 12:21 PM 7:07 AM 11:28 AM 10:25 AM 11 53 AM 7:54 AM 10:58 AM 10:38 AM 11:45 AM 9.16 AM 12:36 PM 10:52 AM 11:53 AM 9:10 AM 12:42 PM 7:29 AM 12:35 PM 9:29 AM 10:44 AM 8:31 AM 12:47 PM 11:06 AM 11:32 AM 8:36 AM 8:36 AM 3:05 AM 11:10 AM 11:55 AM 11:55 AM 9:58 AM 11:58 AM 7:00 AM 10:10 AM 10:19 AM 11:57 AM 8:44 AM 12:45 PM 11:58 AM 11:59 AM 7:12 AM 12:28 PM 7:11 AM 8:59 AM 7:56 AM 9:56 AM 10:48 AM 10:58 AM 9:47 AM 12:48 PM 10:50 AM 11:55 AM 8:21 AM 9:33 AM 11:47 AM 12:58 PM 11:22 AM 11:49 AM 7:43 AM 12:52 PM 11:56 AM 11:57 AM 7:57 AM 11:57 AM 11:25 AM 12:34 PM 11:24 AM 11:58 AM 9:11 AM 10:59 AM 9:02 AM 9:44 AM 9:16 AM 12:18 PM 11:52 AM 11:56 AM 8:01 AM 9:58 AM 9:19 AM 11:34 AM 7:17 AM 10:49 AM 8:48 AM 8:54 AM 7:42 AM 11:49 AM 9:32 AM 11:52 AM 7:21 AM 11:50 AM TANARA AL Data 1 - Job Cost Totals D E F 0:11 12344 1032 0:11 12316 1026 0:11 12328 1059 0:11 12322 1108 0:11 12314 1082 0:11 12318 1044 0:12 12350 1056 0:12 12328 1118 0:12 12310 0:12 12314 1082 0:13 12301 1067 0:13 12338 1042 0:13 12304 1032 0:18 12323 1084 0.13 12329 1049 0:13 12328 1001 0.13 12309 1102 0:13 12344 1008 0:14 12300 1037 0:14 12315 1057 0:14 12350 1106 0:14 12316 1069 0:14 12338 1091 0:14 12347 1054 0:15 12304 1081 0:16 12303 1009 0:16 12318 1061 0:16 12301 1032 0:17 12338 1051 0:18 12327 1071 0:19 12331 1048 0:19 12334 1056 0:19 12339 1029 0:19 12323 1078 0:19 12343 1041 0:20 12305 1016 0:20 12350 1064 0:21 12305 1111 0:21 12308 1002 0:21 12333 1027 0:21 12307 1018 0:23 12318 1020 0:23 12336 1104 0:23 12334 1105 0:23 12300 1115 0.24 12326 1104 0 24 12330 1087 0.24 12324 1032 0:24 12348 1096 0:24 12309 1024 13 Data 2 - Materials Requisitions Data 3-Labor Time Ticket Ready AutoSave OFT A82 case Data Draw Page Layout Insert Formulas Data Home Review View Tell me 15 Connections Properties Edit Links Currencies Stocks Geography Data from Picture Refresh All Filt Sort x x K 172 1567 152 1588 153 1589 154 1590 155 1591 156 1592 157 1593 158 1594 159 1595 160 1596 161 1597 162 1598 163 1599 164 1600 165 1601 166 1602 167 1603 1681604 169 1605 170 1606 171 1607 1608 173 1609 174 1610 175 1611 176 1612 177 1013 178 1614 179 1615 180 1616 181 1817 1618 183 1619 184 1620 185 1621 186 1622 187 1623 188 1624 189 1625 190 1625 191 1627 192 1628 193 1629 194 1630 195 1631 196 1632 1633 198 1634 199 1635 200 1636 201 1637 C D IZAM 11:50 AM 0:24 7:40 AM 10:41 AM 0:25 10:04 AM 10:35 AM 0:25 10:35 AM 11:55 AM 0:25 8:01 AM 11:39 AM 0:25 11:01 AM 11:00 AM 0.26 11:23 AM 12:51 PM 0:26 11:06 AM 11:11 AM 0:26 8:44 AM 12:45 PM 0:21 8:06 AM 8:25 AM 0.27 8:20 AM 10:35 AM 0:27 9:40 AM 12:49 PM 0:27 8:23 AM 11:42 AM 0:28 8:05 AM 9:28 AM 0:31 9:11 AM 10:43 AM 0:32 11:30 AM 12:42 PM 0:32 11:18 AM 11:50 AM 0:33 8:16 AM 12:18 PM 0:34 8:27 AM 11:29 AM 0:35 7:45 AM 11:45 AM 0.35 9:59 AM 11:59 AM 0:35 9:56 AM 11:58 AM 0:35 8:11 AM 12:19 PM 0:35 10.17 AM 11:25 AM 0:35 8:30 AM 12:41 PM 0-38 11:53 AM 11:57 AM 0:40 10:30 AM 10:49 AM 0.41 9:51 AM 11:52 AM 0.42 9:08 AM 9:20 AM 0:45 11:21 AM 11:45 AM 0:45 10:32 AM 10:34 AM 0:45 9:26 AM 9:35 AM 0:46 11:48 AM 11:51 AM 0:51 7:33 AM 11:49 AM 0:55 8.32 AM 11:52 AM 1:00 11:52 AM 11:58 AM 1:00 8.34 AM 12:43 PM 1:00 8:59 AM 12:59 PM 1:00 10:16 AM 10:51 AM 1:00 7:50 AM 9:52 AM 1:00 9:23 AM 11:51 AM 1:00 10:01 AM 12:52 PM 1:00 8.42 AM 10:43 AM 1:00 9:12 AM 10:18 AM 1:00 7:34 AM 12:51 PM 1:00 11:51 AM 11:58 AM 1:00 10:04 AM 12:33 PM 1.00 9:18 AM 11:49 AM 1:00 8.51 AM 11:54 AM 1:00 11:15 AM 11:26 AM 1:00 10:56 AM 11:57 AM 1:00 Data 1 - Job Cost Totals G 1230 1024 12306 1038 12306 1035 12345 1065 12341 1102 12309 1012 12330 1023 12339 1095 12320 1079 12332 1013 12304 1054 12323 1022 12338 1041 12334 1048 12322 1017 12328 1100 12320 1070 12348 1098 12333 1052 12306 1042 12300 1027 12347 1120 12309 1082 12309 1114 12311 1050 12336 1027 12311 1068 12338 1111 12300 1080 12306 1032 12328 1059 12314 1031 12309 1028 12317 1023 12343 1086 12317 1058 12350 1024 12340 1055 12339 1043 12309 1108 12345 1084 12314 1098 12301 1109 12334 1009 12331 1097 12329 1013 12336 1020 12327 1008 12318 1074 12327 1046 12334 1047 Data 2 - Materials Requisitions 182 - 197 Data 3 - Labor Time Tickets Ready Data Insert Home Draw Page Layout Formulas Data Review View Connections E Properties Edit Links Stocles Refresh All Currencies Geography Data from Picture 12 B E F H 552 853 1112 654 655 656 657 658 659 660 661 662 563 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 579 680 681 682 683 684 685 686 687 688 689 690 591 692 693 694 695 696 697 698 699 700 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2528 2129 2130 2131 2132 2133 2134 2135 2136 2137 7:11 AM 8:34 AM 11:54 AM 12:58 PM 7:08 AM 10:49 AM 7:03 AM 8:09 AM 11:12 AM 12:20 PM 7:46 AM 12:55 PM 7:17 AM 10:19 AM 7.31 AM 9:48 AM 10.02 AM 12:50 PM 11:06 AM 11:21 AM 9:50 AM 10:52 AM 10:07 AM 11:22 AM 9:14 AM 9:46 AM 11:28 AM 11:44 AM 9:14 AM 10:26 AM 8:39 AM 11:40 AM 8:06 AM 11:25 AM 7:25 AM 9:54 AM 9:12 AM 11:21 AM 7:27 AM 10:43 AM 7:04 AM 8:31 AM 9.47 AM 10:47 AM 11:50 AM 12:59 PM 7:16 AM 10:52 AM 10:35 AM 10:45 AM 9:38 AM 10:48 AM 8:33 AM 11:36 AM 9:59 AM 11:59 AM 9:41 AM 9:55 AM 7:10 AM 8:59 AM 11:42 AM 12:52 PM 10:36 AM 10:43 AM 11:29 AM 12:56 PM 8:47 AM 12:50 PM 8:17 AM 11:46 AM 9:18 AM 12:50 PM 7:43 AM 9:43 AM 8:52 AM 9:55 AM 10:21 AM 11:50 AM 7:21 AM 12:34 PM 8:48 AM 12:54 PM 7:01 AM 11:36 AM 7:34 AM 7:39 AM 8:38 AM 11:48 AM 8:48 AM 10:53 AM 9 55 AM 12:56 PM 7:27 AM 7:39 AM 7:39 AM 9:47 AM 7:11 AM 12:18 PM 10 28 AM 10:54 AM Data 1 - Job Cost Totals 4:03 12327 1068 4:06 12325 1073 4:07 12349 1074 4:07 12335 1050 4:08 12313 1106 4:09 12303 1109 4:09 12323 1056 4:09 12322 1039 4:10 12310 1093 4:11 12346 1033 4:12 12323 4:13 12326 1073 4-15 12324 1045 4:16 12316 1015 4:16 12308 1043 4:16 12345 1059 4:16 12324 1049 4:21 12313 1025 4.24 12312 1016 4.25 12311 1040 4.29 12312 1074 4:33 12319 1097 4:35 12315 1093 4:42 12345 1114 4:45 12347 1033 4:48 12337 1084 4:50 12341 1010 5:00 12300 1025 5:03 12330 1008 5:06 12334 1080 5:06 12304 1104 5.07 12300 1117 5:07 12309 1040 5:08 12321 1057 5:08 12340 1099 5:09 12313 1000 5:09 12335 1026 5:11 1062 5:13 12318 1014 5:16 12324 1088 5:17 12320 1088 5.17 12314 1083 5.17 12336 1029 5:18 12339 1099 5:20 12303 1102 5:25 12340 1093 5:27 12340 1038 5:20 12319 1026 5:35 12305 1115 5:46 12320 1012 Data 2 - Materials Requisitions 12317 101 Data 3-Labor Time Ready Charlie Anderson, Thoni's CFO, is concerned that some employees may not be appropriately recording the time worked on specific jobs. Sort the labor time tickets by time worked. What do you notice? B 1 , . EE E 3 99 = 1 TT: O Words e Textbook and Media What other information would help Charlie evaluate the appropriateness of the time recorded