Glossary
3D 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 3D reference. A reference to the range Sheet1:Sheet5!A1:D4 is a 3D reference. Only certain Excel functions can make use of 3D 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 not change, ...
Get Business Analysis with Microsoft Excel, Third 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.
