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 live online training, plus books, videos, and digital content from nearly 200 publishers.