Anatomy of fern fronds. The anatomy of a fern frond is relatively simple. They have a stalk which connects the base of the frond to the rest of the tree and runs along the entire length of the frond to the tip. The stalk can be separated into two parts: the stipe, which is the section of the stalk before any leafy part of the frond, and the rachis, the section with leafy tissue.
When entering a range of cell references as an argument for a function or when creating a chart, in addition to typing in the range manually, the range can also be selected using pointing. Ranges are identified by the cell references or addresses of the cells in the upper left and lower right corners of the range. These two references are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points.
Create a cell reference on the same worksheet. Click the cell in which you want to enter the formula. In the formula bar, type = (equal sign). Do one of the following: Cell reference To create a reference, select a cell or range of cells on the same worksheet.Cell references and the borders around the corresponding cells are color-coded to make it easier to work with them. 1.witch between relative, absolute, and mixed references. Select the cell that contains the formula. In the formula bar, select the reference that you want to change. Press F4 to switch between the reference types. For more information about the different type of cell references, see Overview of formulas.