no just 1
Personally, no. But it's not incorrect to put the apostrophe.
When you absolute reference in Microsoft excel it means that you always want it to reference that cell within the formula. To absolute reference, put $ before the letter and the number.
before, (like this).
You were expecting your period and you got IT before IT got you!
After the parenthesis.
you are not suppose to place any spacing after nor before the dollor sign$
Yes, you would still put a period at the end of the sentence even if it includes a parenthetical reference. The period indicates the end of the sentence's main thought, and the parenthetical reference is additional information for the reader's benefit.
no, capitalize the letter and put a period after it.
You would put a dollar before the B and before the 9, like this: $B$9 It can be done by pressing the F4 key, while entering the reference.
If you mean have it so that if the formula is copied, that the cell reference won't change, then you use an absolute reference. To do that put a dollar before the column reference and one before the row reference. As an example A3 would be $A$3 when locked. A quick way as you type the cell reference is to press the F4 key to change the reference type.
People put their fingers on these keys on the keyboard. They use this position to type without looking at the keyboard. It is called touch-typing. Reference: wikipedia.com/wiki/asdfjkl;