Just a few basic issues when I use formulas in Excel:

1. A $ sign sometimes appears in the cell even though the cells in the formula do not have $ signs.

2. How can you add a % sign?

3. How can you get rid of decimals?

Obviously you cannot just add or delete the above as cell results are automatic with formulas.


4. I am mostly using relative cell references (as you probably know, formulas adjust as they are copied), but want to copy a group of formulas and not have them adjust (absolute cell references). I looked this up and it said to select the reference you want to change in the formula bar and press F4, but I could not see where you select the reference. How do you do this or is there another way to do it?