Referencing Data in Excel 2016 for Mac To use the contents of a cell you must know how to reference that cell. Explore absolute and relative cell referencing and discover how to work with named data ranges formula auditing tools and formula error messages in Excel.