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
Split command on the window menu
Hold titles command on the edit menu
Unfreeze panes command on the window menu

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To create a formula, you first:

Type the equals sign (=) to tell Excel that you’re about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Select the cell you want to place the formula into
Choose the new command from the file menu

ANSWER DOWNLOAD EXAMIANS APP