Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    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

| 51 52 53 54 55 56 57 58 59 60 61 |