Karnali Pradesh-5 – Computer Operator

Created by

Sanjaya Karki

Computer Operator

Karnali Pradesh (New Model)

35 Questions

1 / 35

31. What does the SUMIF function do?

a) Returns a subtotal in a list or database.

b) All of the above.

c) Adds all the values based on a condition.

d) Adds all the numbers in a range of cells.

2 / 35

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

a) WinZip

b) WinShrink

c) WinStyle

d) None of above

3 / 35

25. Which key do you press to force a page break?

a) CTRL+ALT

b) CTRL+ break

c) CTRL+ Enter

d) none of the above

4 / 35

34. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

a) Option buttons

b) List boxes

c) Text boxes

d) Combo boxes

5 / 35

41. To sort records in a table

a) Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar.

b) Open table, click Sort button on database toolbar, choose field based on which to sort, click OK.

c) Click the field heading to sort it ascending or descending.

d) All of above.

6 / 35

19. Which of the following network device forwards frames based on MAC address?

a) Hub

b) Switch

c) Router

d) Gateway

7 / 35

12. Which operation is not performed by computer ?

a) Inputting

b) Processing

c) Controlling

d) Understanding

8 / 35

1. HTTP is

a) None

b) Link of hypertext.

c) A designation with URL that indicates hypertext resource.

d) Address of URL.

9 / 35

34. Which of the following function is used to if found the type of data in cell ?

a) Format

b) Cell value

c) Data type

d) Type

10 / 35

33. When you link data maintained in excel workbook to a word document

a) The word document must contain a hyperlink .

b) The word document contains a reference to the original source application.

c) The word document contains a copy of the actual data.

d) The word document cannot be edited.

11 / 35

28. Ctrl + A

a) Align Right

b) Select All

c) Change font

d) Save document

12 / 35

3. Which is not a computer of first generation?

a) ENIAC

b) UNIVAC

c) IBM 650

d) IBM 1401

13 / 35

5. Which of the following is a way to access secondary memory?

a) Random access.

b) Action method.

c) Transfer method.

d) Density method.

14 / 35

40. Referential integrity means

a) Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table.

b) Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table.

c) Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table.

d) All of above.

15 / 35

30. Documentation should include

a) Destination and users of the output data.

b) Source of input data.

c) Information on the purpose of the workbook.

d) All of the above.

16 / 35

13. Fifth generation computer is also known as ?

a) Knowledge information processing system

b) Very large scale integration (VLSI)

c) Both of above

d) None of above

17 / 35

43. In a relational schema, each tuple is divided into fields called

a) Queries

b) Domains

c) All

d) Relations

18 / 35

33. Which of the following is not a valid data type in excel?

a) Number

b) Character

c) Label

d) Date/time

19 / 35

22. Text boundary can be displayed or hidden from (word 2003)

a) Auto text option from Insert menu

b) Options from Tools menu

c) Customize from Tools menu

d) All of above

20 / 35

40. Which field type will you select when creating a new table if you require to enter long text in that field?

a) Text

b) Memo

c) Currency

d) Hyperlink

21 / 35

12. Who is created with the idea of using punch cards to control pattern s in a weaving machine?

a) Pascals

b) Hollerith

c) Babbage

d) Jacquard

22 / 35

18. Which is not related to the size of paper?

a) Executive

b) A3

c) Exclusive

d) Legal

23 / 35

49. Which of the following is not a body tag properties?

a) image

b) bgcolor

c) text

d) background

24 / 35

17. Note pad is used for

a) Only text files.

b) Format layout and print.

c) HTML text storage.

d) Temporary storage.

25 / 35

26. Which is not a data source component?

a) mail merge toolbar

b) header row

c) data fields

d) data records

26 / 35

19. Which command is used to see the version of operating system?

a) Vol

b) Version

c) Ver

d) None of the above

27 / 35

3. The silicon chips used for data processing are called

a) RAM chips.

b) ROM chips.

c) Micro processor.

d) PROM chips.

28 / 35

29. Text-styling feature of MS word is

a) WordColor

b) WordFont

c) WordArt

d) WordFill

29 / 35

41. A form can be used as a

a) Data entry

b) Custom dialog box

c) Switchboard

d) All

30 / 35

18. Operating system is also known as:

a) Database

b) system software

c) hardware

d) printer

31 / 35

2. Which of the following is first generation of computer?

a) CDC-1604

b) IBM-1401

c) ICL-2900

d) EDSAC

32 / 35

2. The process of starting or restarting a computer system by loading instructions from a secondary storage device into the computer memory is called

a) Duping

b) Booting

c) Padding

d) All of the above

33 / 35

7. An integrated circuit is

a) A complicated circuit.

b) An integrating device.

c) Much costlier than a single transistor.

d) Fabricated on a tiny silicon chip.

34 / 35

23. The minimum number of rows and columns in MS Word document is

a) 1 and 1

b) 2 and 1

c) 2 and 2

d) None of above

35 / 35

45. Which tab is not available on left panel when you open a presentation?

a) Outline.

b) Slides.

c) Notes.

d) All of above are available.

Your score is