O'Reilly logo

Business Analysis: Microsoft by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required