Microsoft excel quiz for psc computer exam

The Microsoft excel quiz is important for all psc exam of both assistant and full computer operator. The Public Service Commission (Lok-Sewa Aayog) has also asked more than 3 questions about the Microsoft Excel chapter. a quiz about Microsoft excel so useful for preparing PSC Computer exam.

Microsoft Excel MCQ Quiz part-5

1. Xls is the file extension for ……..
   1.   MS Word
   2.   MS Xls
   3.   MS Excel
   4.   None of the above
2. The formulas in MS Excel start with ….
   1.   / (divide)
   2.   + (Plus)
   3.   = (Equal)
   4.   None of the above
3. The advantage of using the spreadsheet is:
   1.   Calculation can be done automatically
   2.   Changing data atomically updates calculations
   3.   More flexibility
   4.   All of the above
4. These are the three types of data found in spreadsheets:
   1.   Data, words, numbers
   2.   Equations, data numbers
   3.   Words, numbers, labels
   4.   Numbers, formulas, labels
5. To merge a cell which tab to you use from the format cell menu?
   1.   Number tab
   2.   Alignment tab
   3.   Font tab
   4.   Merge tab
6. How do you rearrange the data in ascending or descending order?
   1.   Data, sort
   2.   Data, form
   3.   Data, table
   4.   Data subtotal
7. Which of the following is an absolute cell reference?
   1.   ! A!!
   2.   $A$1
   3.   #A#1
   4.   A1
8. Which symbols formula beings with?
   1.   =
   2.   +
   3.   (
   4.   @
9. To add two cells (A1 and A2) together you use the following formula:
   1.   =A1+A2
   2.   =add (A1+A2)
   3.   =together (A1:A2)
   4.   A1 plus A2
10. On the Excel sheet the active cell in indicated by:
    1.   A dark wide boarder
    2.   A dotted boarder
    3.   A blinking boarder
    4.   No one of the above

 

Microsoft excel quiz

This Microsoft excel quiz contains 10 multiple-choice questions(MCQs) from the Microsoft Excel chapter. Each question contains four options in which one is the correct option. Select the correct option by clicking on the "?" button. Your score will appear together.

We have published various Microsoft excel quiz on ms access quiz questions, MS-PowerPoint, and MS-Access. Hope you all like these quizzes. If there are mistakes in any question, please comment on the related post. Thanks!