Languages
Back
Languages
Create a Formula with Cell References - Excel on a Computer
> ... PathwayConnect Frequently Asked Questions > Assignment Help for PC 102 W03 Application Activity: Value of a Degree > Create a Formula with Cell References - Excel on a Computer
  1. Double-click on the cell where you want to add a cell reference. In this case, we double-click on cell J6. Type the = symbol then click on the cell you want to reference. In this case, we click on cell H6. This begins the formula.
  2. Type an asterisk * to multiply by twelve (12 represents 12 months of a year).
  3. Add another * and click on the cell D6 that shows current monthly earnings.
  4. To make it an absolute reference add $ before the letter and the number of the cell: $D$6.
The first callout is pointing at the = symbol that started the formula and the first cell reference. The second callout is pointed at the * symbol, which means multiplication, that followed the first reference, and the number 12. Another * followed the number 12, and cell D6 is the last to be referenced in the formula. You will notice that the last cell reference has a dollar sign before the column and row. This is an absolute reference. The entire formula looks like this: =H6*12*$D$6.

  1. Click enter for the formula to be calculated.
  2. You will see a C in the "Check Your Work" table if the formula is correct.
  3. Copy the formula down by pointing the cursor to the lower right side of the cell until a black cross sign shows up.
The first callout points to cell J6 where the result of the formula you made in the previous image can be seen. The second callout is pointed to cell O6, where you can see a letter C which signifies that the result of the formula that you created is correct. The third callout is pointing at the cross sign located at the bottom-right corner of cell J6. If you point your cursor to that corner, you have to wait a couple of seconds for the cursor to turn to a black cross sign.

  1. Click, hold, an drag that square to apply the formula to cells J7 to J10.
  2. Because you used an absolute reference and a relative reference in cell J6, when you applied the formula to cells J7 to J10 by dragging it, the absolute reference remained fixed, while the relative references moved in the same direction as the dragging. You can check that by double-clicking on cell J10.
The first callout is pointing at cell J6. An arrow can be seen pointing downwards from cell J6. This shows that you have to click the cross sign and drag it to apply the formula to cells J7 to J10. The second callout is pointing at the formula in cell J10. You will notice that the relative cell reference changes or moved on the same direction as the dragging, but the absolute cell reference remained fixed.

Create a Table - Excel on a Computer
Format Cells to Currency - Excel on a Computer