Ms excel quiz for psc computer operator exam

The ms excel quiz is so helpful for every psc exam of both assistant and full computer operator. The Public Service Commission (PSC) has also asking almost 8 questions about Microsoft excel. Ms excel quiz is most important for preparing PSC Computer exam.

This ms excel quiz contains 10 multiple-choice questions(MCQs) from the Microsoft excel quiz questions with answers. Each question has four options and one of them is the correct option. Select the correct answer by clicking on the button. Your score will appear at the same time.

Microsoft Excel MCQ Quiz part-2

1. The cell level F5 refers to:
   1.   Function key F5
   2.   Row F column 5
   3.   Column F rows 5
   4.   Function available in cell
2. Which is an example of a formula in MS Excel?
   1.   Sum(A1:A2)
   2.   =A1+A2
   3.   =add(A1:A2)
   4.   A1+A2
3. How do you display current date and time in MS Excel?
   1.   Time()
   2.   Date()
   3.   Today()
   4.   Now()
4. In MS-Excel B7:B9 indicates:
   1.   Cell B8 only
   2.   Cell B7 and B9 only
   3.   Cell B7 through B9
   4.   None of the above
5. In ms excel, what happens when dollar sign ($) are entered in a cell address? (ex: $B$2 : $B$10)
   1.   The status bar does not display the cell address
   2.   An absolute cell address in created
   3.   Cell address will change when it is copied to another cell
   4.   The sheet tab is changed
6. In Ms Excel, what do you mean by a workspace?
   1.   Group of workbook
   2.   Group of columns
   3.   Group of worksheets
   4.   Group of rows
7. Which of the following is a popular DOS based spreadsheet package?
   1.   Lotus 1-2-3
   2.   Word
   3.   Smart cell
   4.   Excel
8. The intersection of a row and column is called:
   1.   An equation
   2.   Data
   3.   A field
   4.   A cell
9. Which operator will combine text from two cells into one cell?
   1.   Space
   2.   & (ampersand)
   3.   = (equal)
   4.   None of the above
10. An excel workbook is a collection of:
    1.   Worksheets and charts
    2.   Workbook
    3.   Worksheets
    4.   Charts

 

The title bar of Microsoft excel

The bar that you will see in the top part of MS Excel windows is called the Title Bar. Its shows the name of the opened file.

If you are working on a new document, then its name will be Book1, when you go to save it, then you can save it by keeping the name of your choice. Now your name will appear in place of Book1.

Its right side corner contains 3 buttons. i.e. minimize button, maximize button, and close button. These three buttons have different functions.

Minimize button- When we click this button, Microsoft Excel or any program that is open, it goes down in the taskbar. You can open it again at any time by clicking on the taskbar. We use it only when we need to open some other application in the middle while working.

Maximize button - Using this button, we can change the box size of Microsoft Excel windows or any other program. We can work by adjusting the width and length of the program's window. By clicking this button again, we can bring the application back to full screen.

Close Button - When we click this button, the application or program closes. It is in red color.

Ms excel quiz for psc

Microsoft excel quiz questions with answers are the collection of MCQ sets of ms excel quiz. It is so useful for the psc computer exam of the different sectors. like Oil corporation, khane pani, Nepal telecom, Different municipality, and state-level exams, etc.

We have published various MCQ online computer quizzes on ms excel quiz, MS-Excel, 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!