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

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

(Q.25) How do you insert a row?

A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
B. Select the row heading where you want to insert the new row and select Edit >Row from the menu
C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
D. All of the above

A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

Discuss Answer


(Q.26) Which of the following methods cannot be used to enter data in a cell

A. Pressing an arrow key
B. Pressing the Tab key
C. Pressing the Esc key
D. Clicking on the formula bar

C. Pressing the Esc key

Discuss Answer


(Q.27) To center worksheet titles across a range of cells, you must

A. Select the cells containing the title text plus the range over which the title text is to be centered
B. Widen the columns
C. Select the cells containing the title text plus the range over which the title text is to be enfettered
D. Format the cells with the comma style

A. Select the cells containing the title text plus the range over which the title text is to be centered

Discuss Answer


(Q.28) You can move a sheet from one workbook into new book by

A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
B. From Edit menu choose Move of Copy then choose (Move to end) and click OK
C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D. None of above

C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Discuss Answer


(Q.29) Multiple calculations can be made in a single formula using

A. standard formulas
B. array formula
C. complex formulas
D. smart formula

B. array formula

Discuss Answer


(Q.30) Which of the following is not true about Find and Replace in Excel

A. You can search for bold and replace with italics
B. You can decide whether to look for the whole word or not
C. You can search in formula too
D. You can search by rows or columns or sheets

D. You can search by rows or columns or sheets

Discuss Answer


(Q.31) 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

C. Fill down in the selection

Discuss Answer


(Q.32) 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

C. Fill the selection with active cells to the right

Discuss Answer


Parts of MS Excel MCQ Questions & Answer:

Take Part in Discussion:

Your email address will not be published.

Solve : *
7 × 11 =