Computer Operator Questions and Answers SET - 4 | MCQs | PSC

Computer Operator Model Question Set - 4

1. IBM 1401 was brought to prepare the census report of …………………..

a. 2018 BS

b. 2028 BS

c. 2038 BS

d. 2048 BS

Correct Answer: b. 2028 BS
Explanation: The IBM 1401 was used for the census report in Nepal in 2028 BS (Bikram Sambat), which corresponds to 1971 AD.

2. Transistor is related to ………………….. generation computers.

a. Second

b. Third

c. Fourth

d. Fifth

Correct Answer: a. Second
Explanation: Transistors were used in second-generation computers (1956–1963), replacing vacuum tubes for improved efficiency.

3. The ability to recover and read deleted or damaged files from a criminal’s computer is an example of a law enforcement specialty called.

a. Robotics

b. Simulation

c. Computer forensics

d. Animation

Correct Answer: c. Computer forensics
Explanation: Computer forensics involves recovering and analyzing digital evidence for legal purposes.

4. An area of a computer that temporarily holds data waiting to be processed is …………………..

a. CPU

b. Memory

c. Storage

d. File

Correct Answer: b. Memory
Explanation: Memory (RAM) temporarily holds data for processing, unlike storage, which is permanent.

5. For reproducing sound, a CD (Compact Disc) audio player uses a …………………..

a. Quartz crystal

b. Titanium needle

c. Laser beam

d. Barium titanium ceramic

Correct Answer: c. Laser beam
Explanation: CD players use a laser beam to read digital data encoded on the disc’s surface.

6. Unicode standard is …………………..

a. Software

b. Font

c. Character encoding system

d. Keyboard layout

Correct Answer: c. Character encoding system
Explanation: Unicode is a universal character encoding standard for representing text across languages.

7. A fault in a computer program which prevents it from working correctly is known as

a. Boot

b. Bug

c. Biff

d. Strap

Correct Answer: b. Bug
Explanation: A bug is an error or flaw in a program that causes incorrect behavior.

8. Program developed according to the requirement specific to an office is …………………..

a. Tailored software

b. Utility software

c. Packaged software

d. All of the above

Correct Answer: a. Tailored software
Explanation: Tailored software is custom-developed to meet specific organizational needs.

9. The difference between people with access to computers and the Internet and those without this access is known as the:

a. Digital divide

b. Internet divide

c. Web divide

d. E-illiteracy

Correct Answer: a. Digital divide
Explanation: The digital divide refers to the gap between those with and without access to digital technology.

10. Cache Memory …………………..

a. Helps to store more data in hard disk

b. Placed between main memory and microprocessor

c. Stores data permanently

d. Holds last time visited web site only

Correct Answer: b. Placed between main memory and microprocessor
Explanation: Cache memory is a high-speed memory located between the CPU and main memory to speed up data access.

11. Which one of the following printers is suitable for printing sprocket fed carbon copies?

a. Laser

b. Dot matrix

c. Ink-Jet

d. Drum

Correct Answer: b. Dot matrix
Explanation: Dot matrix printers use impact printing, suitable for carbon copies with sprocket-fed paper.

12. ………………….. are set of rules and procedures to control the data transmission over the internet

a. IP address

b. Domains

c. Protocol

d. Gateway

Correct Answer: c. Protocol
Explanation: Protocols are rules governing data transmission over the internet, e.g., HTTP, TCP/IP.

13. Which of the following is a file attribute?

a. Hidden

b. Archive

c. Read only

d. All of the above

Correct Answer: d. All of the above
Explanation: Hidden, Archive, and Read-only are all file attributes in operating systems.

14. ………………….. are used to identify a user who returns to a Website

a. Cookies

b. Plug-ins

c. Scripts

d. Session

Correct Answer: a. Cookies
Explanation: Cookies are small files stored on a user’s device to track and identify returning visitors.

15. Windows 17 supports which of the following file system?

a. NTFS

b. FAT

c. EXIT

d. UNIX

Correct Answer: a. NTFS
Explanation: Windows operating systems, including hypothetical Windows 17, primarily support NTFS for its advanced features.

16. Which among the following are the best tools for fixing errors on disks?

a. Operating system

b. Scandisk

c. Chkdisk

d. Fixdisk

Correct Answer: c. Chkdisk
Explanation: Chkdisk is a Windows utility for checking and fixing disk errors.

17. ………………….. runs on computer hardware and as platform for other software to run on

