Objective 4.1 - Practice Task 4-1 (Multiplication Table)

In this video you will learn,
1. absolute & relative cell in Microsoft Excel.
----------------------------------------------------------------------------
To insert a cell or range reference into a formula
1. In the cell or formula bar, position the cursor within the formula where you want
to insert the reference.
2. Use the reference procedure that corresponds to the type of reference you want
to insert.
To relatively reference the contents of a cell
➜ Enter the column letter followed by the row number, like this:
A1
To relatively reference the contents of a range of cells
➜ Enter the upper-left cell of the range and the lower-right cell of the range,
separated by a colon, like this:
A1:B3
➜ Drag to select the cell range and insert a relative reference to it.
To absolutely reference the contents of a cell
➜ Precede the column letter and row number by dollar signs, like this:
$A$1
➜ Enter the relative reference, click in or select the reference, and then press F4.
To absolutely reference the contents of a range of cells
➜ Enter the upper-left cell of the range and the lower-right cell of the range,
separated by a colon, and precede each column letter and row number by
dollar signs, like this:
$A$1:$B$3
➜ Enter the relative range reference, select the range, and then press F4