Question: Depending on the city, you will either take a shuttle to/from the airport or rent a car. Your next task is to enter the cost

Depending on the city, you will either take a shuttle to/from the airport or rent a car. Your next task is to enter the cost of the shuttle or rental car in the dataset using a logical function. Click cell E14. Insert an IF function that compares to see if Yes or No is located in the Rental Car? column for a city. If the cell contains No, display the shuttle value in cell F2. If the cell contains Yes, display the value in the Rental Car Total (cell F4). Copy the function from cell E14. Use the Paste Formulas option to copy the function to the range E15:E19 without removing the border in cell E19.

EXP_22_INTROASSESSMENT_TRAVEL

Depending on the city, you will either take a shuttle to/from

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!

DC worksheet place worksheet cities worksheet 42 14 42 On the Places worksheet, sort the data by City in alphabetical order and then within City, sort by Sightseeing Locations in alphabetical order....

Exp19_Excel_AppCapstone_Intro Assessment_Travel Project Description: You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston....

Assignment Instructions Step Instructions Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx On the DC worksheet, select the range A4:G4, wrap the text, apply Center...

10 Cut the chart and paste it in cell A13. Change the chart height to 6" and the chart width to 7". Add Alt Text The bar chart shows the number of visitors to each memorial for the years 2002, 2007,...

Poi Step Change the chart title to Annual Visitors. Apply Blue Accent 5, Darker 25% font color to the chart title and category axdis labels. Change the value axis display units to Milions. Apply data...

Tahoma l U.shg , . ||| Quick Change Editing 2 Paragraplh Styles Styles" Font Stylesr 2 Click the Places sheet tab, convert the data to a table, and apply Table Style Medun 6. by Sightseeing Locations...

need help with these last few questions please Depending on the city, you will either take a shuttle to/from the airport or rent a car. Your next task is to enter the cost of the shuttle or rental...

Exp19_Excel_AppCapstone_Intro Assessment_Travel Project Description: You are considering several cities for a vacation. In particular. you are interested in Washington DC, Philadelphia, and Boston....

13 On the Places worksheet, sort the data by City in alphabetical order and then within City, sort by Sightseeing Locations in alphabetical order. 14 On the Places worksheet, add a total row to...

I NEED TO SEE THE PROCESS OF THESE QUESTIONS. Start Excel. Download and open the file named Exp19_Excel_AppCapstone_IntroAssessment_ Travel.xlsx. Grader has automatically added your last name to the...

Q6. Assume the op amp is ideal. (a) Find an expression for the output voltage Vo in terms of the input voltage Vin. (b) For what range of Vin is this Vo expression valid? 200 2 400 2 400 2 +15 V 200...

Tom Belford and Tony Sorrentino own a small business devoted to kitchen and bath granite installations. Recently, building contractors have insisted on up-front bid prices for a house rather than the...

answer this 8. What is 0,5 Promille? 9. How do you know who has the right of way on a German street (Vorfahrt)? D. Einkaufen gehen. 1. Most people in Germany prefer to shop in individual stores...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...