MCQ Sets

Microsoft Excel Multiple Choice Quiz Set 03

by 2 Comments

These are probably the best MCQ questions composed from Microsoft Excel. Each question is hand picked and presented very carefully. Every attempt is made to ensure that the quiz is free from errors and mistakes.

Enjoy Excel MCQ Quiz 03!

Microsoft Excel MCQ Quiz 03

1. Merge cells option can be applied from
 
 
 
 
2. What function displays row data in a column or column data in a row?
 
 
 
 
3. To drag a selected range of data to another worksheet in the same workbook, use the
 
 
 
 
4. Multiple calculations can be made in a single formula using
 
 
 
 
5. Which of the following shortcuts can be used to insert a new line in the same cell?
 
 
 
 
6. How do you display current date and time in MS Excel?
 
 
 
 
7. Each excel file is called a workbook because
 
 
 
 
8. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
 
 
 
 
9. How can you find specific information in a list?
 
 
 
 
10. You can set Page Border in Excel from
 
 
 
 
11. What is represented by the small, black square in the lower-right corner of an active cell or range?
 
 
 
 
12. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
 
 
 
 
13. Edit >> Delete command
 
 
 
 
14. MS-EXCEL is based on ……….?
 
 
 
 
15. If particular workbook have to open each time Excel started, where that workbook should be placed?
 
 
 
 
16. Which function calculates your monthly mortage payment?
 
 
 
 
17. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
 
 
 
 
18. Which of the following describes how to select all the cells in a single column?
 
 
 
 
19. Files created with Lotus 1-2-3 have an extension
 
 
 
 
20. Which of the following formulas is not entered correctly?
 
 
 
 

 

Though I’ve made every effort to make sure the quiz does not have any errors, however, if you discover any discrepancies, please copy and paste the question itself in the comment form below. Please note that the twenty questions are randomly generated out of 400+ MS Excel MCQ question bank, simply referring to question number will not help me to identify it.

Comments

  1. 13. To center worksheet titles across a range of cell, you must
    A)Select the cells containing the title text and use the fill handle to center the text across a range of cells
    B)Widen the columns
    C)Select the cells containing the title text and use the fill handle to center the text across a range of cells
    D)Widen the column

    sir option repeat bhako 6 yo question ma what is the correct ans for this question?

    Reply

Leave a Reply

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

Recent Comments