Nepal Police, Computer Operator 2080/12/14

 

लाेक सेवा आयाेग

नेपाल प्रहरी प्राविधिक, इन्जिनियरिङ्ग, सूचना प्रविधि/कम्प्युटर, प्राविधिक प्रहरी सहायक निरीक्षक 

(सूचना प्रविधि/कम्प्युटर) पदको खुला प्रतियोगितात्मक लिखित परिक्षा

२०८०/१२/१४

पत्र: प्रथम                                              KEY [D]

समय: ४५ मिनेट                                    पूर्णाङ्क: १००

विषय: Professional and Service Specific Test

उत्तरपुस्तिकामा प्रश्नपत्रको KEY अनिवार्य रुपले उल्लेख गर्नुपर्नेछ । उल्लेख नगरेमा उत्तरपुस्तिका रद्ध हुनेछ । परीक्षामा calculator, mobile प्रयोग गर्न पाइनेछैन् ।

Multiple Choice                      50x2=100 Marks      

1. Which of the following is not true regarding conditional formatting?

a. You can add more than one condition to check

b. You can set condition to look for Bold and apply italics on them

c. You can apply Font, Border and Pattern formats that meets the specified conditions

d. You can delete any condition from Conditional Formatting dialog box if it is not required.

2. Which of the following formulas is not valid in Excel?

a. =SUM(bonus)-A3

b. =SUM(A1:A8)

c. =SUM(A1:A8)*.05

d. =SUM(A1:A8)-10

3. An Excel Workbook is a collection of___

a. Charts

b. Workbooks

c. Worksheets

d. Workbooks and Charts

4. What is the shortcut key to add a new slide in a presentation?

a. Ctrl + N

b. Ctrl + M

c. Ctrl + P

d. Ctrl + O

5. Color ___ changes the color of different objects without changing content.

a. Template

b. Master

c. Scheme

d. Pattern

6. Features which allows us to view slides in a slide show without manually advancing each slide is___

a. Adding build effect

b. Setting animation

c. Adding transition

d. Adding bullet

7. How can you create a uniform appearance by adding a background image to all slides.

a. Create a template

b. Edit the slide master

c. Use the autocorrect wizard

d. Use wide-screen layout

8. Which of the following keys is used to view  the slide show?

a. F2

b. F5

c. F8

d. F10

9. राष्ट्रिय सुरक्षा परिषद्मा देहायका मध्ये को सदस्य रहँदैनन् ।

a. रक्षा मन्त्री

b. गृह मन्त्री

c. मुख्य सचिव

d. गृह सचिव

10. राष्ट्रिय जनगणना, २०७८ बमोजिम नेपालको लैगिक अनुपात कति प्रतिशत रहेको छ ?

a. ९४१६

b. ९५५९

c. ९९५

d. ९९८

11. विष्णुको वाहनलाई के भनिन्छ ?

a. गरुड

b. मयूर

c. हाँस

d. गधा

12. मैले छिचोलेका कुइनेटा कृतिमा लेखक को हुन् ?

a. विवेक ओझा

b. अमर न्यौपाने

c. कृष्ण धरावासी

d. मुकेशकुमार चालिसे

13. नेपालमा पहिलो कृषि गणना कहिले भएको थियो ?

a. वि.स. १९६८

b. वि.स. २००८

c. वि.स. २०१८

d. वि.स. २०२८

14. Which of the following is a method of gaining access to a computer program or an entire computer system while circumventing all security measures?

a. Backdoor

b. Masquerading

c. Phising

d. Trojan Horse

15. Which of the following was used in Third Generation Computer?

a. Vacuum Tubes

b. Resistors

c. Integrated Circuits

d. Bio Chips

16. Which part interprets program instruction and initiates control operations?

a. Input Unit

b. Storage Unit

c. Logic Unit

d. Control Unit

17. Which of the following memories needs refreshing?

a. SRAM

b. DRAM

c. ROM

d. PROM

18. The physical and logical arrangement of nodes and connection in a network is known as___

a. Media

b. Network Setup

c. Topology

d. Protocol

19. A video consists of a sequences of____

a. frames

b. packets

c. signals

d. pulses

