click below
click below
Normal Size Small Size show me how
unit B
Excel vocabulary
| Term | Definition |
|---|---|
| complex formula | uses more than one arithmetic operator. |
| order of precedence | rules to determine which operation to perform first |
| Auto fill | Dragging the fill handle on a cell copies the cell contents or continues a series of data into adjacent |
| functions | predefined worksheet formulas that enable you to perform complex calculations easily |
| relative cell reference | 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. |
| absolute cell reference | which is a reference that does not change when you copy the formua |