Page 56 - 2611_SmartGPT Pro V(5.0) C-5

MIXED REFERENCES

A mixed reference is one that refers to a specific row or column. It is basically a combination
of relative and absolute references. In some situations, you may need to make the cell
reference as ‘Mixed’ reference so that you can lock either a column or a row by preceding
it with a dollar ($) symbol.

For example, $A1 or A$1.

REFERENCES TO OTHER WORKSHEETS

You can refer to cells in other worksheets within the same workbook just as easily as you

refer to cells in the same worksheet. For example, to enter a reference to cell A2 in Sheet2
into cell A1 in Sheet1, do this:

1 Select cell A1 in Sheet1, 3 Click on cell A2, and
and type an equal (=) sign. then press Enter key.

2 Click the
Sheet2 tab.

Select cell A1, and you will see that it
contains the formula = Sheet2! A2.

The exclamation point separates the worksheet portion of the reference from the cell

portion.

FUNCTIONS

Functions are predefined formulas in Excel to perform both simple and complex calculations.
They accept arguments and return values. Arguments are input to the functions.

54 Computer Science (V5.0)-V