Karnali Province, Assistant Computer Operator, 2079/03/29

Province Public Service Commission,

Karnali Province

Miscellaneous Services, Assistant Level 4th Level, Open Competitive Written Examination for the post of Assistant Computer Operator

Date: 2079.03.29

1. ........... tool in word is used to apply same format to different character or paragraph.
A. Format aligner
B. Format poster
C.Format painter
D. Format generator

2. Table of contents in MS-Word is based on
A. Bullets and Numbering
B. Heading Level
C. Font Size
D. None of the above

3. Which operation is used to move a block of text?
A. Copy and Paste
B. Paste and Delete
C. Cut and Paste
D. Paste and Cut

4. Absolute cell reference can be represented as ...........
A. B$3$
B. B3
C. B$3
D. $B3

5. To edit a cell content in excel we use .............
A. F10
B. F12
C. F2
D. F3

6. What happens when a numeric data entered in a cell exceeds the width size of the column?
A. Number is wrapped in cell width
B. Column width changes
C. Data is displayed in exponential form
D. Error Message

When a numeric data entered in a cell exceeds the width size of the column, the answer depends on the settings of the cell and column.

 

By default, Excel displays a series of number signs (####) to indicate that the cell content is too wide for the column. This is option D. Error Message.

However, the behavior can be changed through cell formatting options. If the cell is set to wrap text, the content may be displayed on multiple lines within the cell (option A. Number is wrapped in cell width). Alternatively, if the column width is adjusted to accommodate the wider content, the column width will change (option B. Column width changes). The option C. Data is displayed in exponential form does not directly relate to the situation of exceeding the width size of the column.

7.  Getting data from a cell located in a different sheet is called
A. Accessing
B. Referencing
C. Updating
D. Functioning

8. .............. is used to display only the rows that meet certain conditions and the others
rows get hidden.
A. Filter
B. Sort
C. None of the above
D. Both of the above

9. Which of the following is not a built-in date time function?
A. Now()
B. Today ()
C. Date()
D. DateTime()

10. Suppose cell value in A4 is 20, what will be output of formula "IF(A4<10,5,7)"?
A. 0
B. 10
C. 5
D. 7

11. Which chart type best suits for comparing values over categories?
A. Column Chart
B. Pie Chart
C. Scatter Chart
D. Line Chart

12. In MS Access, What is the maximum length of a text field?
A. 265
B. 260
C. 255
D. 250

13. A primary key field included in another table is known as
A. Foreign key
B. Parent key
C. Child key
D. Parasite key

14. Function which causes retrieval of any database is considered as .....
A. Key
B. Query
C. Structure
D. Storing cycle

15........is not a valid data type in MS Access.
A. Auto number
B. Currency
C. Memo
D. Picture

16. What view in Power Point lets you see your slides on the screen in a grid that makes it easy to reorganize them, or organize them into sections, just by dragging and dropping them where you want them?
A. Slide Sorter
B. Notes Page
C. Normal
D. Slide Show

17. What Power point feature do you use to apply motion effects to different slide objects?
A. Slide Transition.
B. Animation Scheme
C. Animation Object
D. Slide Design

18. Which feature allows us to view slides in a slide show without manually advancing each slide?
A. Adding build effect
B. Setting Animation
C. Adding Transition
D. Adding bullets

19. The basic computer architecture was developed by.......
A. Charles Babbage
B. John Von Neumann
C. Blaise Pascal
D. Garden Moore

20. Self-replicating malware that duplicates itself to spread to uninfected computers is
called.......
A. Spam
B. Worm
C. Replicator
D. Duplicator

21. Which generation of computers is Artificial Intelligence associated with?
A. Second Generation
B. First Generation
C. Fifth Generation
D. Fourth Generation

22. What does a video consist of?
A. Frames
B. Signals
C. Packets
D. Slots

23. Which of the following  is object-oriented programming language?
A. C
B. Java
C. Pascal
D. COBOL

24. Which of the following topology is formed when computers are networked with a switch?
A. Bus topology
B. Ring topology
C. Star topology
D. Mesh topology

25. Who issues Digital Signature Certificate to general public?
A. Root Certificate
B. Certifying Authority
C. SSL Certificate Issuer
D. National Information Technology Centre

26. 2 Kilobyte is equivalent to
A. 2048 bytes
B. 2024 bytes
C. 2000 bytes
D. 1024 bytes

27. Which of the following technology is used to implement private network over public networks?
A. WAN
B. MAN
C. SAN
D. VPN

28. Which of the following is a correct IPV4 Address?
A. 01.200.128.123
B. 300.143.211.64
C. 123.202.30.1.52
D. 128.64.0.0

29. Which of the following is a single user Operating System?
A. Windows
B. MS-DOS
C. MAC OS
D. Linux

30. Which command is used to fix the minor errors of the disk?
A. FDISK
B. FORMAT
C. CHKDSK/f
D. ATTRIB

31........ uses technique to increase data access speed by rearranging files stored on a disk to occupy contiguous storage locations.
A. Scandisk
B. Disk Defragmenter
C. Disk Management
D. Disk Format.

32. Which of the following is used for quick access to commonly used commands and tools?
A. Status Bar
B. Tool Bar
C. Menu Bar
D. Title Bar

33. What is the short cut to justify text to center?
A. CTRL+A
B. CTRL+B
C. CTRL+D
D. CTRL+E

34. Autocorrect was originally designed to replace ......... words as you type.
A. misspelled
B. grammatically incorrect
C. Short, repetitive
D. long, repetitive

35. Footnotes, endnotes and indexes are inserted in a document as ..........
A. Bookmarks
B. Cross-references
C. Hyperlinks
D. Word fields

Group-B

1. What is Computer System? How does the Computer System work? Explain with suitable block diagram.
=  Computer System:

          A computer system is a combination of hardware and software components that work together to perform various tasks. It consists of input devices, output devices, a central processing unit (CPU), memory, storage devices, and software. The hardware components receive input, process it using the CPU, and produce output through the output devices. The software provides the instructions and programs necessary for the computer system to perform specific tasks.

 

Block Diagram of a Computer System:

          A block diagram represents the components of a computer system and their connections. Here is a simplified block diagram of a computer system:

        +-------------------+

        |    Input Devices |

        +-------------------+

                    |

        +-------------------+

        |    Central           |

        |    Processing     |

        |    Unit (CPU)    |

        +-------------------+

                    |

        +-------------------+

        |      Memory       |

        +-------------------+

                    |

        +-------------------+

        |    Storage          |

        |    Devices         |

        +-------------------+

                      |

        +-------------------+

        | Output Devices |

        +-------------------+

- Input Devices: These devices, such as keyboard and mouse, allow users to provide input to the computer system.

- Central Processing Unit (CPU): The CPU is the brain of the computer that executes instructions and performs calculations.

- Memory: It stores data and instructions that are currently being processed by the CPU. It includes RAM (Random Access Memory) and cache memory.

- Storage Devices: These devices, like hard drives and solid-state drives, provide long-term storage for data and programs.

- Output Devices: Devices like monitors and printers display or present the results of the computer's processing.

The computer system works by receiving input from the user through input devices, processing the input using the CPU and memory, accessing data and instructions from storage devices, and producing output through output devices. The software provides the necessary instructions for the CPU to perform specific tasks, and the hardware components facilitate the execution of those instructions.

2. Make a list of any ten MS-DOS commands with their functions.
= Here are ten MS-DOS commands with their functions:

1. DIR: Lists the files and directories in the current directory.

2. CD: Changes the current directory.

3. MD: Creates a new directory.

4. RD: Removes an empty directory.

5. COPY: Copies files from one location to another.

6. DEL: Deletes files.

7. REN: Renames files.

8. TYPE: Displays the contents of a text file.

9. FORMAT: Formats a disk or drive.

10. CHKDSK: Checks a disk for errors and displays a status report.

3. What is the difference between a Word Processor System and Electronic Spreadsheet? Give few application of each.

= Difference between a Word Processor System and Electronic Spreadsheet:

Word Processor System:

- A word processor system is designed for creating, editing, formatting, and printing textual documents.

- It focuses on manipulating text and provides features like spell checking, formatting options, page layout, and document organization.

- Applications: Writing letters, reports, essays, creating resumes, etc.

 

Electronic Spreadsheet:

- An electronic spreadsheet is used for organizing, analyzing, and calculating numerical data.

- It consists of cells organized in rows and columns, allowing for mathematical formulas, data manipulation, and data visualization.

- Applications: Budgeting, financial analysis, data management, creating charts and graphs, etc.

 

Both word processor systems and electronic spreadsheets are productivity tools commonly used in office environments. They serve different purposes and have distinct features tailored to specific tasks.

Best of Luck!

Post a Comment (0)
Previous Post Next Post

ADS 1

ADS 2