Excel practical quiz computer quiz

The excel practical quiz computer quiz is important for all PSC exam of both assistant and full computer operators. The Public Service Commission (Lok-Sewa Aayog) has also asked up to 12 questions from ms-excel. The excel quiz questions are so useful for preparing PSC Computer Operator exam.

Microsoft Excel MCQ Quiz part-13

1. Which of the following is an absolute cell reference?
   1.   !A!1
   2.   $A$1
   3.   #a#1
   4.   A1
2. What symbol is used before a number to make it a label?
   1.   “ (quote)
   2.   = (equal)
   3.   _ (underscore)
   4.   ‘ (apostrophe)
3. Which symbol must all formula begin with?
   1.   =
   2.   +
   3.   (
   4.   @
4. Which of the following formulas is not entered correctly?
   1.   =10+50
   2.   =B7*B1
   3.   =B7+14
   4.   10+50
5. Which of the following formulas will Excel Not be able to calculate?
   1.   =SUM(Sales)-A3
   2.   =SUM(A1:A5)*.5
   3.   =SUM(A1:A5)/(10-10)
   4.   =SUM(A1:A5)-10
6. A typical worksheet has …. Number of columns
   1.   128
   2.   256
   3.   512
   4.   1024
7. How many characters can be typed in a single cell in Excel?
   1.   256
   2.   1024
   3.   32000
   4.   65535
8. A worksheet can have a maximum of …. Number of rows
   1.   256
   2.   1024
   3.   32000
   4.   65535
9. Which of the following is not an example of a value?
   1.   350
   2.   May 10, 2001
   3.   0.57
   4.   Serial Number 50771
10. The chart wizard term data series refers to
    1.   A chart legend
    2.   A collection of chart data markers
    3.   A set of values you plot in a chart
    4.   A data label

 

Excel practical quiz

This excel practical quiz computer 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 excel practical quiz on excel quiz questions, Fundamental of computer, windows HTML, MS-PowerPoint, Networking and MS-Excel, etc. Hope you all like these quizzes. If there are mistakes in any question, please comment on the related post. Thanks!