5:05 Flight No. Type Start City Destination Departure Time Travel Time 1 Boeing

Question

5:05

Flight No. Type Start City Destination Departure Time Travel Time 1 Boeing 737 Orlando Los Angeles 12:15 7:15 2 Boeing 747 Chicago Dallas 17:25 5:20 3 Boeing 737 New York Las Vegas 14:00 8:40 4 MD 180 San Jose Seattle 6:35 1:50 5 MD 200 San Francisco Sacramento 9:50 3:45 6 Boeing 737 New York Detroit 11:25 2:00 7 Boeing 737 Tampa Chicago 13:30

5:05

ing for a particular cu b. If the customer's birth date is pres d. The e. No another new column in the table that displays birthday coupon should be sent to a customer display the word "SEND" to indicate that the the month of the customer's birthday c. Create a final column to indicate whether a this month. If the month of the customer's birthday is the same as the current month, 21. A tabl charg of mo coupon should be sent. If the birth month is in th borr not the same as the current month, display the phrase "DO NOT SEND. 18. An airline uses a spreadsheet to track informa- tion about each of its scheduled flights. (Refer to year will 22. Usi worksheet "4.18) a. After its flight from Orlando to Los Angeles, the Boeing 737 requires maintenance and is unable to fly as scheduled. A Boeing 727 will fly in its place. Use an Excel function at each instance after the Orlando to Los Ange- les flight to substitute every instance of the phrase "Boeing 737" with the phrase "Boeing for 727. b. Due to a snowstorm, all flights out of Chicago have been cancelled. Using the VLOOKUP function, return the flight number of all the b.

Explanation / Answer

[1] In cell G2, Use this formula : =IF(EXACT(B2, "Boeing 737"), "Boeing 727", B2)

[2] In any cell below A8 using this formula : =VLOOKUP("Chicago", A2:F8, 1)

[3] In cell H2, Use this formula : =(MINUTE(E2) + MINUTE(F2))%60

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.