Maharashtra State Board of Technical Education 2009 Certification MS-CIT Bank Set 8 - Question Paper

1. In MS-Excel, to Sort rows in ascending order based on the contents of 1 column
1) Select the cells; at the starting cell of selection kind 'Sort Ascending'
2) Select the cells; On the "Standard" toolbar; click on "Sort Ascending" button.
3) Select the cells; choose "Edit"; choose "Sort Ascending"
4) Select the cells; right click on it; choose "Sort Ascending"

2. In MS-Excel, to split the spread sheet :
1) Select "Window"; choose "Split".
2) Select "Format"; choose "Split".
3) Select the entire sheet; right click on it; choose "Split".
4) Type 'Split Spread Sheet' in any 1 cell of Spread Sheet.

3. In MS-Excel, What would you do to Indent text from the left edge of a cell (increase indent)?
1) Select "Edit"; choose "Increase Indent"
2) Select "Data"; choose "Increase Indent"
3) On the "Formatting" toolbar; click on "Increase Indent" button (icon)
4) Right click on cell; choose "Increase Indent"

4. In MS-Excel, when a cell is deleted the other cells move :
1) Up or Down
2) Left or Down
3) Right or Up
4) Up or Left

5. In MS-Excel, which function would you use to insert the Current Date without time ?
1) =SYSDATE()
2) =TODAY()
3) =TODAY(DATE)
4) =DATE

6. In MS-Excel, which of the subsequent will not be accepted as a valid date ?
1) May 24, 2000.
2) 24-May-2000.
3) May 24th, 2000.
4) 5/24/2000.


7. In MS-Excel, which of the subsequent is a method to move the worksheet in the identical workbook :
1) Select "File"; choose "Move"
2) Right click anywhere on the current worksheet; choose "Move Worksheet"
3) Move the mouse pointer from left to right
4) Place mouse pointer on the sheet tab; right click the mouse and choose "move or copy" choice from the menu that appears

8. In MS-Excel, which of the subsequent is not a chart kind
1) A Bar Chart
2) A Column Chart
3) A Row Chart
4) A Doughtnut Chart

9. In MS-Excel, which 1 of the subsequent is a method used to close the file without quitting out of Excel :
1) Click on "Close" button on Microsoft Excel Window's title bar.
2) Select " File"; choose "Exit".
3) Select "File"; choose "Close"
4) Press Alt + F4.

10. In MS-Excel, which 1 of the subsequent is not a method used to quit out of Excel :
1) Click on "Close" button on Microsoft Excel Window's title bar.
2) Select " File"; choose "Exit".
3) Select "File"; choose "Close"
4) Press Alt + F4.

11. In MS-Excel, which 1 of the subsequent is not a method used to save a Workbook?
1) Select "File"; choose "Save".
2) Select "Save" button (icon) on standard toolbar.
3) Select "Edit"; choose "Save".
4) Press Ctrl+S

12. In MS-Excel, which 1 of the subsequent statements about the cell pointer is not option1?
1) Indicates the active cell in the worksheet.
2) Moves when you move the mouse on your desk.
3) Moves when you click a new cell with the mouse.

Earning:   Approval pending.