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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To create a formula, you can use:

Values or cell references although not both at the same time
Values but not cell references
Cell references but not values
Value and cell references

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you insert a row?

Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
All of the listed here

ANSWER DOWNLOAD EXAMIANS APP