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

4) Press F2 key

22. In MS-Excel, the workbook created has the default extension of
1) xls file extension.
2) . bmp file extension.
3) . prj file extension.
4) . exe file extension.

23. In MS-Excel, to add a header and a footer to the worksheet :
1) Type "Header" in the 1st cell of the Worksheet and "Footer"in the last cell of the Worksheet.
2) Click the "Header and Footer" icon on the "Drawing” toolbar.
3) Select the Worksheet; Right click on it; click on "Header and Footer".
4) Select “View"; choose "Header and Footer". Specify a header or footer that you want.

24. In MS-Excel, to add a particular toolbar in the worksheet :
1) Select "Tools"; choose "Add Toolbar"
2) Select "Insert"; choose "Toolbars"; choose the necessary toolbar
3) Right click on worksheet; choose "Insert toolbar"
4) Select "View"; choose "Toolbars"; choose the necessary toolbar

25. In MS-Excel, to change the font of the text in a cell :
1) Select a cell; choose "Format"; choose "Change Font".
2) Select a cell; right click on it; choose "Font" .
3) Select a cell; on the "Formatting" toolbar click on the drop down list of the "Font" button ; and choose the font that you want.
4) On menu bar; choose "Format"; choose "Font"; choose the font that you want.

26. In MS-Excel, to change the text in cell to Bold :
1) Select cell; on "Formatting" toolbar choose button marked as 'B'
2) Select cell; choose "Edit"; choose "Bold"
3) Select cell; choose "Format"; choose "Bold"
4) Select cell; choose "Bold" on the "Standard" toolbar

27. In MS-Excel, to change the width of a particular column :
1) Select any cell in column; right click on it; choose "Change Width"
2) Drag the boundary on the right side of the column heading until the column is of the needed width..
3) Select "View"; choose "Column Width"
4) Select "Edit"; choose "Width"

28. In MS-Excel, to Check the Spelling of the entire Worksheet :
1) Select Worksheet; Right click on it; choose "Spell-check".
2) Click the "Spelling" button (icon) on standard toolbar.
3) Select Worksheet; choose "Data"; choose "Spell- Check".
4) Select "Format"; choose "Auto Check".

29. MS-Excel, to copy a charts formats to a different chart :
1) Select chart; copy it; choose other chart; choose "Paste"
2) Select chart; copy it; choose other chart ; choose "Edit"; choose "Paste Special"
3) Select chart; right click on it; choose "Move Format"
4) Select both the charts; choose "Edit"; choose "Copy Formats"

Earning:   Approval pending.