what the formula in Excel to use to :

1. verify that every sales transaction has a shipping number and Fedex identification number. identify and quantify any sales that have not been shipped (including names of customers and transaction numbers)

2.verify that every shipping number has a recorded sales transaction. identify and quantify the cost of sales for products shipped without a sale being recorded (including names of customers and transaction numbers)

3.Identify shipments that occurred in a period other than 2017. identify and quantify any sales and the cost of sales for amounts recorded in the improper period (including name of customers and transaction numbers)