a. Operating system

b. Application software

c. System software

d. All of the above

Correct Answer: a. Operating system
Explanation: The operating system manages hardware and provides a platform for other software.

18. The operating system creates __ from the physical computer.

a. Virtual space

b. Virtual computer

c. Virtual device

d. None of the above

Correct Answer: b. Virtual computer
Explanation: The operating system abstracts physical hardware into a virtual computer for software to run on.

19. The primary function of an operating system is:

a. To make the most efficient use of the computer hardware

b. To allow people to use the computer hardware

c. To keep systems programmers employed

d. To make computer easier to use

Correct Answer: a. To make the most efficient use of the computer hardware
Explanation: The primary role of an OS is to optimize hardware resource utilization.

20. Thesaurus tool in MS Word is used for:

a. Spelling suggestions

b. Grammar options

c. Synonyms and Antonyms words

d. All of the above

Correct Answer: c. Synonyms and Antonyms words
Explanation: The Thesaurus in MS Word provides synonyms and antonyms for selected words.

21. Which tab in Font dialog box contains options to apply font effects?

a. Font tab

b. Character spacing

c. Text effects

d. Standard Toolbar

Correct Answer: a. Font tab
Explanation: The Font tab in the Font dialog box includes effects like bold, italic, and underline.

22. Which of the following is not of the merge process?

a. Sort the data source records

b. Format a main document

c. Edit a data source

d. Merge the two files to print or create a new document

Correct Answer: a. Sort the data source records
Explanation: Sorting data is not a required step in the mail merge process, though it can be done.

23. A screen element of MS Word that is usually located below the title bar that provides categorized options is:

a. Menu bar

b. Tool Bar

c. Status Bar

d. All the above

Correct Answer: a. Menu bar
Explanation: The menu bar provides categorized options below the title bar in older MS Word versions.

24. A word processor would most likely be used to do?

a. Keep an account of money spent

b. Do a computer search in media center

c. Maintain an inventory

d. Type a biography

Correct Answer: d. Type a biography
Explanation: Word processors are primarily used for creating and editing text documents like biographies.

25. If you need to change the typeface of a document, which menu will you choose?

a. Edit

b. View

c. Format

d. Tools

Correct Answer: c. Format
Explanation: The Format menu in MS Word contains options to change typeface and other formatting.

26. __ is a tool in Word which apply same format to different character/paragraph.

a. Format repeater

b. Format applier

c. Format painter

d. Format generator

Correct Answer: c. Format painter
Explanation: Format Painter copies formatting from one text or paragraph to another.

27. __ switch the page between portrait and landscape layout.

a. Margins

b. Size

c. Columns

d. Orientation

Correct Answer: d. Orientation
Explanation: Orientation settings in MS Word switch between portrait and landscape layouts.

28. __ enables several people to work to create and update a document.

a. Document sharing

b. Document locking

c. Document protection

d. Document Collaboration

Correct Answer: d. Document Collaboration
Explanation: Document collaboration allows multiple users to edit a document simultaneously.

29. When a hyperlink is created, Word formats the Web address as:

a. Italicized and colored red

b. Underlined and colored blue

c. Underlined and colored red

d. Italicized and colored blue

Correct Answer: b. Underlined and colored blue
Explanation: MS Word formats hyperlinks as underlined and blue by default.

30. Workbook is collection of:

a. Cells

b. Worksheets

c. Workspaces

d. Projects

Correct Answer: b. Worksheets
Explanation: A workbook in MS Excel is a file containing multiple worksheets.

31. Short-cut key to bring format cells dialog box is:

a. Ctrl+F

b. Ctrl+E

c. Ctrl+I

d. Ctrl+D

Correct Answer: d. Ctrl+1 (Note: Corrected from Ctrl+D)
Explanation: Ctrl+1 opens the Format Cells dialog box in MS Excel.

32. The cell reference $A$5 is a __

a. Relative cell reference

b. Absolute cell reference

c. Mixed cell reference

d. None of the above

Correct Answer: b. Absolute cell reference
Explanation: $A$5 is an absolute reference, locking both column and row.

33. Function to get sum of the contents of the cells A1, A2, B1, B14, B2)

a. =SUM (A1+A2+B14+B2)

b. =SUM (A1, B2)

c. =TOTAL(A1..B2)

d. =SUM (A1, B2)

