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 |