(Q.33) The Delete key of keyboard is assigned to which command in Excel?
A. Edit >> Clear >> Contents
B. Edit >> Clear >> All
C. Edit >> Delete
D. All of above
(Q.34) 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
(Q.35) Which of the following will not cut information?
A. Pressing Ctrl + C
B. Selecting Edit>Cut from the menu
C. Clicking the Cut button on the standard
D. Pressing Ctrl+X
(Q.36) 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
(Q.37) Which of the following action removes a sheet from workbook?
A. Select the sheet, then choose Edit >> Delete Sheet
B. Select the sheet then choose Format >> Sheet >> Hide
C. Both of above
D. None of above
(Q.38) Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A. Square
B. Percentage
C. Goal Seek
D. Divide
(Q.39) How can you print three copies of a workbook?
A. Select File>Properties form the menu and type 3 in the Copies to print text box
B. Select File >Print from the menu and type 3 in the Number of copies text box
C. Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
D. Press Ctrl+P+3
(Q.40) To create a formula, you first:
A. Select the cell you want to place the formula into
B. Type the equals sign (=) to tell Excel that you’re about to enter a formula
C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula
D. Choose the new command from the file menu