Languages
Back
Languages
Create a Formula with Cell References -- Excel Android App
> ... PathwayConnect Frequently Asked Questions > Assignment Help for PC 102 W03 Application Activity: Value of a Degree > Create a Formula with Cell References -- Excel Android App

  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 points to cell J6. Tap the = symbol in the number keyboard and tap on the cell you want to reference to begin the formula. Type an asterisk which symbolizes multiplication. The second callout points to the number 12, which represents 12 months of a year. Add another asterisk to the formula. The third callout points at the third reference which is in absolute reference form. You will know that it is an absolute reference when you see a dollar sign before the column and row 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 clicking the cell until a pop up menu appears, tap "Fill." The circles around the cell will turn into squares.
The first callout points to the formula that needs to be calculated. When you click enter and see the result of the formula, you will see a letter C in the "Check Your Work" table, which means that the answer is correct. Tap and hold the cell for a couple of seconds for a pop up menu to appear. Tap "Fill" so the circles around the cell will turn t squares. Tap, hold, and drag the bottom-right square to copy the formula down the range of cells that you will select.

  1. Click, hold, an drag the bottom 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.
You will see that the absolute cell reference did not change in the other cells, but the relative cell moved the same direction as the dragging.

Create a Table -- Excel Android App
Format Cells to Currency -- Excel Android App