4.(25 points) Write an Excel formula in Answers!E4that can be copied down, to determine the cost of the symbols used in the advertisement. Remember that the SYMBOLS worksheet has the prices for each of the symbols. You do not need to factor in the number of days the ad will run in this calculation.

5.(10 points) Write an Excel formula in Data!F14to determine the number of people who placed an ad withsymbols.

6.(15 points) Write an Excel formula in Answers!F4 that can be copied down and across to ANSWERS!G11, to determine the cost of bolding the title for each advertiser’s ad. When copied across this formula will calculate any additional costs for running the ad in color. Remember that not all advertisements request to have the title in bold… or the ad in color. You do not need to factor in the number of days the ad will run in this calculation.

7.(20 points) Write an Excel formula in Answers!H4that can be copied down, to determine the cost of an image which is measured in length only (remember that not all advertisements request an image). Images cost $2 per centimeter length per day (Refer to Unitsworksheet). You do not need to factor in the number of days the ad will run in this calculation.=Data!K5/Units!B$3*Units!B$4Page 3

CSE 2111 Midterm A8.(15 points) Write an Excel formula in Answers!I4 that can be copied down, to determine the total cost for the ad including the number of days the ad is to run.

9.(15 points) Write an Excel formula in Data!F15to determine if at least one pet and one personal ad havean image. You do not need to write this formula so that Excel determines which ads are personal and which are pet-related.