The ! separates the worksheet name from the cell reference. The more general
form:
=[Book2]Sheet1!$A$1
The workbook name is inside the brackets, followed by the worksheet name,
the !, then the cell address.

"Tam" wrote:

I am copying formula which has an exclamation mark prefixing a cell reference
but I cannot determine what the operator calculates