Creating Simple Formulas

When using formulas in Excel you can add, subtract, multiply, and divide. Use simple Excel formulas to also make cell references in Excel.

Challenge!

  1. Open an existing Excel 2010 workbook. If you want, you can use this example.
  2. Write a simple division formula. If you are using the example, write the formula in cell B18 to calculate the painting cost per square foot.
  3. Write a simple addition formula using cell references. If you are using the example, write the formula in cell F5 to calculate the total budget.
  4. Write a simple subtraction formula using the point-and-click method. If you are using the example, subtract the Expand Bathroom cost (C6) from the Total cost (C11). Calculate your answer in C12.
  5. Edit a formula using the formula bar.