For a more detailed description please refer to the Microsoft Excel Help.
| Name: |
A descriptive name that is used to represent a cell, range of cells, formula or fixed value, e.g. DiscountRates instead Discounts!A10:A30, InterestRate instead of 0.05. |
| |
| Array Formula: |
A formula that can perform multiple calculations and return either a single result or multiple results, e.g. {=B5:B15*C5:C15} |
| |
| 3D Formula: |
A formula that refers to a 3D Reference. Used with certain functions such as SUM, AVERAGE, COUNT etc. |
| |
| 3D Reference: |
A cell reference that spans consecutive worksheets within the same workbook, e.g. Sheet1:Sheet3!C7 |
| |
| Natural Language Formula: |
A formula that uses worksheet row and column labels in place of cell references and defined names, e.g. =Income-Expense, where Income and Expense are existing worksheet labels. |
