# The order of dataa5a12 will always be the same as the

• Test Prep
• 5
• 100% (17) 17 out of 17 people found this document helpful

This preview shows page 2 - 4 out of 5 pages.

***** The order of Data!A5:A12will always be the same as the order of Answers!A4:A11*****The Symbols worksheet describes the symbol types available, what each looks like, and the price for each symbol. When determining the amount of space an ad will require, symbols should be added into the word count. For example if an ad has a total of 45 words and 1 symbol, the total “word” count would be 46.The first row of the Fonts worksheet designates the font sizes available. Associated with each font size are the words per line that typically fit for the specified range of font sizes. That is, font sizes from 8 to less than 10 will typically fit 15 words per line. Font sizes from 10 to less than 14 will fit 12 words per line, etc. The range Fonts!B1:F2has been named FontsThe Units worksheet includes data you may need for problem solving including the base cost for anad, the cost per line for an ad and the cost to include an image which is based on the length in centimeters. These costs represent the costs to run the ad for one day only. The number of days anad will run is given in the Dataworksheet (column C).1.(15 points) Write an Excel formula in Answers!B4.
2.(15 points) Write an Excel formula in Answers!C4which can be copied down, to determine the number of lines needed for the first advertisement listed. Remember that symbols are considered “words” when Page 2
CSE 2111 Midterm Ataking into account the number of lines needed. Write your answer so that the result is rounded to the nearest whole number.
3.(20 points) Write an Excel formula in Answers!D4that can be copied down, to determine the total cost of all the words using the following guidelines:if the font is less than or equal to 8, only 75% of the cost/line is charged per lineif the font is greater than or equal to 14, 150% of the cost/line is charged per lineotherwise, use the original value for cost/line
• • • 