20. A microcode or program that is embedded into the memory of hardware devices to help them to operate is known as___

a. Floppy Memory

b. Cache Memory

c. Firmware

d. Control Unit

21. Firmware is generally written in___

a. RAM

b. ROM

c. Hard Disk

d. Cache

22. Which of the following is a computer memory that can be programmed once, but not reprogrammed?

a. ROM

b. RAM

c. PROM

d. EPROM

23. Which of the following was the first computer made available for commercial use?

a. Mark-I

b. ENIAC

c. EDVAC

d. UNIVAC

24. Which of the following is not an input device?

a. Keyboard

b. Mouse

c. Scanner

d. Printer

25. Hardware maintenance does not involve taking care of___

a. Keyboard

b. Application Programming

c. Defragmentation of hard disk

d. Hard disk drive

26. FAT stands for___

a. File Attribute Table

c. File Allocation Table

c. Font Attribute Table

d. Format Allocation Table

27. GUI based for___

a. Geographical User Interest

b. Graphical Ultra Imagination

c. Graphical User Interface

d. Geometric Ultra Interfacing

28. The primary job of the operating system is to manage____

a. commands

b. users

c. programs

d. resources

29. Which DOS command is used to fix the minor errors of the disk?

a. FDISK

b. FORMAT

c. CHKDSK/f

d. ATTRIB

30. What is modified when changing the system start-up boot sequence?

a. BIOS/CMOS

b. CONFIG.SYS

c. COMMAND.COM

d. Autoexec.bat

31. In Database Management System, what is used to establish an association between related tables?

a. Line 

b. Relationship

c. Primary key

d. Record

32. What determines a table's sort order in DBMS?

a. AutoNumber Field

b. Field Order

c. Index Field

d. Primary Key

33. In E-R Diagram, ______ are used to represent attributes.

a. Ellipses

b. Rectangles

c. Diamonds

d. Double Lines

34. Which of the following is not a type of page margin?

a. Left

b. Right

c. Center

d. Top

35. Which feature is used for monitoring all document change?

a. Edit Document

b. Monitor Change

c. Track Change

d. Track All

36. Which shortcut key is used to view the thesaurus of a word?

a. Shift + F5

b. Shift + F7

c. Ctrl + Shift + F5

d. Ctrl + Shift + F7

37. How can you access the font size tool on formatting toolbar?

a. Ctrl + S

b. Ctrl + Shift + S

c. Ctrl + P

d. Ctrl + Shift + P

38. Ctrl + Shift + D is used for ____ underline.

a. double

b. wave

c. dotted

d. dash

39. What is the shortcut key to align text to center?

a. Ctrl + A

b. Ctrl + B

c. Ctrl + D

d. Ctrl + E

40. What is the shortcut key for 'Save As' in Word Processing?

a. F2

b. F5

c. F10

d. F12

41. Which is best suited definition about gutter margin?

a. Margin that is added to the left margin

b. Margin that is added to the right margin

c. Margin that is added to the binding side of page

d. Margin that is added to the outside of the page

42. To update a formula in a table, press the____

a. F9 key

b. Alt + F9 key

c. F8 key

d. F6 key

43. Which of the following keystroke is used to move the cursor to the end of the document?

a. End

b. Shift + End

c. Ctrl + End

d. Alt + End

44. Each cell in a Microsoft Office Excel document is referred to by its cell address which is the cell's ____

a. column label

b. column label and worksheet tab name

c. row label

d. row and column labels

45. A formula that either directly or indirectly depends on itself is called ____ software.

a. Iterative

b. Circular

c. Self

d. Auto

46. Which of the following contains the name of each record on the chart?

a. Cell

b. Title

c. Axis

d. Legend

47. Comments inserted for specific cell are called ____ Tips.

a. Smart

b. Cell

c. Tool

d. Remark

48. Excel file cannot be exported to ____ format.

a. DOC

b. CSV

c. XML

d. HTML

49. Feature to keep portion of sheet visible while scrolling a document is ____ Pane.

a. Lock

b. Stable

c. Freeze

d. Visible

50. Which chart would be best suited to track the progress of the stock market on a daily basis?

a. Pie Chart

b. Row Chart

c. Line Chart

d. Column Chart

-The End-