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

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When you copy a formula

Excel adjusts absolute cell references
Excel erases the original copy of the formula
Excel doesn’t adjust relative cell references
Excel edits cell references in the newly copied formula

ANSWER DOWNLOAD EXAMIANS APP