Karnali Pradesh-7 – Computer Operator

Created by

Sanjaya Karki

Computer Operator

Karnali Pradesh (New Model)

35 Questions

1 / 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.

2 / 35

2. The unit of hardware an operator uses to monitor computer processing is

a) Card Reader.

b) Line printer.

c) Console.

d) CPU.

3 / 35

33. What displays the content of the active cell in excel?

a) Name box

b) Formula bar

c) Task pane

d) Row headings

4 / 35

49. HTML documents are saved in

a) Special binary format.

b) Machine language codes.

c) ASCII text.

d) None of above.

5 / 35

36. Which of the following is a popular DOS based spreadsheet package?

a) Word

b) Smart cell

c) Excel

d) Lotus 1-2-3

6 / 35

9. The difference between memory and storage is that memory is…....... and storage is….......

a) Temporary, Permanent

b) Permanent, temporary

c) Slow, fast

d) All of the above

7 / 35

25. What is the maximum number of lines you can set for a drop cap?

a) 3

b) 10

c) 15

d) 20

8 / 35

26. Which is not a data source component?

a) mail merge toolbar

b) header row

c) data fields

d) data records

9 / 35

35. Concatenation of text can be done using

a) Apostrophe (')

b) Exclamation (!)

c) Hash (#)

d) Ampersand (&)

10 / 35

9. What is the name of the display feature that highlights area of the screen which requires operator attention?

a) Pixel

b) Reverse video

c) Touch screen

d) Cursor

11 / 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.

12 / 35

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

a) Left

b) Right

c) Center

d) Top

13 / 35

33. Which of the following formulas is not entered correctly?

a) =10+50

b) =B7*B1

c) =B7+14

d) 10+50

14 / 35

14. A paper printout of a document is known as

a) Softcopy output

b) Hardcopy output

c) Permanent Output

d) All of above

15 / 35

18. Which command will you use to transfer a specific file(s) from one disk to another in MS-DOS?

a) COPY

b) DISKCOPY

c) TIME

d) RENAME

16 / 35

26. To increase a paragraph indent, use the .............. shortcut keys.

a) Ctrl+L

b) Ctrl+E

c) Ctrl+1

d) Ctrl+M

17 / 35

42. Consider the following table Student (roll no, name, grade, subject). Which SQL is correct to retrieve the name of all students having grade "B" (PSC 2067)

a) SELECT name FROM students WHERE grade IN "B" .

b) SELECT name FROM students WHERE grade="B".

c) SELECT name FROM STUDENTS .

d) Both B and C.

18 / 35

47. Which of the following font effect is not available in PowerPoint Font dialog box? (2003)

a) Underline

b) Shadow

c) Emboss

d) Strikethrough

19 / 35

36. Comments put in cells are called

a) Smart tip.

b) Cell tip.

c) Web tip.

d) Soft tip.

20 / 35

30. to view a cell comment

a) click the edit comment command on the insert menu.

b) click the display comment command on the window menu.

c) position the mouse pointer over the cell.

d) click the comment command on the view menu.

21 / 35

7. A name or number used to identify a storage location is called

a) A byte

b) A record

c) An address

d) All of the above

22 / 35

10. The ability to recover and read deleted or damaged files from a criminal's computer is an example of a law enforcement specially called

a) Animation

b) Robotics

c) Computer forensics

d) Simulation

23 / 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

24 / 35

19. A system program that combines the separately compiled modules of a program into a form suitable for execution.

a) cross compiler

b) load and go

c) linking loader

d) assembler

25 / 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

26 / 35

24. What is the default number of lines to drop for drop cap ?

a) 3

b) 10

c) 15

d) 20

27 / 35

15. If there are multiple recycle bin for a hard disk

a) you can set different size for each recycle bin.

b) you can choose which recycle bin to use to store your deleted files.

c) You can make any one of them default recycle bin.

d) None of above.

28 / 35

43. When creating a new table which method can be used to choose fields from standard databases and tables?

a) Create table in Design View.

b) Create Table using wizard.

c) Create Table by Entering data.

d) None of above.

29 / 35

48. Tags and text that are not directly displayed on the page are written in ….... section.

a) <html>

b) <body>

c) <title>

d) <head>

30 / 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.

31 / 35

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

a) Columns

b) Font color

c) Change Style

d) Font

32 / 35

2. Who was the invented of the Transistor?

a) Charles Walter

b) William Shockley

c) Jacquard

d) Herman Hollerith

33 / 35

4. Which of the following terms is the most closely related to main memory?

a) Non-volatile

b) Permanent

c) Control unit

d) Temporary

34 / 35

13. Base band is

a) transmission of signals without modulation.

b) signal all of whose energy is contained within a finite frequency range.

c) the simultaneous transmission of data to a number of stations.

d) all.

35 / 35

29. You need to jump to the next column breaking current column right at the cursor position. How can you break column?

a) Pressing Ctrl+Enter.

b) Pressing Alt+Shift+Enter.

c) Break command from Insert menu.

d) Both b and c.

Your score is