Jmcardle85go Jmcardle85go Computers and Technology Answered In the Long-Term Analysis sheet, using the formula rate = amount of increase/base, insert a formula in cell C6 that will calculate the percentage by which advertising spending increased from the year 2015 to 2016.