1. (0-8 pts) Write an excel formula in Cell F2, which can be copied down to cell F9, to calculate the cost of a week in in the corresponding city. (Includes seven nights in a hotel and one roundtrip airfare.) (Hint: You do not need a function here – just a formula for the average hotel cost per night in column C for the city multiplied by 7, then add to it the roundtrip airfare in column D for the city.)

=(Avg Hotel $ Per Night *7) + Roundtrip Airfare =(_______________ * 7) + _________________

2. (0-8 pts) If a city has more than 10 Art Museums it is considered to have “good art”. Write an excel formula in cell G2, which can be copied down to cell G9, to determine (TRUE OR FALSE) if the corresponding city has “Good Art”. (Hint: You do not need a function here – just a formula for Number of Art Museums > 10 where number of art museums is a cell reference in column B for the city.)

=Number of Art Museums > 10 =____________>10

3. (0-8 pts) If a city has average temperatures between 50 and 80 (inclusive) it is considered to have good weather. Write an excel function in cell H2, which can be copied down the column to cell H9, to determine (TRUE OR FALSE) if the corresponding city has good weather. (Hint: Use the AND() function here and check the average temperature in December value in the E column for the city to see if it is both >=50 and <=80.)

=AND(Avg Temp >= 50, Avg Temp <= 80) =AND(_________>=50, ____________ <=80) 4. (0-8 pts) Your client Kim considers any destination that has either good art or good weather to be acceptable. Write a function in cell I2, which can be copied down the column to cell I9, to determine (TRUE OR FALSE) if the corresponding city is acceptable to Kim. (Hint: Use the OR() function here and column G for good art, and column H for good weather.)

=OR(Good Art, Good Weather) =OR(__________, ____________)

5. (0-8 pts) Your client Nat only wants to go to the destination with the cheapest price. Write a formula in cell J2, which can be copied down the column to cell J9, to determine (TRUE OR FALSE) if the corresponding city is acceptable to Nat. (Hint: Use the MIN() function to find the cheapest of all cities and check for equality against the weekly cost per person for each location.)

=Boston per Person = Minimum Price per person of all cities =________=MIN(_______)