Karnali Pradesh-8 – 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

34. When you insert an excel file into a word document. The data are

a) Hyperlinked placed in a word table.

b) Linked.

c) Embedded.

d) Use the word menu bar and toolbars.

3 / 35

44. A.............enables you to view data from a table based on a specific criterion.

a) Form

b) Query

c) Macro

d) Report

4 / 35

11. Artificial Intelligence is associated with which generation?

a) First Generation

b) Second Generation

c) Fifth Generation

d) Sixth Generation

5 / 35

45. To insert new slide in the current Presentation, we can choose:

a) Ctrl+N

b) Ctrl+M

c) Ctrl+O

d) Ctrl+F

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

7 / 35

33. Rounding errors can occur

a) When you use multiplication, division, or exponentiation in a formula.

b) When you use addition and subtraction in a formula.

c) Because excel uses hidden decimal places in computation.

d) When you show the results of formulas with different decimal places that the calculated results.

8 / 35

50. Marquee is a tag in HTML to

a) Mark the list of items to maintain in queue.

b) Mark the text so that it is hidden in browser.

c) Display text with scrolling effect.

d) None of above.

9 / 35

43. Which of the following is not a type of relationship that can be applied in Access database.

a) One to One.

b) One to Many.

c) Many to Many.

d) All of above can be applied.

10 / 35

18.A ......…. is a named location on a disk where files are stored.

a) Folder

b) Pod

c) Version

d) None of the above

11 / 35

6. Which of the following is not a primary storage device?

a) Magnetic tape

b) Magnetic disk

c) Optical disk

d) All of the above.

12 / 35

28. Which key is used to increase left indent?

a) Ctrl+I

b) Ctrl+M

c) Alt+I

d) F10

13 / 35

34. Which of the following formulas will Excel Not be able to calculate?

a) =SUM(Sales)-A3

b) =SUM(A1:A5)*.5

c) =SUM(A1:A5)/(10-10)

d) =SUM(A1:A5)-10

14 / 35

6. Which of the following memory medium is not used as main memory system?

a) Magnetic core

b) Semiconductor

c) Magnetic tape

d) Both a & b

15 / 35

22. What is the shortcut key to "Center Align" the selected text?

a) Ctrl + C

b) Ctrl + E

c) Ctrl + F

d) None of above

16 / 35

27. What do you call ‘a collection of character and paragraph formatting commands’?

a) the defaults

b) a template

c) a style

d) a boilerplate

17 / 35

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

a) Ctrl+L

b) Ctrl+E

c) Ctrl+1

d) Ctrl+M

18 / 35

35. Which of the following is not information you can specify using the solver?

a) Input cells.

b) Constraint.s

c) Target cell.

d) Changing cells.

19 / 35

4. Surgeons can perform delicate operation by manipulating devices through computers instead of manually. This technology is known as

a) Computer Forensics.

b) Robotics.

c) Forecasting.

d) Simulation.

20 / 35

44. The database language that allows you to access or maintain data in a database

a) DCL

b) DML

c) DDL

d) None of above

21 / 35

47. ....................controls all the main slide control tasks for your presentation.

a) Task Pane.

b) Taskbar.

c) Control Panel.

d) None of above.

22 / 35

5. Interface electronic circuit is used to interconnect I/O devices to a computer’s CPU or

a) ALU

b) Memory

c) Buffer

d) Register

23 / 35

12. If you want to include YouTube video inside webpage ?

a) <iframe>

b) <youtube>

c) <include>

d) None of the above

24 / 35

4. 1 Octet is .....…?

a) 8bit

b) 4bit

c) 16bit

d) 2 byte

25 / 35

36. How many characters can be typed in a single cell in Excel?

a) 256

b) 1024

c) 32767

d) 65535

26 / 35

11. What was the name of the first commercially available microprocessor chip?

a) Intel 308.

b) Intel 33.

c) Intel 4004.

d) Motorola 639.

27 / 35

9. Tool which help to ensure that data can be made available from another part if there is some error is known as

a) Backup.

b) Scandisk.

c) Defragmentation.

d) Format.

28 / 35

23. What is the default font used in MS Word 2007 document?

a) Times New Roman

b) Arial

c) Calibri

d) Preeti

29 / 35

14. The number of pixels displayed on a screen is known as the screen

a) Colour depth

b) Refresh rate

c) Resolution

d) Viewing size

30 / 35

9. Programs designed to perform specific task is known as

a) System software.

b) Application software.

c) Utility programs.

d) Operating system.

31 / 35

3. Number crunchier is the informal name for

a) Mini computer

b) Super computer

c) Micro computer

d) Mainframe computer

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

33 / 35

11. Asynchronous communication is

a) a) Communication between dependent operating units.

b) Communication between independent operating units.

c) Communication between independent and dependent operating units.

d) Communication within similar operating system.

34 / 35

44. When entering field name, how many characters you can type in maximum?

a) 60

b) 64

c) 68

d) Any number of character

35 / 35

21. How can you increase the font size of selected text by one point every time?

a) By pressing Ctrl + ]

b) By pressing Ctrl + [

c) By pressing Ctrl + }

d) By pressing Ctrl + {

Your score is