I need help to complete the Analytics part, please.

Using the tables on the 'Sales Team' and 'Current Customers' tabs, please develop analytics (in this case, excel formulas) to test the full population of 2020 transactions. To assist, the 'Sales Transaction Journal' tab contains four data columns. Each column requires its own forumla as noted below: Column Name Sales Order Sequence Description of Test/Formula The formula should test whether the row is in sequence (in numerical order by Sales Order #). Valid Sales Team Member The formula should test whether the transaction's sales person was a Valid Sales Team Member (from the 'Sales Team' tab) Valid Customer The formula should test whether the transaction's buyer was a Valid Customer (from the 'Current Customers' tab) Sale before Delivery This formula should test whether the Date of Sale occurred prior to the delivery. ID Term date cadams jsmith Current sales team Name 1 Carla Adams 2 John Smith 3 Rosa Acea 4 Vincent Robinson Jane Mason Larry Evans racea 5 vrobinson jmason levans 7/6/2021 CO 3/30/2021 Current customers ID # 1 3245 2 Name Laptops-R-Us PC Mart PC Discount Laptops-4-Less 3246 3 3247 4 3248 Analytics Valid Sales Team Member Sales Order Sequence Valid Customer Sale before Delivery Customer # 3246 Sales Order # 3356700 3356701 3356702 3247 3246 3356703 3356704 3246 3248 3356705 3247 3356706 3245 3248 3245 3246 3245 3245 3356707 3356708 3356709 3356710 3356711 3356712 3356713 3356714 3356715 3356715 3356716 33567171 3356718 3356719 3356720 3247 3245 3248 3247 Sales Transactions Purchase Order Date Total Sales Amount Sales Person ID 1/4/2021 $ 350,000.00 cadams 1/8/2021 $ 350,000.00 lismith 1/11/2021 $ 150,000.00 lismith 1/15/2021 $ 200,000.00 racea 1/18/2021 $ 350,000.00 ljmason 1/19/2021 $ 150,000.00 vrobinson 1/22/2021 $ 350,000.00 jsmith 1/24/2021 $ 300,000.00 cadams 1/26/2021 $ 200,000.00 levans 1/27/2021 $ 200,000.00 vrobinson 1/28/2021 $ 200,000.00 cadams 2/1/2021 $ 300,000.00 cadams 2/2/2021 $ 150,000.00 levans 2/5/2021 $ 350,000.00 lismith 2/9/2021 $ 200,000.00 cadams 2/11/2021 $ 100,000.00 cadams 2/11/2021 $ 100,000.00 cadams 2/13/2021 $ 150,000.00 lismith 2/17/2021 $ 100,000.00 racea 2/20/2021 $ 150,000.00 cadams 2/24/2021 $ 100,000.00 [jmason 2/26/2021 $ 250,000.00 vrobinson 2/28/2021 $ 350,000.00 vrobinson 3/2/2021 $ 300,000.00 cadams 3/3/2021 $ 300,000.00 cadams 3/6/2021 $ 150,000.00 racea 3/8/2021 $ 100,000.00 ljsmith 3/12/2021 $ 350,000.00 cadams 3/13/2021 $ 300,000.00 levans Delivery Date 1/7/2021 1/9/2021 1/13/2021 1/16/2021 1/19/2021 1/22/2021 1/24/2021 1/26/2021 1/28/2021 1/28/2021 1/29/2021 2/3/2021 2/3/2021 2/6/2021 2/10/2021 2/12/2021 2/12/2021 2/16/2021 2/20/2021 2/22/2021 2/25/2021 2/28/2021 3/1/2021 3/4/2021 3/5/2021 3/8/2021 3/11/2021 3/14/2021 3/14/2021 3247 3248 3248 3246 3245 3248 3246 3356721 3356722 3356723 3247 3245 3247 3356724 3356725 3246 3246 3356726 3356727 3245