Correct Answer: None (Correct formula: =SUM(A1,A2,B1,B14,B2))
Explanation: The correct formula is =SUM(A1,A2,B1,B14,B2) to sum non-contiguous cells.

34. To edit the contents of cell:

a. Press F2

b. Double click on cell

c. Click on formula bar

d. All of the above

Correct Answer: d. All of the above
Explanation: All methods (F2, double-click, formula bar) allow editing cell contents in Excel.

35. Graphical representation of worksheet data—

a. Pivot table

b. Goal seek

c. Graph

d. Scenario

Correct Answer: c. Graph
Explanation: Graphs (or charts) visually represent worksheet data in Excel.

36. Filter option is used to………..

a. Arrange data in alphabetical order

b. Arrange data in numeric order

c. Arrange data chronological order

d. Extract the records that meet given criteria

Correct Answer: d. Extract the records that meet given criteria
Explanation: Filters in Excel extract records based on specified criteria.

37. The formula =IF(A1>B1, A1-B1, B1-A1) gives

a. Larger one from cell A1 and B1

b. Positive deference of A1 and B1

c. Contents of A1

d. Contents of B1

Correct Answer: b. Positive difference of A1 and B1
Explanation: The formula returns the positive difference by subtracting the smaller value from the larger.

38. How do you display updatable current date in MS Excel?

a. DATE()

b. TODAY()

c. NOW()

d. CTRL+;

Correct Answer: b. TODAY()
Explanation: TODAY() displays the current date and updates automatically.

39. A function inside another function is called__

a. Nested function

b. Round function

c. Sum function

d. Text function

Correct Answer: a. Nested function
Explanation: A function inside another function is called a nested function in Excel.

40. What are the different views to display a table?

a. Datasheet View

b. Design View

c. Pivot Table & Pivot Chart View

d. All of the above

Correct Answer: d. All of the above
Explanation: MS Access supports Datasheet, Design, Pivot Table, and Pivot Chart views for tables.

41. In a Database Table, the Category of Information Is Called__

a. Tuple

b. Field

c. Record

d. All of the above

Correct Answer: b. Field
Explanation: A field represents a category of information (column) in a database table.

42. This Key Uniquely Identifies Each Record

a. Primary Key

b. Key record

c. Unique Key

d. Field Name

Correct Answer: a. Primary Key
Explanation: A primary key uniquely identifies each record in a database table.

43. Enables you to view data from a table based on a specific criterion

a. Form

b. Query

c. Macro

d. Report

Correct Answer: b. Query
Explanation: Queries retrieve data from tables based on specific criteria in a database.

44. A database Language concerned with the definition of the whole database structure and schema is

a. DCL

b. DML

c. DDL

d. All of the above

Correct Answer: c. DDL
Explanation: DDL (Data Definition Language) defines the database structure and schema.

45. In Microsoft PowerPoint in order to see all the slides on one screen use

a. View, Slide Sorter

b. View, Slide

c. View, Master

d. View, Slide Show

Correct Answer: a. View, Slide Sorter
Explanation: Slide Sorter view displays all slides on one screen for easy organization.

46. What are the three options available in Insert >> Picture menu

a. Clipart, Pictures, Shapes

b. Clipart, From Files, Shapes

c. Clipart, From Files, AutoShapes

d. Clipart, Pictures, AutoShapes

Correct Answer: c. Clipart, From Files, AutoShapes
Explanation: The Insert >> Picture menu in older PowerPoint versions includes these options.

47. Which of the following font effect’s not available in PowerPoint Font dialog box

a. Underline

b. Shadow

c. Emboss

d. Strikethrough

Correct Answer: d. Strikethrough
Explanation: Strikethrough is not available in PowerPoint’s Font dialog box.

48. Full form of HTML is………

a. Hypertext Markup Language

b. HotMail

c. Hypertext Mail Language

d. All of the above

Correct Answer: a. Hypertext Markup Language
Explanation: HTML stands for Hypertext Markup Language, used for web page structure.

49. In HTML……… tag used for linking an external document.

a. <src>

b. <anchor>

c. <a>

d. <inclu

Correct Answer: c. <a>
Explanation: The <a> tag (anchor) is used for creating hyperlinks to external documents.

50. To Set the Background color we use:

a. <Body text=”color”>

b. <Body=”color”>

c. <Body bgcolor=”color”>

d. All of the above

Correct Answer: c. <Body bgcolor=”color”>
Explanation: The bgcolor attribute in the <body> tag sets the background color in HTML.