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

30. In MS-Excel, to copy the formula from 1 cell into a range of adjacent cells :
1) Select cell with formula; drag the "Fill handle" over the range you want to copy
2) Select "Edit"; choose "Move Formula"
3) Select cell with formula; drag it over the range you want to fill the Formula
4) Select cell with formula; drag it when the arrow sign comes

31. In MS-Excel, to reduce decimal places :
1) Select "Edit"; choose "Decrease Decimal"
2) On "Formatting" toolbar: choose "Decrease Decimal" button (icon)
3) Select "Data"; choose "Decimal"; choose "Decrease Decimal"
4) Select "Format"; choose "Decrease Decimal"

32. In MS-Excel, to delete a worksheet from the workbook:
1) Select "Format", choose "sheet", choose "remove"
2) Select the whole worksheet; press delete
3) Select "Edit"; choose "Delete Sheet"
4) Select "Data"; choose "Delete Worksheet"

33. In MS-Excel, to provide a manual page break :
1) Select "Edit"; choose "Page Break".
2) Select "Insert"; choose "Page Break".
3) Select "Format"; choose "Page"; choose "Break".
4) Select "Data"; choose "Page Break"

34. In MS-Excel, to insert a pie chart in a Worksheet :
1) Select the data; right click on it; choose "Format Cells" click on Pie choice
2) Select the data; choose "Chart Wizard" button (icon) on "Standard" toolbar; Click on the "Standard type" tab, choose "Pie" choice from the "chart type"
3) Select the data; choose "View"; click on "Pie Chart"; choose the needed chart.
4) Select the whole sheet; choose "Insert"; click on "Pie Chart"; choose the needed chart.


35. In MS-Excel, to insert a series of months starting from January and ending with December :
1) Type "Calender" in any cell; press Ctrl + Enter
2) Type 'January' in any cell; drag the Fill handle till 'December' appears
3) Type 'January' in any cell; click on text and drag till 'December' appears
4) Select "Insert"; choose "Calender"

36. In MS-Excel, to insert a series of numbers starting from one and ending with 100 :
1) Type one in a cell; choose cell; drag the "Fill handle" while pressing CTRL button till 100 appears
2) Type one in a cell; choose the cell; drag the "Fill handle" while pressing ALT button till 100 appears
3) Type "=(1:100)" in a cell
4) Type "=(1 to 100) in a cell

37. In MS-Excel, to insert a series of week days starting from Monday and ending with Friday :
1) Type 'Monday' word in any cell; drag the fill handle till 'Friday' appears
2) Type "=Monday + Friday" in any cell
3) Type "=(Monday:Friday)" in a cell

Earning:   Approval pending.