Monday, 8 June 2020

लोक सेवा आयोग नेपाल विविध सेवा, राजपत्र अनंकित प्रथम श्रेणी (प्राबिधिक) कम्प्युटर अपरेटर पदको लिखित परिक्षा

लोक सेवा आयोग
नेपाल विविध सेवा, राजपत्र अनंकित प्रथम श्रेणी (प्राबिधिक)
कम्प्युटर अपरेटर पदको लिखित परिक्षा
२०७४/०५/२३
KEY (B)
                Correct Answers are highlighted.

1. What would be result if you type=A1=B1 in cell C1
a. Yes or No
b. True of False  (It should be True or False instead of True of 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 slides 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 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 bytes ( It should be 128 bit instead of 128 bytes)
c. 64 bits
d. 256 bits

16. Total number of bits in  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 instruction available on 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 Second
d. Minimum and Maximum server speed

26. In Electronic Transaction Act of Nepal, the method od digital signature is
a. Private-Private key
b. Private-Public key
c. Symmetric Public key
d. All of the above

27. Maximmum number of hosts a local subnet that uses 255.255.255.254 subnet mask is …
a. 14
b. 15
c. 16
d. 30

28. RS-232 is a standard that applies to:
a. parrallel ports
b. Game ports
c. Networks
d. Serial ports

29. Hexadecimal value 20 is equavalent 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 default place that  most application want to store data files in.
a. Start Menu
b. Recycle Bin
c. Program Files
d. My Documents

32. … tool helps to reduce file access time from disk
a. Scandisk
b. Disk Defragment
c. Backup
d. Format

33. Which is not true for operating system?
a. Helps to execute applications
b. Performs memory management
c. Solves user’s actual problems
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 shortcut key to insert an equation in 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 effect

42. Keyboard shortcut to inserts a column break and start a new column immediately?
a. Psress 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″.11.69″
b. 8.5″/11.7′
c. 8.77″/11.9″
d. None of the above

45. In excel, which of the following is an absolute cell reference?
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 fcalled a… fumction.
a. Nested
b. Round
c. Sum
d. Text

48. Which of the following method cannot be used to enter data in a cell?
a. pressing the Esc key
b. Pressing the arrow key
c. Pressing the tab key
d. Clicking the enter button to 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 values papers in
a. Right aligned
b. Left aligned
c. Center aligned
d. Justify aligned

No comments:

Post a Comment

MCQ Question Bank Microsoft PowerPoint