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

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To view a cell comment

Click the edit comment command on the insert menu
Position the mouse pointer over the cell
Click the display comment command on the window menu
Click the comment command on the view menu

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Where can you set the shading color for a range of cells in Excel?

Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Drawing toolbar
All of above
Choose required color on Fill Color tool in Formatting toolbar

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Double click the Format Painter and then press Esc key in keyboard
From Edit menu choose Delete
From Edit menu choose Clear and then Formats
Click on Remove Formatting tool on Standard Toolbar

ANSWER DOWNLOAD EXAMIANS APP