लोक सेवा आयोग
नेपाल विविधि सेवा, राजपत्र अनंकित प्रथम श्रेणी (प्राविधिक), कम्प्युटर अपरेटर डाटाइन्ट्रि सुपरà¤ाइजर वा सो सरह पदको प्रतियोगितात्मक लिखित परिक्षा 2074/05/23
Key B
Time: 45 Minutes F.M.: 50
Objective Questions(50x1=50 Marks)
1. What would be result if you type = A1 = B1 in C1?
a. Yes or No
b. True or False
c. Invalid value
d. Value of B1
2. In MS Excel, concatenation of text can be done using.
a. Apostrophe
b. Exclamation
c. Hash
d. Ampersand
3. In MS Excel, getting data from a cell located in a different sheet is called
a. Accessing
b. Updating
c. Referencing
d. Functioning
4. Which of the following is not a valid data type in excel?
a. Number
b. Character
c. Label
d. Date/time
5. Which of the following is the correct order of keywords for SQL SELECT statements?
a. SELECT, WHERE, FROM
b. FROM, WHERE, SELECT
c. WHERE, FROM, SELECT
d. SELECT, FROM, WHERE
6. In MS Access, technique to speed up data retrieval is
a. Indexing
b. Referencing
c. Speeding
d. Listing
7. The technique which define a set of values acceptable for the field is known as
a. Verification
b. Acceptance
c. Validation
d. Setting
8. DDL stands for
a. Data Definition Language
b. Data Deletion Language
c. Data Duplication Language
d. Dual Deduction Language
9. __is a tool to automate tasks and add functionality to your forms, reports and controls
a. List
b. Validation
c. Automation
d. Macros
10. Which of the following is not an option when printing handouts?
a. Six slides per page
b. Five slides per page
c. Three slides per page
d. Two sides per page
11. ___refers to the way things are arranged on a slide.
a. Slide design
b. Slide layout
c. Slide transition
d. Rehearse timing
12. What is a motion path?
a. A type of animation entrance effect
b. A method of a advancing slides
c. A method of moving items on a slide
d. All of the above
13. Which of the following HTML tag has an attribute called frame?
a. <input>
b. <form>
c. <frameset>
d. <table>
14. How can you make a bulleted list?
a. <list>
b. <nl>
c. <ul>
d. <ol>
15. How long is an IPv6 address?
a. 32 bits
b. 128 bits
c. 64 bits
d. 256 bits
16. Total number of bits in 1 KB is
a. 1024
b. 4096
c. 8192
d. 1048576
17. What is the size of source and destination IP address in IP header?
a. 4 bits
b. 8 bits
c. 12 bits
d. 32 bits
18. Text within <EM>__</EM> tag displays text in___format.
a. Bold
b. Italic
c. List
d. Indented
19. CAD stands for
a. Computer Aided Design
b. Calculator Aided Diagram
c. Customized At Design
d. Computer Aided Diagram
20. The memory which is programmed only at the time of manufacture is
a. ROM
b. RAM
c. PROM
d. EPROM
21. A computer program that converts program into machine language all at once
a. Interpreter
b. Compiler
c. Simulator
d. Converter
22. The ratio of the horizontal length to the vertical length in monitor is called
a. Aspect ratio
b. Scale
c. DPI
d. Resolution
23. Number of bits in Nepali Unicode character is
a. 8
b. 64
c. 128
d. 32
24. Location where the 1st computer instructions available in boot up is
a. BIOS
b. CPU
c. boot.ini
d. CONFIG.SYS
25. In NIC specification 10/100/1000 refers to
a. Protocol speed
b. A fiber speed
c. Megabits per seconds
d. Minimum and maximum server speed
26. In Electronic Transaction Act of Nepal, the method of digital signature is
a. Private-private key
b. Private-public key
c. Symmetric public key
d. All of the above
27. Maximum number of hosts on a local subnet that uses 255.255.255.224 subnet mask is
a. 14
b. 15
c. 16
d. 30
28. RS-232 is a standard that applies for
a. Parallel sort
b. Game ports
c. Networks
d. Serial ports
29. Hexadecimal value 20 is equivalent to decimal number
a. 16
b. 20
c. 32
d. 64
30. In computing, what is the process by which a running computer system is restarted without the need to interrupt the power?
a. Hibernate
b. Warm boot
c. Cold boot
d. Restart
31. The___folder is the place that most application want to store data fields in
a. Start menu
b. Recycle bin
c. Program files
d. My document
32. __tool helps to reduce file access time from disk
a. Sandisk
b. Disk defragment
c. Backup
d. Format
33. Which is not true for operating system?
a. Helps to execute application
b. Performs memory management
c. Solve user's actual problem
d. Control all the operation of computer
34. __allow(s) us to organize our files so we can more easily find them.
a. Navigation
b. Folders
c. Desktop
d. None of the above
35. What is the keyboard shortcut to create a copyright symbol in MS-Word?
a. Alt + C
b. Ctrl + C
c. Alt + Ctrl + C
d. Ctrl + Shift + C
36. In MS-Word, "Cover Page" option is available in tab
a. Home
b. Insert
c. Design
d. Page layout
37. Keyboard option is printed watermark of MS-Word
a. Alt + =
b. Ctrl + =
c. Shift + =
d. Ctrl + +
38. Not an option in printed watermark of MS Word
a. No watermark
b. Picture watermark
c. Text watermark
d. Logo watermark
39. Shortcut key to open the open dialog box in MS-Word is
a. F12
b. Shift + F12
c. Alt + F12
d. Ctrl + F12
40. What is the maximum number of lines you can set for a drop cap?
a. 3
b. 5
c. 10
d. 20
41. Bold, Italic, Regular are known as
a. Word art
b. Font effect
c. Font styles
d. Text effects
42. Keyboard shortcuts to inserts a column break and start a new column immediately?
a. Press Alt + Shift + Enter
b. Press Alt + Enter
c. Press Ctrl + Enter
d. Press Ctrl + Shift + Enter
43. ___combination of keys are used for paste the text.
a. Shift + insert
b. Shift + copy
c. Ctrl + paste
d. None of the above
44. The A4 paper width/height is__
a. 8.27"x11.69"
b. 8.5"/11.11.7"
c. 8.77"/11.9"
d. None of the above
45. In MS Excel which of the following is an absolute data in a row?
a. !A!1
b. $A$1
c. #A#1
d. A1
46. What function displays row data in a column or column data in a row?
a. Hyperlink
b. Index
c. Transpose
d. Rows
47. In MS Excel, a function inside another function is called a___function.
a. Nested
b. Round
c. Sum
d. Text
48. Which of the following methods cannot be used to enter data in a cell?
a. Pressing the ESC key
b. Pressing an arrow key
c. Pressing the tab key
d. Clicking the enter button on the formula bar
49. Which options allows you to bold all the negative values within the selected cell range
a. Zero formatting
b. Conditional formatting
c. Compare formatting
d. Negative formatting
50. In excel, by default numeric value appears in
a. Right aligned
b. Left aligned
c. Centre aligned
d. Justify aligned
