which sing is used before cell co _ordinates to create a solute reference
Answers
i think ur question is wrong
Answer:
first i try this
Explanation:
Using Cell References in Formulas:
A cell reference identifies a cell or a group of cells in a workbook. When you include cell references in a formula, the formula is linked to the referenced cells. The resulting value of the formula is dependent on the values in the referenced cells and changes automatically when the values in the referenced cells change.
To see cell referencing at work, select cell A1 and type the formula =10*2. Now select cell A2, and type the formula =A1. The value in both cells is 20. If at any time you change the value in cell A1, the value in cell A2 changes also. Now select cell A3, and type =A1+A2. Excel returns the value 40. Cell references are especially helpful when you create complex formulas.
Entering Cell References with the Mouse:
You can save time and increase accuracy when you enter cell references in a formula by selecting them with the mouse. For example, to enter references to cells A9 and A10 in a formula in cell B10, do the following:
1 Select cell B10, and type an equal sign.
2 Click cell A9, and type a plus sign.
3 Click cell A10, and press Enter.
When you click each cell, a marquee surrounds the cell and a reference to the cell is inserted in cell B10. After you finish entering a formula, be sure to press Enter. If you do not press Enter and select another cell, Excel assumes that you want to include the cell reference in the formula.
The active cell does not have to be visible in the current window for you to enter a value in that cell. You can scroll through the worksheet without changing the active cell and click cells in remote areas of your worksheet, in other worksheets, or in other workbooks, as you build a formula. The formula bar displays the contents of the active cell, no matter which area of the worksheet is currently visible.
Tip: Redisplay the active cell.
If you scroll through your worksheet and the active cell is no longer visible, you can redisplay it by pressing Ctrl+Backspace.
Understanding Relative, Absolute, and Mixed References:
:
1 Select cell A1, and type =B1+B2 (but do not press Enter).
2 Press F4 to change the reference nearest to the flashing cursor to absolute. The formula becomes =B1+$B$2.
3 Press F4 again to change the reference to mixed (relative column coordinate and absolute row coordinate). The formula becomes =B1+B$2.
4 Press F4 again to reverse the mixed reference (absolute column coordinate and relative row coordinate). The formula becomes =B1+$B2.
5 Press F4 again to return to the original relative reference.
Creating References to Other Worksheets in the Same Workbook:
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 A9 in Sheet2 into cell B10 in Sheet1, do this:
1 Select cell B10 in Sheet1, and type an equal sign.
2 Click the Sheet2 tab.
3 Click cell A9, and then press Enter.
After you press Enter, Sheet1 is made active. Select cell B10, and you will see that it contains the formula =Sheet2!A9.
The worksheet portion of the reference is separated from the cell portion by an exclamation point. Note also that the cell reference is relative, which is the default when you select cells to create references to other worksheets.
Creating References to Worksheets in Other Workbooks:
You can refer to cells in worksheets in separate workbooks in the same way that you refer to cells in other worksheets within the same workbook. These references are called external references.
For example, to enter a reference to Book2 into Book1, follow these steps:
1 Create a new workbook�Book2�by clicking the New button on the Standard toolbar.
2 Choose Window, Arrange, Vertical.
3 Select cell A1 in Sheet1 of Book1, and type an equal sign.
4 Click anywhere in the Book2 window to make the workbook active.
5 Click the Sheet2 tab at the bottom of the Book2 window.
6 Click cell A2.
7 Press Enter to lock in the reference.
Understanding Row-Column Reference Style:
In R1C1 reference style, both rows and columns are numbered. The cell reference R1C1 means row 1, column 1; therefore, R1C1 and A1 refer to the same cell. Although R1C1 reference style isn�t widely used anymore, it was the standard in some spreadsheet programs, such as Multiplan. The normal reference style in Excel assigns letters to columns and numbers to rows, such as A1 or Z100. To turn on the R1C1 reference style, choose Tools, Options, click the General tab, and select the R1C1 Reference Style option. The cell references in all your formulas automatically change to R1C1 format. For example, cell M10 becomes R10C13, and cell IV65536, the last cell in your worksheet, becomes R65536C256. In R1C1 notation, relative cell references are displayed in terms of their relationship to the cell that contains the formula rather than by their actual coordinates. This can be helpful when you are more interested in the relative position of a cell than in its absolute position.