What do these characters mean?
 

Ok, I get the following cell formula when I paste a link to a cell in another
tab. It looks like this:

='Example Tab'!$L$8

What I'd like to know is what the exclamation point and dollar signs mean.
Why can't Excel just do something like this instead?

='Example Tab'L8

Can anyone help?