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

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

(Q.17) The name box

A. Shows the location of the previously active cell
B. Appears to the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar

B. Appears to the left of the formula bar

Discuss Answer


(Q.18) To remove the content of selected cells you must issue __ command

A. Edit >> Delete
B. Edit >> Clear >> Contents
C. Edit >> Clear >> All
D. Data >> Delete

B. Edit >> Clear >> Contents

Discuss Answer


(Q.19) Comments put in cells are called

A. Smart tip
B. Cell tip
C. Web tip
D. Soft tip

B. Cell tip

Discuss Answer


(Q.20) MS Excel provides the default value for step in Fill Series dialog box

A. 0
B. 1
C. 5
D. 10


(Q.21) Which of the following is not a basic step in creating a worksheet?

A. Save workbook
B. Modifiy the worksheet
C. Enter text and data
D. Copy the worksheet

D. Copy the worksheet

Discuss Answer


(Q.22) How do you select an entire column?

A. Select Edit > Select > Column from the menu
B. Click the column heading letter
C. Hold down the shift key as you click anywhere in the column
D. Hold down the Ctrl key as you click anywhere in the column

B. Click the column heading letter

Discuss Answer


(Q.23) What is the short cut key to replace a data with another in sheet?

A. Ctrl + R
B. Ctrl + Shift + R
C. Ctrl + H
D. Ctrl + F

C. Ctrl + H

Discuss Answer


(Q.24) Which of the following you can paste selectively using Paste Special command?

A. Validation
B. Formats
C. Formulas
D. All of above

D. All of above

Discuss Answer


Parts of MS Excel MCQ Questions & Answer:

Take Part in Discussion:

Your email address will not be published.

Solve : *
2 × 18 =