Editing Worksheet
1. When a range is selected, how can you activate the previous cell?
A.  Press the Alt key B.  Press Tab C.  Press Enter D.  None of above
2. What happens when you press Ctrl + X after selecting some cells in Excel?
A.  The cell content of selected cells disappear from cell and stored in clipboard B.  The cells selected are marked for cutting C.  The selected cells are deleted and the cells are shifted left D.  The selected cells are deleted and cells are shifted up
3. Which of the following option is not available in Paste Special dialog box?
A.  Add B.  Subtract C.  Divide D.  SQRT
4. Which command will you choose to convert a column of data into row?
A.  Cut and Paste B.  Paste Special > Transpose C.  Both of above D.  None of above
5. Which of the cell pointer indicates you that you can make selection?
A.  Doctor’s symbol (Big Plus) B.  Small thin plus icon C.  Mouse Pointer with anchor at the tip D.  None of above
6. Which of the cell pointer indicates that you can fill series?
A.  Doctor’s symbol (Big Plus) B.  Small thin plus icon C.  Mouse Pointer with anchor at the tip D.  None of above
7. Which of the cell pointer indicate that you can move the content to other cell?
A.  Doctor’s symbol (Big Plus) B.  Small thin plus icon C.  Mouse Pointer with anchor at the tip D.  None of above
8. 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 Paste Special, then click Transpose and OK C.  Copy the cells then go to 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 Paste Special, mark Transpose check box and click OK
9. 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
10. The shortcut 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