What does the exclamation point do in Excel formulas?
In an Excel formula, an exclamation point is used as a delimiter between a sheet name and a cell reference in that sheet. You use it when a formula in one sheet needs to reference a cell in a different sheet.Herein, what is the exclamation mark used for in Excel formulas?Excel allows you to refer to...