Excel formula grade quiz for psc computer exam

The excel formula grade 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. excel formula grade quiz is so useful for preparing PSC Computer exam.

Microsoft Excel MCQ Quiz part-6

1. You can create hyperlinks from the Excel workbook to:
   1.   A webpage on company internet
      All of the above
   2.   A webpage on the internet
   3.   Other office 97 applications documents
   4.   All of the above
2. The cell labeled F5 refers to:
   1.   Function key F5
   2.   Row F column 5
   3.   Column F row 5
   4.   Functions available in cell
3. Which is an example of formula in MS Excel?
   1.   Sum (A1:2)
   2.   =A1+A2
   3.   =add (A1:A2)
   4.   A1+A2
4. How to display current date and time in MS Excel?
   1.   Time()
   2.   Date()
   3.   Today()
   4.   Now()
5. In MS Excel B7:B9 indicates:
   1.   Cell B8 only
   2.   cell B7 and cell B9 only
   3.   cell B7 through B9
   4.   none of the above
6. in MS Excel, what happens when dollar sign($) are entered in a cell address (ex: $B$@:$B$10)
   1.   the status bar does not display the cell address
   2.   an absolute cell address is created
   3.   cell address will change when it is copied to another cell
   4.   the sheet tab is changed
7. In MS Excel, what do you mean by a workspace?
   1.   Group of workbooks
   2.   Group of columns
   3.   Group of worksheets
   4.   Group of rows
8. Which of the following is a popular DOS based spreadsheet package?
   1.   Lotus 1-2-3
   2.   Word
   3.   Smart cell
   4.   Excel
9. The intersection of row and column is called:
   1.   An equation
   2.   Data
   3.   A field
   4.   A cell
10. Which of the following is the latest version of Excel?
    1.   Excel 2000
    2.   Excel 2002
    3.   Excel 2007
    4.   Excel 2016

 

Excel formula grade quiz

This excel formula grade 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 MCQs Computer quiz on excel formula grade quiz, 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!