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

Computer Operator Model Question Set - 2

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), equivalent 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.

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 data from digital devices 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 laser beams to read 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 standard for encoding characters from various writing systems.

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 in access to technology and the internet.

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 fast memory type located between the CPU and main memory for quick 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 are suitable for printing carbon copies due to their impact printing mechanism.

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 data files used to track and identify returning users on websites.

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 advanced file management.

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

a. Operating system b. Scandisk c. Chkdsk d. Fixdisk

Correct Answer: c. Chkdsk
Explanation: Chkdsk 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: An operating system provides a platform for other software to run on computer hardware.

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 creates a virtual computer environment for software execution.

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 function of an OS is to manage hardware resources efficiently.

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 options for effects like bold, italic, and shadow.

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 source records is not a required step in the mail merge process.

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 MS Word.

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 the typeface of a document.

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 and applies it 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 in page setup switches 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 Excel is a collection of 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: None (Correct shortcut is Ctrl+1)
Explanation: The correct shortcut to open the Format Cells dialog box in Excel is Ctrl+1, not listed in the options.

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 cell reference, as it fixes 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 is =SUM(A1,A2,B1,B14,B2))
Explanation: The correct SUM function lists all cells separated by commas: =SUM(A1,A2,B1,B14,B2).

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: Pressing F2, double-clicking a cell, or clicking the formula bar all 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: The Filter option in Excel extracts 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 deference of A1 and B1
Explanation: The formula returns the positive difference between A1 and B1, regardless of which is 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: The TODAY() function 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: In MS Access, tables can be viewed in Datasheet, Design, Pivot Table, and Pivot Chart views.

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 in a database table represents a category of information (e.g., Name, Age).

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 in databases allow viewing data based on specific criteria.

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 in PowerPoint displays all slides on one screen.

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: In older versions of PowerPoint, the Insert >> Picture menu included Clipart, From Files, and AutoShapes.

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 the PowerPoint Font dialog box in older versions.

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 creating web pages.

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 tag) is used in HTML to link to external documents or pages.

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.