Creating Complex Formulas

In Excel complex formulas can include several operations. Use complex formulas in Excel to calculate more extensive data.

Challenge!

  1. Open an existing Excel 2010 workbook. If you want, you can use this example.
  2. Create a formula that uses an absolute reference. If you are using the example, calculate the sales tax in E4:E20. Use cell C23 as your absolute reference to the price of sales tax.
  3. Create a formula that uses a relative reference. If you are using the example, create a formula that adds the price of each item in column D and the sales tax for each item in column E, then multiplies the result by the quantity of each item in column F. Enter your results in the totals column (column G). Hint: You'll need to think about the order of operations for this to work correctly.