Reference operators (such as the range operator : in Excel) are used to combine multiple cell ranges for calculations. For example, A1:A10 represents a range of cells. Comparison operators compare values, arithmetic operators perform calculations, and concatenation joins text.