MS Excel
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
Unfreeze panes command on the window menu

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

Concatenate and manipulate text
Return ASCII values of characters
Show formula error value
Replace cell references

ANSWER DOWNLOAD EXAMIANS APP