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 use 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: Microsoft® Excel 2010 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.