A1 A x fx A B D E F G H L M N o 0 1 2 Instructions 1. In cell B10, add the numbers above (B5-B9) using the correct formula, round answer to nearest whole number 2. In cell D10, Show the "count" of all the non- blank, non-number cells above it (D5 - 09). 3. Fill in Cells G10 - G12 with the answer to the instruction to its left. Only use a formla to answer, referencing the entire range. 4. In Cell 110 Write today's date using a formula. If you've forgotten how to do this, use the Excel help menu to find the formula Apple 22 69 341 -312 14 0.55553 Monday 235 778 33.55 19000 40 30 3 4 4 5 6 6 7 8 9 10 11 12 13 14 15 16 17 18 Max: Min: Average: 5. In Cells C21 and D21, reference the Sales figures for 2014 and 2015, respectively, from Exercise 1 6. Put formulas into the green cells below to forecast the next three years of Sales, assuming an 8% growth per year off of the previous year. a. You should reference cell H21 for your growth rate b. Remember that you can do this by adding "1" to your growth rate before multiplying c. You should get the correct formula into cell 124 first, using an appropriate "absolute reference" (with $ signs around the column and row) for your "fixed cell, and a "relative reference" (no $ signs) for your other argument. For those new to this, try doing the formula first, referencing cells you need to, not worrying about the $ signs, and then put them in afterwards. d. You should be able to copy the formula from 124 into J24 and K24, and then double-check that it makes sense. 2014 2015 Sales: Growth Rate: 2017 2018 2019 Sales: 2016 10,000 19 20 21 22 23 24 25 26 27 28 29 30 31 Exercise 1 Exercise 2 +