Home » Computer » MS Excel MCQ » MS Excel Quiz MCQ Questions and Answers – (Set-5)

MS Excel Quiz MCQ Questions and Answers – (Set-5)

(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

A. Edit >> Clear >> Contents

Discuss Answer


(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

B. When many sheets are selected

Discuss Answer


(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

A. Pressing Ctrl + C

Discuss Answer


(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

D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

Discuss Answer


(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

A. Select the sheet, then choose Edit >> Delete Sheet

Discuss Answer


(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

D. Divide

Discuss Answer


(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

B. Select File >Print from the menu and type 3 in the Number of copies text box

Discuss Answer


(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

A. Select the cell you want to place the formula into

Discuss Answer


Parts of MS Excel MCQ Questions & Answer:

Leave a Reply

Your email address will not be published. Required fields are marked *

Solve : *
9 + 22 =