Please show steps in excel

Problem 3: The Transportation Security Administration (TSA) has assembled a random list of 40 ft containers passing through 5 US East Coast container ports--Baltimore (Bal), New York/New Jersey (NY-NJ), Charleston (Chlsn), Jacksonville (Jxsvl). They are identified by weight in Metric tons (Tonnes), shipper (NYK, EG, M, CSCL), and delivery port. Each observation represents manifest information of a vessel call designated for further examined by a forensic group at TSA. Perform a multi-level sort of the list (not including the "OBS" column) by "Shipper" (A-Z), "Port" (A-Z), and "# of 40 ft Cntrs" (Smallest-Largest). Complete the sort in the order provided. ***Caution: Save a copy of the original data. After a sort in a) you will need to return to the original data.**** a) What is the Tonnes value for the new 18th OBS (remember to not include OBS in the sort)? ta b) Return to the original unsorted data. Create a Custom Sort for shippers that sorts in the following Custom order--NYK, EG, CSCL, and M (just shippers, not also tonnes). What is the 45th OBS value for Tonnes? (hint: Create a "custom list" under the "order" tab in "custom sort" tool. Also, remember to not include OBS in the sort) c) Which of the following formulas will allow you to accurately count the simultaneous occurrence of records with VA in the Port column and M in the Shipper column of the original Port data? Assume the Port Data is located in the upper left-hand corner of a worksheet (OBS is in cell A1): W) =COUNTIFS(D2:D79,"M", E2:E79,"VA") X) =COUNTIF(E2:E79,"VA")+COUNTIF(D2:D79, "M") Y) both W) and X) Z) none of the above 1 2 3 4 5 A B OBS # of 40 ft Cntrs. 31,766 52,275 34,168 31,385 42,800 49,925 51,070 18,729 23,690 26,611 31,697 38,751 16,511 13,819 24,572 31,148 44,549 40,021 38,259 49,007 34,989 50,708 30,810 36,040 47,100 15,113 36,349 45,615 53,581 40,924 45,331 28,397 45,455 52,598 50,531 41,645 50,992 20 000 GAWN - 1 2 3 4 6 7 8 9 8 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 29 28 30 29 31 30 32 31 33 32 34 33 35 34 36 35 37 36 38 37 5 6 7 D Shipper Tonnes 1,182,664 EG 398,361 NYK 1,390,618 NYK 1,601,501 NYK 483,710 NYK 1,165,691 EG 643,632 NYK 491,018 CSCL 1,372,957 EG 1,368,792 M 448,773 EG 976,205 NYK 1,221,523 NYK 1,156,106 NYK 1,517,366 EG 794,388 M 484,601 NYK 596,983 M 993,594 NYK 525,653 NYK 1,276,407 NYK 1,462,923 NYK 513,322 M 1,017,254 M 1,037,689 EG 396,621 EG 841,083 EG 1,193,597 NYK 978,729 NYK 1,304,651 M 1,413,944 EG 701,044 NYK 948,631 EG 1,322,153 EG 574,556 EG 723 EG 1,333,123 NYK E Port NY-NJ Bal NY-NJ Chisn VA Chisn VA VA VA NY-NJ NY-NJ NY-NJ VA VA NY-NJ NY-NJ Chisn Chisn NY-NJ VA Jxsvl NY-NJ VA Jxsvl Chisn NY-NJ VA NY-NJ NY-NJ NY-NJ Chisn Jxsvl VA NY-NJ Bal NY-NJ NY-NJ 8349985NXXRAh8880228885882FN2R2F22: 41 44 46 47 51 56 57 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77