Public Service Commission
Nepal Police, Engineering(Information Technology/Computer),
Technical Police Assistant Inspector Open Competitive Written Examination 2078/10/01
1. Which command can be used to ask you to confirm that you want to delete the directory?
a. Deltree
b. Deltree/f
c. Del*.*p
d. Erase*.*
2. If a process fails, most operating system writes the error information to a
a. Log file
b. Another running process
c. New file
d. None of the above
3. In Windows OS,___character is not allowed to use in the meaning of file or folder
a. &
b. $
c. <
d. ^
4. File type can be represented by
a. File name
b. File extension
c. File identifier
d. None of the above
5. What is the shortcut key to open the thesaurus window?
a. Ctrl + F7
b. F7
c. Alt + F7
d. Shift + F7
6. In MS Word, which key combination is used to go back to main bullet from sub-bullet?
a. Alt + Tab
b. Ctrl + Tab
c. Shift + Tab
d. None of the above
7. Shortcut key for manual column break in MS Word is
a. Ctrl + Enter
b. Shift + Spacebar
c. Ctrl + Shift + Enter
d. Alt + Enter
8. ___is used to convert from upper case to lower case vice versa.
a. Toggle case
b. Sentence case
c. Lower case
d. Upper case
9. In MS Word, which of the following statement is true in case of table?
a. You can add row or column anywhere in the table
b. You can merge adjacent cells of the table
c. You can split any cell of the table
d. All of the above
10. Which of the following is valid gutter position in Microsoft Word?
a. Bottom
b. Right
c. Left
d. Center
11. The shortcut keys for the___character formatting are Ctrl + Shift + Plus sign.
a. Case of letters
b. Superscript
c. Underline words, not space
d. All capital letters
12. In MS Word, which menu is used to insert Footnote, Endnote and Citation?
a. Insert
b. References
c. Design
d. Layout
13. In what unit of measure is spacing before and after paragraph increased or decreased?
a. Pixels
b. Points
c. Inches
d. Centimeters
14. Which feature is used for monitoring all document changes?
a. Edit document
b. Monitor change
c. Track change
d. Track all
15. How do you get Borders and Shading dialog box to put and type of page borders in word document?
a. Draw->page borders
b. Page layout->page borders
c. Design->page borders
d. None of the above
16. In which of the following dialog box will you set any type of page borders?
a. Page borders
b. Page setup
c. Borders and shading
d. Page design
17. A number of letter that appears little below the normal text is called
a. Superscript
b. Subscript
c. Supertext
d. Toptext
18. Which statement is false in case of header and footer of the document?
a. Text entered in header or footer area appear on each page of the document
b. Page numbers are displayed on the header or footer area of the document
c. Footnotes are displayed on the footer of the document
d. None of the above
19. The default header for worksheet is
a. Page number
b. Date and time
c. Sheet tab name
d. None of the above
20. A feature that displays only the data in column(s) according to specified criteria is
a. Formula
b. Sorting
c. Filtering
d. Pivot
21. In Excel sheet, the correct syntax to make a relative cell reference for a range of cells. Which starts in cell B2, goes over to column G and down to row 4 is
a. B2-G4
b. B2::G4
c. B2:G4
d. B2;G4
22. Which of the following features in Microsoft Excel helps you visually explore and analyze data, detect critical issues and identify patterns and trends?
a. Conditional formatting
b. Data analysis
c. Data mining
d. Relationship
23. What function displays row data in a column or column data in a row?
a. Transpose
b. Index
c. Rows
d. Hyperlinks
24. What is the correct syntax of three cells: A1, A2 and A3 using formula in Excel?
a. =AVERAGE(A1:A3)
b. =(A1+A2+A3)/3
c. =AVERAGE(A1,A2,A3)
d. All of the above
25. A function inside another function is called___function.
a. Nested
b. Round
c. Sum
d. Text
26. Which one is shortcut to delete the selected column?
a. Alt + -
b. Ctrl + -
c. Shift + -
d. Insert + -
27. The correct syntax to use IF function in excel sheet is
a. =IF(Logical test, value_if_true, value if false)
b. =IF(Logical test, value if_false, value_if_true)
c. =IF(Logical test, if(value_is_true), else(value_is_false))
d. =IF(Logial test, if(value_is_false), else(value_is_true))
28. Which key should be pressed to refer non-adjacent cell in Excel sheet?
a. Shift
b. Ctrl
c. Alt
d. Tab
29. Which of the following contains the name of each record on the chart?
a. Cell
b. Title
c. Axis
d. Legend
30. While printing the Excel sheet, which of the following is true?
a. You can print certain rows at the top of every page
b. You can make excel not print blank cells
c. You can make excel print only selected cells
d. All of the above
31. The ascending order of data hierarchy is
a. Bit-Byte-Record, Field-File-Database
b. Bit-Byte-Field-Record-File-Database
c. Bit-Byte-Field-Record-Database
d. Byte-Bit-Field-Record-File-Database
32. Which one is not correct?
a. Primary key doesn't allow duplicate entry
b. Primary key doesn't accept null value
c. Primary key is essential for relationship
d. Primary key must be numeric field only
33. In relational DBMS, the framework to store records in a database is called
a. Table
b. Form
c. Report
d. All of the above
34. Which of the following effects can be applied to any object or text inside the slide?
a. Transitions
b. Animation
c. Both of the above
d. None of the above
35. Which command brings you to the first slide in your presentation
a. Next slide button
b. Page up
c. Ctrl + home
d. Ctrl + end
36. The main components of fourth generation computer are
a. Transistors
b. Vacuum tubes and valves
c. Integrated circuits
d. VLSI and microprocessor
37. Dot-matrix, Deskjet, Inkjet and Laser are all types of which computer peripherals?
a. Printers
b. Software
c. Monitors
d. Keyboard
38. What are the major component of Central Processing Unit(CPU)?
a. ALU, Control Unit and RAM
b. Control Unit, Registers and Memory
c. ALU, Control Unit and Registers
d. None of the above
39. The difference between people with access to computers and the internet and those without this access is known as the
a. Digital divide
b. Internet divide
c. Web divide
d. E-literacy
40. The process of putting data into a storage location is called
a. Reading
b. Writing
c. Controlling
d. Hand shaking
41. What is the smallest physical storage unit on a Hard Disk?
a. Track
b. Cylinder
c. Sector
d. None of the above
42. If a computer has more than one processor, it is known as
a. Uniprocess
b. Multiprocessor
c. Multithreaded
d. Multiprogramming
43. Babbage presented his___engine to the Royal Astronomical Society which was able to calculate polynomials.
a. Computer
b. Diesel
c. Difference
d. Petrol
44. A digital content which uses a combination of different forms such as audio, images, animation, video and interactive content is called
a. Desktop publishing
b. Executable file
c. Multimedia
d. Music and songs
45. Which of the following controls the process of interaction between the user and the operating system?
a. User interface
b. Language translator
c. Platform
d. Screen saver
46. The larger the number of pixels of a computer monitor, the higher
a. Resolution
b. Refresh rate
c. Dot pitch
d. Data transfer rate
47. Network congestion occurs
a. When connection between two nodes terminate
b. When a system terminates
c. In case of traffic overloading
d. None of the above
48. A non-volatile firmware which is used to perform hardware initialization during the computer booting process is called
a. Basic Input/Output System
b. OS Kernel
c. Control panel
d. Device manager
49. A list of protocols used by a system, one protocol per layer is called
a. Protocol architecture
b. Protocol stack
c. Protocol suit
d. None of the above
50. ___is not the function of an operating system.
a. Management of computer's hardware and software resources
b. Establish a user interface
c. Virus protection
d. None of the above
Post a Comment
If you have any doubts. Please let me know