Home > Computer Science> MS Excel

31 . MS Excel provides the default value for step in Fill Series dialog box
A. 0 B. 1
C. 5 D. 10

32 . When a row of data is to be converted into columns
A. Copy the cells in row, select the same number of cells in row and paste
B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

33 . Ctrl + D shortcut key in Excel will
A. Open the font dialog box
B. Apply double underline for the active cell
C. Fill down in the selection
D. None of above

34 . The short cut key Ctrl + R is used in Excel to
A. Right align the content of cell
B. Remove the cell contents of selected cells
C. Fill the selection with active cells to the right
D. None of above

35 . The command Edit >> Fill Across Worksheet is active only when
A. One sheet is selected
B. When many sheets are selected
C. When no sheet is selected
D. None of above