Your videos are excellent: short, sweet, and to the point.”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2010

Single page view print copy

Creating Simple Formulas

Challenge!

  1. Open an existing Excel 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.
1 2 3 4 5 6