***** 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