Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Published by CQ Press, an Imprint of SAGE Publications, Inc. www.cqresearcher.com Future of Cars Are Americans ready for self-driving vehicles? C ars that drive themselves, long a staple of science...

Need help with this excel assignment please. Please note that you will be allowed to submit this assignment 3 times into MyITLab. It will record the highest score of your 3 attempts. I realize that...

Greetings I am presently stuck on Chapter 5 level 3-Creating a Cost Estimate Form for CKG Auto of the textbook Succeeding in Business with Microsoft Excel 2013. Please provide me Step by Step...

Hello I am presently stuck on Chapter 5 level 3-Creating a Cost Estimate Form for CKG Auto of the textbook Succeeding in Business with Microsoft Excel 2013. Please provide me Step by Step Solution...

23 Nickel and Dimed: On (Not) Getting By in America BARBARA EHRENREICH Major changes in welfare legislation in 1996 eliminated cash payments to millions of America's poor, requiring them to find...

this is my advanced operation and supply chain management course please give me answer with excel and theory and please do not send the answer which is already on chegg Instructions Read the case...

Please write the selecting tools and approaches (according to the subject R esearch Method ) for this topic SECOND LANGUAGE ACQUISITION: LEVEL OF INTEREST IN LEARNING MANDARIN CHINESE LANGUAGE AS A...

Rather than demonstrating your ability to recall or search for course data, you will be applying the concepts and principles covered throughout the course in a case study analysis. We will be...

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

THIRD AVENUE SOFTWARE HEALTH-CARE APP PROJECT This case is new for the ninth edition of Information Technology Project Management . The case provides an opportunity to apply agile and Scrum...

Krazy Kars Pty Ltd (Krazy Kars) equips and sells customised off-road vehicles to operators in the tourist industry. The directors are Carlos, Possum and Michele. According to its constitution,...

As a functional employee, you demonstrate that you have exceptionally good writing skills. You are then promoted to the position of special staff assistant to the division manager and told that you...

The type of merger that are most likely to reduce competition is a a . diversification merger. b . horizontal merger. c . vertical merger. d . merger between firms of the same size. e . merger...

q , is an external inducement of an emotional nature that is designed to increase an individuals drive to undertake an action. Emotional response Social proof Determined appeal Guilt Motivational...

3.46 A conference began at noon with two parallel sessions. The session on portfolio management was attended by 40% of the delegates, while the session on chartism was attended by 50%. The evening...

3.43 In Sipadan, Malaysia, there is a national park where up to 100 dolphins can be found. Suppose we randomly select two of them in one draw. a. What is the probability that we pick two females,...

3.44 An analyst is presented with lists of 4 stocks and 5 bonds. He is asked to predict, in order, the 2 stocks that will yield the highest return over the next year and the 2 bonds that will have...