When building an Excel reference to a single cell or range of cells, which of these describes the purpose and effects of the exclamation point $!$

$($select all that apply, omit those that do not$)$

Question $16$ options:

a$)$

Declares a value to be a text string without using quotes.

b$)$

Allows a formula or function to reference a cell on a different worksheet.

c$)$

Identifies a cell reference as an Absolute reference.

d$)$

Is a shortcut method to force characters to upper case.

e$)$

Seperate name of worksheet from cell range.