To hold row and column titles in place so that they do not scroll when you scrol
Home | Discussion ForumFree Online Test
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
Hold titles command on the edit menu
Split command on the window menu
Answer : B
Free Online Test
View More Related Question
1) By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
View Answer
2) Which button do you click to add up a series of numbers?
3) Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
View Answer
4) Which of the following is not a valid data type in Excel?
5) Which shortcut can be used to Switch between open workbooks ?
