computer operator assistant

 

nf]s ;;]jf cfof]u

 लोक ससेवा आयोग
स्थानीय तह अन्तर्गत प्राविधिकतर्फ विविध सेवा, चौथो तह,
सहायक कम्प्युटर अपरेटर पदको प्रतियोगितात्मक लिखित परीक्षा
२०७६र४र२४
प्भथ९द्य०    पुर्णाङ्कस्(५०                                                                         
    समयस्(४५ मिनेट    विषयस्(सेवा सम्बन्धी
बस्तुगत बहुउतर ९५४ ह् १ अङ्क०स्
          उतरपुस्तिकामा प्रश्नपत्रकोपभथअनिवार्य रुपले उल्लेख गर्नुपर्नेछ ।
 साथै परीक्षामा ऋबअिगयबितयच,ःयदष्भि  वा यस्तै प्रकारका विधुतीय उपकरण प्रयोग गर्न पाइने छैन ।
 

 

1.Which of the following areas in the Microsoft Excel 2010 Pivot Table Table field list calculates the aggregates of columns?

  1. Report filter                             (B) Row labels                       (C)  Values                            (D) None of the above                                                                                                           

2. Excel keeps the changed  history of  a workbook for……… days by default.

  1. 10 days                                         (B) 20 days                           (C) 25 days                            (D) 30 days

3. What is the filename extension of excel workbooks which ara saved as excel templates?

  1. .xlsx                                               (B) .xslt                                   (C) .xltx                                  (D).slk

4. How would you locate the last cell on a worksheet?

  1. Click anywhere in the worksheet, and then press Ctrl+Home
  1. Click anywhere in the worksheet, and then press Ctrl+Insert
  1. Click anywhere in the worksheet, and then press Ctrl+End

5. Which chart displays axes but cannot display axis titles?

  1. Which chart                         (B). Doughnut chart              (C).Pie chart                            (D) All of the above

6.How can you update the values of formula cells if auto calculate mode of excel is disabled?

  1. F8                                            (B)F8                                         (C)F10                                        (D) F11

7.Which of the following option is not available in paste dialog box?

  1. add                                          (B) subtract                             (C)divide                                   (D) SQRT

8. A characteristic of an entity

  1. relation                                  (B) attribute                            (C)Parameter                          (D) constraint

9.It is an associtation established between two tables with common field is…..

  1. line                                          (B) relationship                     (C)Primary key                        (D) records

10. To inset new slide in Powerpoint

  1. Ctrl+M                                    (B) Ctrl+N                                 (C)Alt+M                                   (D) Alt+N

11.Which feature of PowerPoint allows you to add background color, colors for text and lines on slide?

  1. Animation scheme              (B) Background color          (C) Design template               (D) Colo scheme

12. A digital signature needs a

  1. private-key system             (B) shared-key system         (C) public-key system          (D) All of the above

13. According to the Constitution of Nepal, which from given option below does not belong the duty of citizens?

  1. To safeguard the the nationality, sovereignty and integrity of Nepal, while being loyal to the nation
  1. To contravention of the Constitution and law
  1. To protect and preserve public property
  1. To abide by the constitution and law                                                                      Contd......

 

 

 

B-2

14. Which of the following is valid orientation?

  1.  Landscape and portrait        (B) Gutter                              (C) Header and footer               (D) All of the above

15. Which of the following typically appear at the end of document for citation of source?

  1.  End notes                            (B) Foot notes                         (C) Header                                (D) footer

16. The second generation of computer was in period of

  1.  1900 - 1936                         (B) 1937 - 1956                       (C) 1957 - 1962                        (D) 1963 - 2000

17. Joystick is….device.

  1.  input                                     (B) output                                (C) processing                          (D) storage

18. GPu in control unit stands for

  1. Graphic Processing Unit                                                        (B) Gigabit  Processing Unit

       (C)  Gregorian processing Unit                                                    (D) Garbage processing Unit

19. Vulnerabiliy of system designed to provide the attacker with complete control for the victim's system

  1. Remote Access Trojan                                                            (B) Denial-of-Service
  1. Distributive Denial-of -Service                                               (D) fracking

20

Specific class of computer software that provides the low-level control for the device's specific hardware is known as

  1. Memroy Unit
  1. Cache
  1. firmware
  1. Extension