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

1. In MS Word, to underline a word :
1) Select the word; choose “Insert” and choose “Underline”.
2) Select the sentence; click on the button ‘U’ on the "Formatting" toolbar.
3) Select the word; right click on it and choose “Underline”.
4) Select the word; press alphabet ‘U’ on the keyboard.

2. In MS-Excel, "#NAME?" occurs in a cell when :
1) A # sign is typed instead of equal to(=) sign in the formula
2) A formula contains a number that is divided by 0 (zero).
3) The formula contains numbers and text (I.e. MS- Excel does not recognize the text in a formula.)
4) A number/formula is too large to fit in a cell

3. In MS-Excel, a Workbook is made up or 1 or more :
1) Workpages
2) Worksheets
3) Booksheets
4) Blankpages

4. In MS-Excel, a cell indicates the ###### sign when :
1) The cell contains number/formula is not accurate
2) The cell contains a number, date, or time that is wider than the cell width
3) The cell contains a number that has a negative value
4) The cell contains characters instead of numbers.



5. In MS-Excel, by default, pressing the enter key moves a cell pointer from:
1) Left to Right.
1) Bottom to Top.
2) Right to Left.
3) Top to Bottom.

6. In MS-Excel, for merging 2 cells :
1) Select cells; choose "Format"; choose "Merge"
2) Select the cells; on "Formatting" toolbar choose "Merge and centre" button (icon).
3) Select the cells; choose "Edit"; choose "Merge"
4) Select the cells; Right click on it; choose "Merge"

7. In MS-Excel, 'Goal Seek' tool allows you to adjust obtain a specific outcome by changing the value/values in ___________ cell/cells:
1) Two
2) Three
3) One
4) Four

8. In MS-Excel, how can we add a comment to a cell ?
1) Select the cells; choose "Insert"; choose "Comment"
2) Select the cells; choose "View"; choose "Comment"
3) Select the cells; choose "Edit"; choose "Comment".
4) Select "Insert"; choose "Comment in a cell".

9. In MS-Excel, how can we obtain a specific outcome for a cell by adjusting the value of only 1 other cell ?
1) Select "Tools"; choose "Solver"
2) Select "Tools"; choose "Auditing"
3) Select "Tools"; choose "Goal Seek"
4) Select "Insert"; choose "Seek Answer"

10. In MS-Excel, how can we provide $ sign (currency symbol) for a number which is in a cell :
1) Select the cell, on "Formatting" toolbar choose "$" button
2) Select "View"; choose "Currency"; choose "American"
3) Select "Data"; choose "Formula"; choose "$"
4) Select "Insert"; choose "Currency"; choose "American"


11. In MS-Excel, how can we make the format of cell B5 similar to the format of the cell E3 ?
1) Select E3; click on "Format Painter" button on Standard toolbar; click on B5
2) Select E3 and B5; click on "Format painter" on Standard toolbar
3) Select E3 and B5; choose "Format"; choose "Same Format"

Earning:   Approval pending.