S011
- Freeze Pane keeps the heading visible while you scrolling through the worksheet.
- The conditional formatting feature enables you to format a range of values so that the values outsides certain limits are automatically formatted.
- Formaulas use a variety of operators and worksheet functions to work with values and text.
- All cell references are relative references.
- When copied across multiple cells, they change based on the relative position of rows and columns.
- For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
- Relative references are especially convenient whenever you need to repeat the same calculation across multiple rows or columns.
Absolute references
- There may be times when you do not want a cell reference to change when filling cells.
- Absolute references do not change when copied or filled.
- You can use an absolute reference to keep a row and/or column constant.
- An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.
- If it precedes the column or row (but not both), it's known as a mixed reference.
- both the row or column reference is relative
- the other is absolute.
- only one of the address parts are abosolute
Comments
Post a Comment