Simple Formulas

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 (-).