Computer Operator MCQ Dugdha Bikash Sansthan 2077

Computer Operator MCQ Dugdha Bikash Sansthan 2077

Computer MCQ

Computer Operator MCQ Dugdha Bikash Sansthan 2077: are you looking for computer operator multiple choice question “MCQ” for preparing computer operator examination of NEB, PSC, NEB, Pradesh No.1 and other institution?

In this portion we will get 50 multiple choice question of Dugdha Bikash Sansthan Examination on 2077/10/12 for computer operator post, 5th level.

Computer Operator MCQ Dugdha Bikash Sansthan 2077:

1. when a formatted number does not fit within a cell, it displays.
A. ####
B. # DIV/O
C. #DIV/@
D. None of the above

Answer

A. ####

2. Each excel file is called a workbook because.
A. It can contain text and data
B. It can be modified
C. It can contain many sheets including worksheets and chart sheets
D. You have to work hard to create it

Answer

C. It can contain many sheets including worksheets and chart sheets

3. which of the following is concatenating operator.
A. Apostrophe (G)
B. Exclamation(!)
C. Ampersand ( & )
D. Hash (#)

Answer

C. Ampersand ( & )

4. which of the following formulas will excel not be able to calculate.
A. =sum(purchase)-a4
B. =sum (A1: A5 ) *6
C. =sum (A1:A5 ) / ( 10-10 )
D. =sum (A1:A5)-10

Answer

C. =sum (A1:A5 ) / ( 10-10 )

5. You cannot link excel worksheet data to a work document with.
A. The right drag method
B. The copy and paste special commands
C. A hyperlink
D. The copy and pastes buttons on the standard toolbar

Answer

D. The copy and pastes buttons on the standard toolbar

6. An information in a disk drive is accessed by address containing
A. Track number
B. Sector number
C. Surface number
D. All of the above

Answer

D. All of the above

7. Time during which a job is processed by the computer is
A. Delay time
B. Real time
C. Execution time
D. Down time

Answer

C. Execution time

8. A network that connects 10 different banks (e.g. Nepal bank ltd, Nepal Rastra bank, agriculture development bank etc.). For a specific function, can be classified as
A. Internet
B. Intranet
C. Extranet
D. LAN

Answer:

B. Intranet

9. The octal equivalent of 111010 is
A. 81
B. 72
C. 71
D. None of the above

Answer

B. 72

10. A computer program that converts an entire program into machine language at a time is called a/an
A. Complier
B. Interpreter
C. Assembler
D. Translator

Answer

A. Compiler

11. Which of the following is not a video file extension?
A. .avi
B. .flv
C. .mpeg
D. .jpeg

Answer

D. jpeg

12. The number of bits that a computer can process at a time in parallel is called
A. Word length
B. Speed
C. Accuracy
D. Diligence

Answer

A. Word length

13. Which of the following memory has the shortest access times?
A. Cache memory
B. Magnetic bubble memory
C. Magnetic core memory
D. RAM

Answer

D. RAM

14. What is the minimum number of wires needed to send data over a serial communication link layer?
A. 1
B. 2
C. 4
D. 6

Answer

B. 2

15. Which of the following is not function of operating system?
A. File management
C. Email management
B. Memory management
D. I/o management

Answer

C. Email management

16. what data changes in multiple lists and all lists are not updated, this causes.
A. Data redundancy
B. Information overload
C. Duplicate data
D. Data inconsistency

Answer

D. Data inconsistency

17. The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one more column is.
A. View
B. Order by
C. Group by
D. Having

Answer

B. Order by

18. which query command does not change any data in the database.
A. Select
B. Insert
C. Delete
D. Update

Answer

A. Select

19. The… states that a foreign key must either match a primary key value in another relation or it must be null.
A. Entity integrity rule
B. Referential integrity constraint
C. Action assertion
D. Composite attribute

Answer

B. Referential integrity constraint

20. Relationship between entities office to staff is
A. One to One
B. One to many
C. Many to one
D. Many to many

Answer

B. One to many

21. Which of the following should you use if you want all the slide in the presentation to have same “look”?
A. The slide layout option
B. Add a slide option
C. Outline view
D. A presentation design template

22. What power point feature will you use to apply motion effects to different objects of a slide?
A. Animation scheme.
B. Motion
C. Slide design
D. Slide transition

23. Which command brings you to the first slide in your presentation?
A. Next Slide Button
B. Page Up
C. Ctrl+Home
D. Ctrl+End

24. Objects on the slide that hold text are called
A. Placeholders
B. Object holders
C. Auto layout
D. Text holders


25.slides per page is not an option when printing handouts.

A. Six
B. Five
C. Three
D. Two

26. 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

27. Command line operation used to list only directories is?
A. DIR/S
B. LS D
C. CD
D. DIR/A:B

28. An error is also known as
A. Bug
B. Debug
C. Cursor
D. Icon

29. In windows, add new computer hardware option exists in
A. Main menu
B. Status bar
C. Task bar
D. Control panel

30. Which key can be pressed quit without saving in DOS?
A. Ctrl+A
B. Ctrl+B
C. Ctrl+C
D. Ctrl+D

31. Which of the following terms is used for the form in which the word will appear on the page?
A. Text formatting
B. Character formatting
C. Point size
D. Type size

32. Which of the following is not a type of page margin?
A. Left
B. Right
C. Center
D. Top

33. Portrait and landscape are
A. Page orientation
B. Paper size
C. Page layout
D. All of the above

34. Sequence of steps in inserting the table of content is
A. Insert— object— index and tables— table of content
B. Reference — table of content
C. Insert reference— tables— table of content
D. Reference — content— table

35. Which future is used for monitoring all document changes?
A. Edit document
B. Monitor change
C. Track change
D. Track all

36. Shortcut key combination Ctrl+Shift+C is for
A. Copy text with format
C. Copy text format
B. Copy paragraph format
D. Copy format

37. In Ms. Word, the key f12 opens a….. dialog box.
A. Save as
B. Open
C. Save
D. Close

38. Small squares, called …., on the selection rectangle that surrounds a graphic can be used to change the dimensions of the graphic.
A. Scroll boxes
B. Sizing handles
C. Status indicators
D. Move handles’

39. Which of the following is not a font style?
A. Bold
B. Italics
C. Regular
D. Superscript

40. Which of the following is not one of the three ‘mail merge helper’ steps?
A. Merge the two files
B. Create the main document
C. Set the mailing list parameters
D. Create the data source

41. Which of the following options is not options in the print dialog box.
A. Print selected pages
B. Print selected text C. Set the paper orientation
D. Collate copies

42. short cut key for manual column break in MS word is.
A. Ctrl+Enter
B. Shift+Spacebar
C. Ctrl+Shift+Enter
D. Alt+Enter

43. Background color or effects applied on a document is not visible in.
A. Web layout view
B. Print layout view
C. Reading view
D. Print preview

44. In excel sheet…refers a range from B1 through E5
A. B1-E5
B. B1:E5
C. B1 to B5
D. B1$E5

45. what does the VLOOKUP function do.
A. Looks up text that contain
B. Checks whether text is the same in one cell as in the text
C. Finds related records
D. All of the above

46. which one is not function in MS excel.
A. Sum
B. Avg
C. Max
D. Min

47.what is the short cut key to replace a data with another in sheet.

A. Ctrl+R
B. Ctrl+Shift+R
C. Ctrl+H
D. Ctrl+F

48. Which of the following formulas results 4.
A. If (10<1,5,4)
B. Power (2,2)
C. Both a and b
D. None of the above

49. Except for the…….. Function, a formula with a logical function shows the word “true” or “false” as a result
A. If
B. And
C. Or
D. Not

50. What is the result of formula”-max (min (5,4,10)), max (3,2,2)”?
A. 5
B. 4
C. 10
D. 3

Notes:

1. Computer Operator Quiz Link

2. Computer Operator MCQ Link

3. Computer Operator Subjective Question Collection Link

4. NEB Computer Operator Preparation Link

Leave a Reply

Your email address will not be published. Required fields are marked *