Simple Formulas

You can use formulas in Excel and other spreadsheet programs to add, subtract, multiply, and divide. Use simple Excel formulas to also make cell references.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Create a simple addition formula using cell references. If you are using the example, create the formula in cell B4 to calculate the total budget.
  3. Try modifying the value of a cell referenced in a formula. If you are using the example, change the value of cell B2 to $2,000. Notice how the formula in cell B4 recalculates the total.
  4. Try using the point-and-click method to create a formula. If you are using the example, create a formula in cell G5 that multiplies the cost of napkins by the quantity needed to calculate the total cost.
  5. Edit a formula using the formula bar. If you are using the example, edit the formula in cell B9 to change the division sign (/) to a minus sign (-).