PSC Computer Operator/Data Entry Supervisor 2074/05/23

byE-Learn -
0

Nepal Diversity Service, Gazette First Class (Technical), Competitive Written Examination for Computer Operator Data Entry Supervisor or equivalent post 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

-The End- 

Also Read

Tags:
Post a Comment (0)
Previous Post Next Post