Computer Operator Model Question Set - 6
1. The process of transforming data into useful information by computer is ...
Correct Answer: c. Information
The process of transforming raw data into meaningful information is known as data processing, which results in information as the output.
2. The two major types of computer chips are
Correct Answer: d. Both B and C
Primary memory chips (e.g., RAM, ROM) store data temporarily or permanently, and microprocessor chips (e.g., CPU) process data, forming the two major types of computer chips.
3. A non-volatile firmware which is used to perform hardware initialization during the computer booting process is called
Correct Answer: a. BIOS
BIOS (Basic Input/Output System) is non-volatile firmware that initializes hardware during the booting process and provides runtime services.
4. Which output device is used for translating information from a computer into pictorial form on paper?
Correct Answer: b. Plotter
A plotter is an output device that translates computer information into pictorial or graphical form on paper, often used for technical drawings.
5. The Analytical Engine developed during the first generation of the computer used ... as a memory unit.
Correct Answer: c. Counter wheels
The Analytical Engine, designed by Charles Babbage, used counter wheels as a mechanical memory unit to store numerical data.
6. Which of the following probably has the least amount of technical knowledge?
Correct Answer: d. User
A user typically has the least technical knowledge compared to programmers, computer operators, or system analysts, as they primarily interact with software interfaces.
7. Computer is free from tiredness and boredom. We call it
Correct Answer: c. Diligence
Diligence refers to a computer's ability to perform repetitive tasks without tiredness or boredom, unlike humans.
8. The server on the internet is also known as a
Correct Answer: b. Host
A server on the internet is often referred to as a host, as it hosts services or resources accessible to clients.
9. As compared to the secondary memory, the primary memory of a computer is
Correct Answer: c. Fast
Primary memory (e.g., RAM) is faster than secondary memory (e.g., hard drives) but has less storage capacity and is more expensive.
10. USB stands for
Correct Answer: a. Universal Serial Bus
USB stands for Universal Serial Bus, a standard for connecting devices to a computer for data transfer and power supply.
11. What is a brand?
Correct Answer: b. The name of product a company gives to identify its product in market
A brand is a name, term, or symbol used by a company to identify and differentiate its products in the market.
12. Today's computer giant IBM was earlier known by the name
Correct Answer: b. Computing Tabulating Recording Co.
IBM was originally named Computing Tabulating Recording Company (CTR) before adopting the name International Business Machines in 1924.
13. Which of the following is known as Malicious software?
Correct Answer: c. Malware
Malware (malicious software) is software designed to harm or exploit computer systems, including viruses, worms, and trojans.
14. The first Network is
Correct Answer: d. ARPANET
ARPANET, developed in the late 1960s, was the first network and a precursor to the modern internet.
15. During the booting of computer, which of the following are loaded into main memory?
Correct Answer: a. Internal Command Instructions
During booting, internal command instructions (part of the operating system) are loaded into main memory to initialize the system.
16. The PATH command is usually found as part of your ... file.
Correct Answer: d. AUTOEXEC.BAT
The PATH command, which sets directories for executable files, is typically found in the AUTOEXEC.BAT file in older DOS systems.
17. Windows 2000 server uses the
Correct Answer: b. NTFS
Windows 2000 Server uses NTFS (New Technology File System) for enhanced security, reliability, and performance compared to FAT systems.
18. Operating system of a computer
Correct Answer: c. provides a layer, user friendly interface
The operating system provides a user-friendly interface, acting as a layer between hardware and users to manage resources and run applications.
19. Each time you turn on your computer, it will check on the control file
Correct Answer: c. Command.com, io.sys, msdos.sys
In older Windows systems (e.g., MS-DOS), the boot process checks Command.com, io.sys, and msdos.sys to load the operating system.
20. Microsoft Word is ... software.
Correct Answer: a. application
Microsoft Word is application software used for word processing tasks like creating and editing documents.
21. The name of a word document displays in
Correct Answer: b. Title bar
The name of a Word document is displayed in the title bar at the top of the Microsoft Word window.
22. Ctrl+H opens
Correct Answer: a. Find and Replace Dialog box with activating Replace Tab
Ctrl+H in Microsoft Word opens the Find and Replace dialog box with the Replace tab active for text replacement.
23. What is the short cut to Align text to Right?
Correct Answer: b. CTRL+R
Ctrl+R is the shortcut key in Microsoft Word to align selected text to the right.
24. Where does footnote appear in a document?
Correct Answer: b. Bottom of a page
Footnotes in a document appear at the bottom of the page where they are referenced, providing additional information.
25. To make character subscript press
Correct Answer: a. Ctrl +=
Ctrl+= is the shortcut in Microsoft Word to format selected text as subscript (e.g., H₂O).
26. Which of the following is not a font style?
Correct Answer: d. Superscript
Bold, Italics, and Regular are font styles, while superscript is a font effect that positions text above the baseline.
27. Which of the following do you use to change margins?
Correct Answer: b. Page setup dialog box
The Page Setup dialog box in Microsoft Word is used to adjust document margins, accessible via the Layout or Page Layout tab.
28. OLE stands for
Correct Answer: a. Object Linking and Embedding
OLE (Object Linking and Embedding) allows embedding or linking objects like images or spreadsheets in documents for dynamic updates.
29. The page size of an A4 document is
Correct Answer: c. 8.27" X 11.69"
A4 paper measures 210 x 297 mm, which is approximately 8.27 x 11.69 inches in standard dimensions.
30. We can consolidate data by
Correct Answer: c. Both A and B
In Excel, data consolidation can be done using row labels, column labels, or both to summarize data from multiple ranges.
31. In Excel sheet, a numeric value is treated as a label value if it precedes with
Correct Answer: a. Apostrophe
In Excel, prefixing a numeric value with an apostrophe (e.g., '123) treats it as a text label rather than a number.
32. Which of the following is not correct method of editing the cell content?
Correct Answer: a. Press the Alt key
Pressing F2, clicking the formula bar, or double-clicking a cell allows editing cell content in Excel, but Alt does not.
33. ... is not a function category in Excel.
Correct Answer: d. Data Series
Excel function categories include Logical, Text, and Financial, but Data Series is not a function category; it relates to chart data.
34. You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key will you press to update the formula values?
Correct Answer: a. F9
In Excel's manual calculation mode, pressing F9 recalculates and updates formula values in the workbook.
35. An Excel workbook is a collection of
Correct Answer: c. Worksheets and charts
An Excel workbook is a file containing multiple worksheets (spreadsheets) and can also include charts for data visualization.
36. Which of the following options is not available in paste special dialog box?
Correct Answer: d. SQRT
The Paste Special dialog box in Excel includes options like Add, Subtract, and Divide for operations on pasted data, but SQRT (square root) is not available.
37. To return the remainder after a number is divided by a divisor in Excel, we use the function
Correct Answer: c. MOD()
The MOD() function in Excel returns the remainder after a number is divided by a divisor (e.g., MOD(10,3) returns 1).
38. Formulas in Excel are made up of
Correct Answer: a. Arithmetical operators and functions
Excel formulas combine arithmetic operators (e.g., +, -, *, /) and functions (e.g., SUM, IF) to perform calculations.
39. In MS-Excel, chart wizard term data series refers to
Correct Answer: c. a set of values you plot in a chart
In Excel's Chart Wizard, a data series is a set of values plotted in a chart, represented by markers, lines, or bars.
40. In a database table, the category of information is called
Correct Answer: b. Field
A field in a database table represents a category of information, such as a column for names or ages.
41. Which of the following is not an advantage of the database approach?
Correct Answer: d. All of the above
All listed options (associating related data, increased security, and program/data independence) are advantages of the database approach.
42. Which of the following is not a type of Microsoft Access database object?
Correct Answer: c. Worksheets
Microsoft Access database objects include Tables, Macros, and Modules, but Worksheets are specific to Excel, not Access.
43. Data ... means multiple copies same data item.
Correct Answer: d. Redundancy
Data redundancy refers to the presence of multiple copies of the same data item in a database, which can lead to inefficiencies.
44. In SQL, the command to modify data in the database is
Correct Answer: b. UPDATE
The SQL UPDATE command is used to modify existing data in a database table, while MODIFY and CHANGE are not standard SQL commands.
45. How can you create a uniform appearance by adding a background image to all slides?
Correct Answer: b. Edit the slide master
Editing the slide master in PowerPoint allows you to add a background image that applies uniformly to all slides in a presentation.
46. Powerpoint presentations are widely used as
Correct Answer: d. all of the above
PowerPoint presentations are used for teacher outlines, student project presentations, and communicating plans in various professional settings.
47. Which file format can be added to a Powerpoint show?
Correct Answer: d. all of the above
PowerPoint supports adding .jpg (images), .gif (animated images), and .wav (audio) files to enhance presentations.
48. How many colour names are used by the browsers?
Correct Answer: d. 16
Browsers recognize 16 basic color names (e.g., red, blue, green) as defined in the HTML and CSS specifications.
49. A piece of icon or image on a webpage associated with another webpage is called
Correct Answer: a. Hyperlink
A hyperlink is an icon, image, or text on a webpage that links to another webpage or resource when clicked.
50. <title> ... </title> is included inside
Correct Answer: b. <head></head>
The <title> tag, which defines the webpage title, is placed inside the <head> section of an HTML document.