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!