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.
So the first red arrow is pointing to cell A2, and the second red arrow is point to cell A3. This is what was copied. If you want the correct answer in cell B3, you have to stop Excel from using this Relative Cell Referencing that it's currently doing. What you need is Absolute Cell Referencing. Absolute cell referencing involves nothing more than placing a dollar symbol ( $ ) before each letter and number.