a Calculate the miles traveled for each route use the mileag

a Calculate the miles traveled for each route: use the mileage table to lookup pickup city and dropoffcity 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. Mileage Vienna ienna Baltimore Alexandria 83.2 35.2 22.4 27.2 70.4 43.2 83.2 35.2 22.4 27.2 Alexandria 70.4 43.2 Truck Driver IDRoute OrdePickup City Drop Off City Miles Traveled ABC1234 ABC1234 ABC1234 DEF5678 DEF5678 DEF5678 DEF5678 GHI9101 GHI9101 GHI9101 UKL 1121 JKL112 UKL 1121 JKL112 MNO3141 MINO3141 MNO3141 POR5161 POR5161 POR5161 STU7181 STU7181 STU7181 VW×9202 VW×9202 vWX9202 YZ4 12.22 YZA1222 YZ4 12.22 Truck Driver IDileage Brea ABC1234 DEF5678 GHI9101 JKL112 MNO314 OR5161 STU7181 SpringfieldVienna 22.4 Baltimore 83.2 Vienna Baltimore Rockville Ale andria Baltimore Springfield Alexandria Rockville Ale andria Alexandria Springfield Rockville Ale andria SpringfieldVienna Ale andria Vienna 43.2 43.2 22.4 35.2 ivizhiortrmawasm tta? 70.4 83.2 27.2 35.2 43.2 Baltimore Rockville Rockville Vienna himberfvVm iaBBWi; Ale andria Rockville Alexandria Springfield Baltimore Springfield Baltimore Rockville Vienna Springfield Rockville Vienna Rockville Ale andria Springfield Rockville Alexandria Springfield Ale andria Baltimore Springfield Rockville Rockville Ale andria Vienna 83.2 27.2 83.2 Baltimore 43.2

Solution

Solution a & b:

Solution c:

Frm miles table it is very clear that truck driver id YZA1222 driver maximum miles on their first route i.e. 88 miles.

Solution d:

Trip from Bakimore to Vienna and vienna to Bakimore:

Hence there are 4 truck drivers who travelled at this route.

Miles travelled for each route by truck driver
Truck Driver ID	Route Order	Pickup City	Drop off City	Miles Travelled
ABC1234	1	Springfield	Vienna	22.4
ABC1234	2	Bakimore	Springfield	96
ABC1234	3	Vienna	Bakimore	83.2
ABC1234	1	Bakimore	Rockvile	70.4
DEF5678	2	Alaxendria	Bakimore	88
DEF5678	3	Springfield	Alaxendria	16
DEF5678	4	Rockvile	Alaxendria	43.2
GHI9101	1	Alaxendria	Springfield	16
GHI9101	2	Rockvile	Alaxendria	43.2
GHI9101	3	Springfield	Vienna	22.4
JKL1121	1	Alaxendria	Vienna	35.2
JKL1121	2	Rockvile	Springfield	41.6
JKL1121	3	Bakimore	Rockvile	70.4
JKL1121	4	Vienna	Bakimore	83.2
MNO3141	1	Rockvile	Vienna	27.2
MNO3141	2	Vienna	Alaxendria	35.2
MNO3141	3	Alaxendria	Rockvile	43.2
PQR5161	1	Alaxendria	Springfield	16
PQR5161	2	Bakimore	Vienna	83.2
PQR5161	3	Springfield	Bakimore	96
STU7181	1	Rockvile	Vienna	27.2
STU7181	2	Springfield	Rockvile	41.6
STU7181	3	Vienna	Bakimore	83.2
VWX9202	1	Rockvile	Alaxendria	43.2
VWX9202	2	Springfield	Rockvile	41.6
VWX9202	3	Alaxendria	Springfield	16
YZA1222	1	Alaxendria	Bakimore	88
YZA1222	2	Springfield	Rockvile	41.6
YZA1222	3	Rockvile	Alaxendria	43.2