Krishi Samagri Computer Operator 2074/09/26

 

Lok Sewa Aayog

Krishi Samagri Company Ltd Assistant 5th Level Computer Operator Competitive Written Exam Held On 2074/09/26

Time: 45 Minutes                                        Full Marks: 50

Multiple choice: 50x1=50

1. The function is used to replace existing text with new text

a. Replace

b. Substitute

c. Substring

d. String

2. Tab scrolling button\

a. All you to view a different worksheet

b. All you to view a additional worksheet rows down

c. All you to view a additional worksheet columns to right

d. All you to view additional sheets tabs

3. The function extract data stored in a pivot table

a. Get data

b. Get pivot data

c. Pivot data value

d. Data value

4. In maximum, how many sheets can be set as default while creating new workbook?

a. 254

b. 255

c. 256

d. No limit

5. The result of data processing is

a. Database

b. Information

c. Knowledge

d. Records

6. To remove a relation from an SQL database, we use the command?

a. Delete

b. Purge

c. Remove

d. Drop table

7. How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data?

a. Query wizard

b. Look up wizard

c. Form wizard

d. Report wizard

8. A field can be called as in relation context

a. Random file

b. Direct file

c. Attribute

d. Tuple

9. Every table in relational database contain a field or combination of field that can uniquely identify each records, it is called

a. Foreign key

b. Native key

c. Composite key

d. Primary key

10. The option is used to save PowerPoint Presentation in PDF with 4-slides per page

a. Slides

b. Handouts

c. Notes pages

d. Outline view

11. Which view shows all slides in one screen?

a. Slide master

b. Slide sorter

c. Slide layout

d. Slide show

12. To insert a new slide in the current presentation, we can choose

a. Ctrl + M

b. Ctrl + N

c. Ctrl + 0

d. Ctrl + F

13. A webpage displays a picture. What tag was used to display that picture?

a. Picture

b. Image

c. Img

d. Src

14. Using only HTML, we can create

a. Dynamic web page

b. Static web page

c. Both a and b

d. None of the above

15. What is the correct HTML for creating a hyperlink?(Modified Question)

a. <a href="http://www.google.com">Google</a>

b. <a url="www.google.com">Google</a>

c. <a>http://www.google.com</a>

d. <a name="http://www.google.com">Google</a>

16. Which of the following have low failure rate?

a. Mechanical device

b. Electronic device

c. Electro-mechanical device

d. None of the above

17. The main function of ALU is

a. Perform arithmetic and logic operation

b. Store data and information for future use

c. Control computer output, such as printing

d. Monitor all computer activities

18. What is a light pen?

a. A mechanical input device

b. Optical input device

c. Electronic input device

d. Optical output device

19. Which of the following is suitable after you install new drivers?

a. Shut down

b. Restart

c. Sleep

d. Hibernate

20. CD-ROM stands for

a. Compactable Read Only Memory

b. Compact Data Read Only Memory

c. Compactable Disk Read Only Memory

d Compact Disk Read Only Memory

21. What is compiler?

a. A compiler does a conversion line by line as the program is run

b. A compiler converts the whole of a higher level program code into machine code in one step

c. A compiler is a general purpose language providing very efficient execution

d. None of the above

22. What is the most common tool used to restrict access to a computer system?

a. User logins

b. Passwords

c. Computer keys

d. Access-control software

23. As compared to the secondary memory, the primary memory of a computer is

a. Large

b. Cheap

c. Fast

d. Slow

24. Junk e-mail is also called

a. Spam

b. Spoof

c. Sniffer

d. Worm

25. Network congestion occur

a. In case if traffic overloading

b. When a system terminates

c. When connection two nodes terminates

d. None of the above

26. What type of resources is mostly likely to be a shared common resource in a computer network?

a. Printers

b. Speakers

c. Keyboards

d. Floppy disk drives

27. MAN is a 

a. Cost

b. Company

c. Network

d. Country

28. Communication channels is shared by all the machines on the network in

a. Broadcast network

b. Unicast network

c. Multicast network

d. None of the above

29. In Internet windows is

a. Internet provider

b. Internet protocol

c. Internet procedure

d. Internet processor

30. A Microsoft window is

a. Operating system

b. Graphic program

c. Word processing

d. Database program

31. When you turn on your computer, it will check on the following control filters?

a. Command.com, io.sys

b. Command.com, date.com, dir.com

c. Command.com, io.sys, msdos.sys

d. Chkdsk.com

32. The___program compress large files into a smaller files.

a. WinShrink

b. WinZip

c. WinStyle

d. None of the above

33. The main function of the command interpreter is

a. To get and execute the next user-specified command

b. To provide the interface between the API and application program

c. To handle the files in operating system

d. None of the above

34. Only filenames and extension are to be displayed in wide format, which command you'll use?

a. Dir/w

b. Dir a:

c. Dir/s

d. Dir/b

35. Which of the following is not valid version of MS Office?

a. Office XP

b. Office Vista

c. Office 2007

d. None of the above

36. Background color or effect applied on a document is not visible in

a. Web layout view

b. Print layout view

c. Reading view

d. Print preview

37. What is gutter margin?

a. Margin that is added to the left margin when printing

b. Margin that is added to the right margin when printing

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

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

38. What is the shortcut key to open dialog box?

a. F12

b. Shift + F12

c. Alt + F12

d. Ctrl + F12

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

a. Left

b. Right

c. Center

d. Top

40. Which of the following is statement is false?

a. You can set different header and footer for last page of  a section

b. You can set different header footer for even and old pages

c. You can set different page number formats for different function

d. You can set different header footer for first page of a section

41. The space at the end of a page is called the

a. Footer

b. Margin

c. Bottom

d. Endnote

42. In which view Headers and Footers are visible?

a. Normal view

b. Page layout view

c. Print layout view

d. Draft view

43. Which of the following is not of the merge process?

a. Sort the data source records

b. Merge the two files to print or create a new document

c. Edit a data source

d. Format a main document

44. Which of the following is not a font style?

a. Bold

b. Italics

c. Regular

d. Superscript

45. The intersection of a column and a row on a worksheet is called

a. Workbook

b. Worksheet

c. Cell

d. Address

46. Which function is used to calculate depreciation, rates of return, future values and loan payment amount?

a. Logical

b. Financial

c. Statistical

d. Math and trigonometry

47. Which language is used to create macros in Excel?

a. Visual basic

b. C

c. C++

d. Java

48. In Excel, which one denotes a range from B1 through E5?

a. B1-E5

b. B1:E5

c. B1 to E5

d. B|$ES

49. Which tool is used to join some cells and place the content at the middle opened cell?

a. Wrap text

b. Center alignment

c. Merge and center

d. Shrink to fit

50. In the formula, which symbols specifies the fixed columns or rows?

a. $

b. *

c. %

d. &