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

4) Select E3; right click "Copy" and then choose B5 right click "Paste"

12. In MS-Excel, how can we right align the text in a cell :
1) Select the cell; choose "Format"; choose "Align Right"
2) Select cell; choose "Align Right" button (icon) from the "Formatting" toolbar
3) Select the cell; choose "Edit"; choose "Align Right"
4) Select the cell; Right click, choose "Align Right" in the cell

13. In MS-Excel, how can we wrap the text in a cell ?
1) Select cell; increase the height of the row
2) Select cell; choose "Format cells"; choose "Alignment"; choose "wrap text"
3) Select cell; choose "Wrap" on formatting toolbar
4) Select cell; choose "Edit"; choose "Wrap"

14. In MS-Excel, how can you clear an entire data table, including all formulas, input values, resulting values, formats, and comments.
1) Select "Edit", choose "Clear".
2) Select "Edit", choose "Clear", click All.
3) Select "Edit", choose "Clear Table"
4) None of These.

15. In MS-Excel, how can you hide the columns?
1) Select the columns that you want to hide; choose "Window"; choose "Hide";
2) Select the columns that you want to hide; choose "View"; choose "Hide Column"
3) Select the columns that you want to hide; choose "Format"; choose "Column"; choose "Hide";
4) All of above

16. In MS-Excel, How can you view the true contents of the cell, if you see #### fault in a cell ?
1) Right click on the cell; choose "View".
2) Select the cell; press # key.
3) Double click the right boundary of the column heading.
4) Select "View"; choose "Actual Contents".


17. In MS-Excel, how will you hide window elements to show more data on the screen?
1) Select "View"; choose "Zoom".
2) Double click on the worksheet .
3) Select the entire worksheet; right click on it; choose "More Space".
4) Select "View"; choose "Full Screen".

18. In MS-Excel, if Cell C5 contains 500, C6 contains 200 and C7 contains 300 what formula will you provide to compute the sum :
1) = SUM(C5:C7)
2) =SUM(C5 to C7) =
3) SUM(C5&C6&C7)=
4) ADD(C5,C6,C7)

19. In MS-Excel, pressing the "Tab" key moves a cell pointer from:
1) Top to Bottom.
2) Left to Right.
3) Bottom to Top.
4) Right to Left.

20. In MS-Excel, the Formula provided in a cell starts with :
1) , (Comma)
2) : (Colon)
3) = (Equal to )
4) '(Apostrophe)

21. In MS-Excel, the short cut key to display the Office Assistant or Help is
1) Press F1 key
2) Press Ctrl+F1
3) Press Alt + F1

Earning:   Approval pending.