Karnali Province, Computer Operator 2080/02/08

 

Karnali Province

Assistant Computer Operator 

2080/02/08

Part A: Objective Questions       35x1=35 Marks

1. Which statement is FALSE regarding the recycle bin?

a. You can find deleted files in recycle bin

b. Yu can restore any file in recycle bin if you ever need

c. You can increase free space of disk by sending files in recycle bin

d. You can right click and choose empty recycle bin to clean it at once

2. In DOS, which command is used to clear the screen and display the prompt?

a. Clear

b. Erase

c. Cls

d. Flush

3. Which windows feature lists the application running on your computer?

a. Disk defragmenter

b. Disk monitor

c. Program and feature

d. Task manager

4. Indentation in computer word processing is used to

a. Make the text readable

b. Change the paragraph color

c. Apply border around text

d. Change line spacing

5. Which of the following is not necessary to perform a mail-merge operation?

a. Main document

b. Word fields

c. Data source

d. Merge files

6. Which of the following is printed at the bottom of each page?

a. Footer

b. Watermark

c. Footset

d. Bottom section

7. To assign a name to specific location in a document we use__

a. Go to

b. Page setup

c. Bookmark

d. Macro

8. Portrait and landscape are__

a. Page size

b. Page orientation

c. Page layout

d. Page setups

9. Word wrap feature__

a. Sets text inside the fixed margin

b. Appears at the bottom of the document

c. Marks the paragraph center

d. Applies border around text

10. Which key is used to check for spelling and grammar?

a. F3

b. F5

c. F7

d. F9

11. What is the cell address for a cell in 4^th row and 3^rd column?

a. C4

b. 4C

c. 3D

d. D3

12. The process of arranging the items of a column in some sequences or order is known as

a. Sorting

b. Filtering

c. Pivoting

d. Forecasting

13. __is getting data from a cell in different sheet.

a. Referencing

b. Functioning

c. Updating

d. Accessing

14. Which of the following represent absolute cell reference?

a. B3

b. $B$3

c. B$3

d. $B3

15. Which of the following is not a logical operator?

a. =>

b. <=

c. =

d. +

16. Which chart would be better to track the progress of the stock market on a daily basis?

a. Pie chart

b. Row chart

c. Line chart

d. Column chart

17. In Electronic spreadsheet. SUM, AVERAGE, MIN and MAX are example of

a. Functions

b. Calculations

c. Formulas

d. Expressions

18. To highlight only cells in a range having a greater than or less specify value, we can use

a. Data validation

b. Conditional formatting

c. What if analysis

d. Consolidate

19. Which of the following is not the data type in MS Access

a. Number

b. Date

c. Text

d. Identifier

20. Which of the command can be used to modify a column in a table?

a. Alter

b. Update

c. Set

d. Create

21. In MS Access, you can use a___to answer a simple question, to perform calculations to combine data form the different tables, or even to add, change or delete table data.

a. Query

b. Forms

c. Pivot chart

d. Report

22. A search value in SQL query can be a specific value or it can be__

a. Comparison operator

b. Logical operator

c. Relationship

d. Wild card character

23. You want to create a new presentation by selecting ready-made font color and graphics. What do you use?

a. Base template

b. Master slide theme

c. Design template

d. Master template

24. Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides?

a. Slide master

b. Slide show

c. Slide sorter

d. Notes page

25. On which of the following the animation is applied?

a. Slides

b. Objects

c. Views

d. Designs

26. Boot sequence is changed from__

a. Setting

b. Control panel

c. Taskbar

d. BIOS

27. Text is captured by scanner with

a. Keyboard

b. Mouse

c. Input hardware

d. Optical character recognition

28. What is the address given to a computer connected to a network called?

a. Network address

b. Routing address

c. IP address

d. DNS address

29. __is a collection of data, programs, procedures and instructions then tell a computer or electronic device how to run, work and execute specific tasks.

a. Hardware

b. Network

c. Software

d. System

30. Which of the following is a valid encoding format?

a. UTF-1

b. UTF-A

c. UTF-8

d. UTF-10

31. Which of the following is a light sensitive device that converts drawing, printed text or other image into digital form?

a. Keyboard

b. Plotter

c. Scanner

d. OMR

32. __is a type of software that is embedded directly into a piece of hardware.

a. Firmware

b. Cache 

c. Operating system

d. Middle ware

33. __is the ratio of the horizontal length to the vertical length in Monitor.

a. Aspect ratio

b. Contrast

c. Resolution

d. Interlacing

34. What does a collection of hyperlink documents on the internet form?

a. World Wide Web(WWW)

b. E-mail system

c. Hypertext Markup Language(HTML)

d. Intranet

35. ___is a network security device that monitors and filters incoming and outgoing network traffic based on an organization's previously established security policies.

a. Switch

b. Router

c. Firewall

d. Server

Part B: Subjective Questions

1. Briefly explain common security threats in computer system.

2. What is an operating system? Explain in detail the functions of an operating system.

3. Briefly explain about any five built-in-functions in MS Excel.