Karnali Pradesh-8 – Computer Operator

Created by

Sanjaya Karki

Computer Operator

Karnali Pradesh (New Model)

35 Questions

1 / 35

31. What does the VLOOKUP function do?

a) Looks up text that contain ‘v’ .

b) Checks whether text is the same in one cell as in the next.

c) Finds related records .

d) All of above.

2 / 35

9. ……… are set of rules and procedures to control the data transmission over the internet

a) IP address

b) Gateway

c) Domains

d) Protocol

3 / 35

17. Note pad is used for

a) Only text files.

b) Format layout and print.

c) HTML text storage.

d) Temporary storage.

4 / 35

40. When a picture or other graphic image is placed in the report header section it will appear:

a) Once in the beginning of the report.

b) At the top of every page.

c) Every after record break.

d) On the 1st and last pages of the report.

5 / 35

12. The personal computer industry was started by

a) IBM

b) Apple

c) Compaq

d) HCL

6 / 35

41. Which of the following database object hold data?

a) Forms

b) Reports

c) Queries

d) Tables

7 / 35

4. What was the expected feature of fifth generation computers when Japan started FGCS?

a) Operating Systems

b) Parallel Processing

c) ULSI

d) None of above

8 / 35

25. When typing in a word field manually, what must you press to insert the code’s braces?

a) Ctrl + F6

b) Ctrl + F9

c) Alt + F11

d) Shift + F12

9 / 35

19. Which of the following enables you to paste data multiple times?

a) Office clipboard

b) Windows Clipboard

c) Both of above

d) None of above

10 / 35

25. In mail merge operation which of the following might represent the main document?

a) A sales brochure.

b) A form letter.

c) A database of Names and Addresses.

d) All of above.

11 / 35

31. Which of the following will not cut information?

a) Pressing Ctrl + C.

b) Selecting Edit>Cut from the menu.

c) Clicking the Cut button on the standard.

d) Pressing Ctrl+X

12 / 35

18. The … operating system was initially created in the early 1970s at AT and T’s Bell Labs

a) Linux

b) DOS

c) Unix

d) GNU

13 / 35

34. You can group noncontiguous worksheets with

a) The group button on the standard toolbar.

b) The shift key and the mouse .

c) The ctrl key and mouse.

d) The alt+enter key.

14 / 35

10. A storage area used to store data to compensate for the difference in speed at which the different units can handle data is

a) Memory

b) Buffer

c) Accumulator

d) Address

15 / 35

24. How will MS Word will respond in repeated word.

a) A Red wavy line under the repeated word.

b) A Green wavy line under the repeated word.

c) A Blue wavy line under the repeated word.

d) None of the above.

16 / 35

50. To create HTML document you require a

a) web page editing software.

b) High powered computer.

c) Just a notepad can be used.

d) None.

17 / 35

14. Floppy disks typically in diameter

a) 3.5

b) 5.25

c) 8

d) All of above

18 / 35

29. ...............Each time the key is pressed, the paragraph formatting in the previous paragraph is carried forward
to the next paragraph.

a) Enter

b) Shift

c) Ctrl

d) Alt

19 / 35

29. Which of the following is not on Home ribbon?

a) Columns

b) Font color

c) Change Style

d) Font

20 / 35

22. Ctrl + O

a) Save Document

b) Print Document

c) Close Document

d) Open Document

21 / 35

4. An approach that permits the computer to work on several programs instead of one is

a) On-line thesaurus

b) Multiprogramming

c) Over lapped processing

d) Outline processor

22 / 35

6. Which of the following is handy to carry large amounts of data?

a) Floppy disk

b) Hard disk

c) CDROM

d) Zip disk

23 / 35

44. The size of Yes No field is always

a) 1 bit

b) 1 byte

c) 1 character

d) 1 GB

24 / 35

37. When you copy a formula

a) Excel erases the original copy of the formula.

b) Excel edits cell references in the newly copied formula.

c) Excel adjusts absolute cell references.

d) Excel doesn’t adjust relative cell references.

25 / 35

5. The brain of a computer system is

a) ALU

b) Memory

c) CPU

d) Control unit

26 / 35

33. Which of following is not one of Excel’s what-if function?

a) Goal seek

b) Solver

c) Scenario manager

d) Auto Outline

27 / 35

40. How can you define a field so that when entering data for that field it will display ****** instead of actual typed text.

a) Input mask

b) Validation Rule

c) Indexed

d) IME Mode

28 / 35

42. To create relationship between two tables

a) drag the primary key of a table into foreign key of another table.

b) drag the foreign key of a table into the primary key of another table.

c) drag any field from parent table and drop on child table.

d) Any of above can be done to create relationship.

29 / 35

46. Which option can be used to set custom timings for slides in a presentation?

a) Slider Timings

b) Slider Timer

c) Rehearsal

d) Slide Show Setup

30 / 35

15. Which type of command requires additional files to perform specific operations?

a) Internal commands

b) External commands

c) Valuable commands

d) Primary commands

31 / 35

19. The ….. Program compresses large files into a smaller file.

a) WinZip

b) WinShrink

c) WinStyle

d) None of above

32 / 35

47. Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide?

a) Color Schemes

b) Animation

c) Transition Settings

d) Handouts

33 / 35

7. What is the responsibility of the logical unit in the CPU of a computer?

a) To produce result.

b) To compare numbers.

c) To control flow of information.

d) To do math’s works.

34 / 35

49. How can you make a numbered list?

a) <dl>

b) <ol>

c) <list>

d) <ul>

35 / 35

39. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:

a) Press the Erase key.

b) Press Esc.

c) Press the Enter button.

d) Press the Edit Formula button.

Your score is