I need help with a-d and especially the formulas to recieve the correct answer. Please give detail, thanks!!!

a. Calculate the miles traveled for each route: use the mileage table to lookup pickup city and dropoff city coordinates. b. Create a conditional formatting rule to highlight route table rows with miles traveled greater than required mileage break: your rule will need to lookup the mileage break value for each truck driver. c. Determine which driver traveled the maximum number of miles on their 1st route. d. Count the number of truck drivers who travel from Vienna to Baltimore or from Baltimore to Vienna.

Practice 3 (Lecture 3) a Caiculate the miles traveled for each route: use the mileage toble to lookup pickup city and dropoff city coordinates b Create a conditional formatting rule to highlight route tuble rows with niies truveled greuter thon required mileuge breuk: your rule wil need to lookup the mileage break vulue for euch truck driver c Determine which driver traveled the maximum number of miies on their 1st route. d Count the number of truck drivers who travel from Vienna to Baltimore or from boltimore to Vienna. Mileage Alexandria 35.2 83.2 22.4 27.2 /U.1 43.2 83.2 35.2 22.4 27.2 Alexandria Springfield 70.4 43.2 41.6 Truck Driver ID Route Order Picku ABC1234 ABC1234 ABC1234 DEF5678 DEF5678 DEFS67B DEF567R GHI9101 GHI9101 GHI9101 KL1121 KL1121 IKI 1121 KL1121 MN03141 MNO3141 MNU3111 POR5161 POR5161 POR5161 STU7181 STU7181 STU7181 Truck Driver ID ABC1234 DEF5678 GH19101 KL1121 MNO3141 POR5161 STU7181 Mileage Break field Vienna Baltimore Springfield Baltimore Baltimore Rockville Alexandria Baltimore eld Alexandria Alexanidria Alexandria Springfield Alexandria Rockville YZA1222 ield Vienna Alexandria Vienna Rockville Baltimo Rackvill Which Driver drove max miles an 1st route? Vienna Alexandria Rockville Vienna Alexandria Rockville Alexandria Baltimore Vieriia Springticld Baltimorc Rockville Sprin field Rockville Vienna Rockvl Alexndria 2Springfield Rockville Alcxandria Springtield Alexandria Baltimore Number of Drivers who travel from Vienna to Baltimore OR from Boltimore to Vienna 14. Vienna 19 Baltimore YZA1222 LA1222 YZA1222 eld Rockville Alexandria