Page 100 - Excle-En-V3

By using the autofill feature, drag the fill handle to execute the formula for the
rest of the individuals to determine their salaries.

Figure 138: Calculate Function Using Absolute Reference

Note that the formula in each cell to calculate the salary used the same fixed
value without changing during the autofill operation. The result would be incorrect
if cell D2 in the formula is not defined as an absolute reference.
19.2 - Range in equations:

A range is a group of adjacent cells. The first cell is written, then two
dots on top of each other, then the last cell. For example, cells from A2 to
C5 are written (A2:C5). This means that this range includes 12 cells, as the
number The columns represented by letters are three letters or three
columns, and the number of rows represented by numbers is four numbers
or rows, from which we multiply 3×4 to produce 12 cells.

However, if a semicolon or comma is placed between the cells, this does
not mean a range, but rather they are individual cells, for example (A2;C5)
are only two cells. That is, (:) means "to", while (;) means "and".

92 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024