Glossary
- 3-D reference
-
A reference to a range that spans more than one worksheet in a workbook. A reference to the range A1:D4 is not a 3-D reference. A reference to the range Sheet1:Sheet5!A1:D4 is a 3-D reference. Only certain Excel functions can make use of 3-D references: for example, =SUM(Sheet1:Sheet5!A1:D4) is legal, but =MMULT(Sheet1:Sheet5!A1:D4,F1:I4) is not.
- Absolute reference
-
Compare with relative reference and mixed reference. An absolute reference contains a dollar sign ($) before its row component and before its column component. $A$1 is an example of an absolute reference. If you enter =$A$1 in cell C1, and then copy the formula in C1 to cell D1, the formula in both C1 and D1 will be =$A$1. The reference is absolute, and will ...
Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
