Creating Complex Formulas

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

Challenge

  • Type the following information:

    In cell A1, type 12345.
    In cell A2, type 15865.
    In cell B1, type 9347.
    In cell B2, type 11942.
    In cell C1, type 19348.
    In cell C2, type 17103.
  • Create the following simple formula:

In cell A3, write a formula to add cell A1 and cell A2.

  • Fill the formula in cell A3 to both cell B3 and cell C3.
  • Create the following complex formula:

In cell A5, write a formula that divides cell A1 by the sum of cells A3, B3, and C3.

  • In the formula defined in cell A5, create an absolute reference to all cells and rows referenced in the following part of the formula: sum of cells A3, B3, and C3.
  • Copy the formula and absolute reference in cell A5 and paste it into cell B5 and cell C5.
  • Note how the formulas that appear in cell A5, cell B5, and cell C5 differ from one another.