Please answer all questions

A B C 1 Check Numbers 2 1399 3 1401 4 1403 5 1404 6 1406 7 1407 8 1408 9 1410 10 1412 1414 12 1415 13 1416 14 1417 15 1419 16 1420 17 1421 18 1423 19 1425 20 1426 21 1427 22 1428 23 1430 24 1431 25 1432 26 1433 27 1434 28 1435 29 1436 30 1438 31 1439 32 1440 33 1443 34 1444 35 1447 36 1449 37 1450 38 1451 39 1452 40 1453 41 1454 42 1455 43 1456 44 1457 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 S9 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 1457 1458 1459 1460 1461 1463 1464 1465 1466 1467 1468 1469 1471 1472 1473 1474 1476 1477 1478 1479 1480 1481 1483 1484 1485 1486 1487 1488 1489 1490 1491 1493 1494 1495 1496 1497 1499 1500 1501 1503 1504 1505 1506 Sheet1 C A 85 1505 86 1506 87 1507 88 1508 89 1509 90 1510 91 1511 92 1512 93 1513 94 1515 95 1516 96 1517 97 1518 98 1519 99 1520 100 1521 101 1524 102 1525 103 1526 104 1527 105 1528 106 1529 107 1530 108 1531 109 1532 110 1533 111 1534 112 1536 113 1537 114 1538 115 1539 116 1541 117 1543 118 1545 119 1546 120 1547 121 1548 122 1549 123 1550 124 1552 125 1553 126 1554 127 1555 128 1556 C A IZT 1555 128 1556 129 1557 130 1558 131 1559 132 1560 133 1561 134 1563 135 1564 136 1565 137 1566 138 1567 139 1568 140 1569 141 1570 142 1572 143 1574 144 1575 145 1577 146 1578 147 1579 148 1580 149 1581 150 1583 151 1584 152 1585 153 1586 154 1588 155 1589 156 157 1593 158 1594 159 1595 160 1596 161 1597 162 1598 163 1599 164 1600 165 1601 166 1603 167 168 1605 169 1606 170 1607 1590 1604 B 169 1606 170 1607 171 1608 172 1609 173 1610 174 1611 175 1612 176 1613 177 1614 178 1615 179 1617 180 1618 181 1619 182 1620 183 1621 184 1623 185 1624 186 1625 187 1626 188 1627 189 1628 190 1629 191 1630 192 1631 193 1632 194 1633 195 1634 196 1636 197 1637 198 1638 199 1639 200 1641 201 1643 202 1644 1645 204 1646 205 1647 206 1648 207 1649 208 209 1651 210 1652 211 1653 212 1654 203 1650 A 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 1655 1656 1657 1658 1659 1660 1661 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1674 1675 1674 1684 1683 1684 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1703 1704 1705 1706 1707 Sheet1 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1723 1724 1725 1726 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1743 1744 1745 1746 1747 1748 1749 1750 1751 282 + 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 Sheet1 + Ready B C D E G Z90 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 A 1730 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1763 1764 1766 1769 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792 1793 1794 1796 1797 1798 1799 1800 + 336 337 338 339 Sheet1 Re 8 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 1799 1800 1801 1804 1805 1806 1807 1808 1809 1810 1811 1813 1814 1815 1816 1817 1818 1819 1820 1821 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1843 1844 1845 1640 17 359 + 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 275 376 377 378 379 380 381 B 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 395 397 398 399 400 401 1847 1848 1849 1850 1851 1852 1853 1854 1857 1858 1859 1861 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 + 1880 1881 1883 1884 1886 1887 402 403 404 405 406 407 408 409 410 411 412 414 415 416 417 419 420 1889 1890 1891 1692 422 1894 1 TA Sheet Read B 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 20 1895 1896 1897 1898 1899 1900 1901 1903 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1923 1924 1925 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 446 447 448 449 450 451 452 + 455 456 457 450 459 460 461 163 466 1940 B 264 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 1940 1941 1943 1945 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1963 1964 1965 1966 1967 1968 1969 1971 1972 1973 1974 1975 1976 1977 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 Required: 1. In this sequence gap analysis, check 1474 is not highlighted. What does that mean regarding check 1474 or check 14757 Check 1476 is missing Check 1474 is missing Checks 1474 and 1475 are missing o Check 1475 is missing 2. In this sequence gap analysis, check 1444 and check 1447 are not highlighted. Given this, where does the sequence gap tie? o Checks 1445 and 1446 are missing Checks 1445 and 1446 and 1448 are missing Checks 1444 and 1445 are missing Checks 1444 and 1447 are missing 3. Check 1481 is missing O False True 3. Check 1481 is missing. O False True 4. In this sequence gap analysis, check 1701 is not highlighted. Given this, where does the sequence gap le? Checks 1701 is missing Checks 1702 is missing No checks are missing Checks 1703 is missing 5. Using conditional formatting the items not highlighted in this analysis are those where a gap exists after a gap exists before a gap exists Select "OK" on the Formatting tab and select "OK" on the New Formatting Rule screen (as shown in 7.54). The cells P363 not highlighted in red are those items just before the sequence pap and thus highlight the pap. The completed sequence pp analysis is as follows: EXHIBIT 754 1 Check Numbers 2 1000 3 1001 4 1002 5 100 6 1005 7 1002 8 1008 9 1009 10 1010 11 1011 12 1013 13 1013 14 15 16 17 1016 1017 1018 1020 1021 18 Page 164 Share the Story Now that the sequence gap has been found on the check register, the internal auditor can investigate the reason for the gap, be it voided checks, checks that had a stop payment, missing checks, or possible irregularity or fraud. The internal auditor can then go to the bank statement to see which checks were paid or not paid with funds from the company's bank account Assessment: 1. Take a screenshot of your final bank reconciliation, and label it "Lab 76 Submission jpg", 2. Answer the multiple choice questions in Connect