MODULE 4 HOMEWORK ASSIGNMENT
(45 points)
As a travel agent you have collected information for your clients on various American cities for their
winter vacation plans including: the number of art museums, the average hotel costs per night,
roundtrip airfare from Columbus, and average temperatures in December since that is when they plan
to travel. You now need to summarize this information to determine which options meet each of your
client’s requirements.
Data given in the problem is shaded gray. You will be providing proper formulas or functions for the
remaining data in the unshaded cells by answering the following questions using cell references from
this worksheet. You will type your answers in this document. There is no Excel file provided for this
assignment. Note that once you have completed a question, you may use the results of that question in
subsequent problems. Remember to start all formulas or functions with an equal (=) sign and to always
use cell references and functions where possible. Only use a $ if necessary when copying formulas down
or across.
1. (0-5 pts) Write an excel formula or function in Cell F2, which can be copied down, to calculate the
cost of a week in the corresponding city. (Includes seven nights in a hotel and one roundtrip airfare.)
=C2*7+D2
Page 1 of 3
