Computer Operator Model Question Set - 9
1. Related fields in a database are grouped to form a
Correct Answer: b. Data record
A data record groups related fields in a database, representing a single entry, like a row in a table.
2. In MS Access, rows and columns are technically called ... respectively.
Correct Answer: a. Records and Fields
In MS Access, rows are records (data entries), and columns are fields (data attributes).
3. The tables in a relational database are linked according to
Correct Answer: c. Relationship
Relational databases link tables using relationships, typically via primary and foreign keys.
4. Which PowerPoint feature is used to apply motion effects to different objects on a slide?
Correct Answer: d. Animation Scheme
Animation Schemes in PowerPoint apply motion effects to slide objects for dynamic presentations.
5. What allows you to create a new presentation by selecting ready-made font colors and graphic effects?
Correct Answer: c. Design template
Design templates in PowerPoint provide pre-set font colors and graphics for new presentations.
6. Which of the following is not a section in a PowerPoint slide layout?
Correct Answer: c. Animations
Slide layouts include sections like titles, lists, and charts; animations are applied separately.
7. Which HTML code is valid for setting font color?
Correct Answer: b. <font color="red">
The correct attribute is 'color' (not 'colour'), and <red> is not a valid HTML tag.
8. How do you create an ordered list (with numbered items) in HTML?
Correct Answer: b. <ol>
<ol> creates an ordered (numbered) list, while <ul> creates an unordered (bulleted) list.
9. What is the correct HTML for inserting an image?
Correct Answer: a. <IMG SRC = "Image.gif">
The <img> tag with the 'src' attribute inserts images in HTML.
10. What is the name of a program that gathers user information and sends it over the Internet?
Correct Answer: b. Spybot
Spybot (spyware) collects and sends user information without consent, unlike viruses or patches.
11. Which technology was used in second-generation computers?
Correct Answer: c. Transistors
Second-generation computers (1956–1965) used transistors, replacing vacuum tubes for better efficiency.
12. How can you access a frequently visited webpage more quickly?
Correct Answer: a. Saving it as a favorite/bookmark
Bookmarks or favorites allow quick access to frequently visited webpages.
13. Which of the following is not a real security or privacy risk?
Correct Answer: b. Spam
Spam is an annoyance but not a direct security risk, unlike hackers, viruses, or identity theft.
14. A network with a maximum distance of 500 meters is classified as
Correct Answer: a. LAN
A LAN (Local Area Network) covers distances up to 500 meters, typically within a building.
15. Which programming language uses mnemonics?
Correct Answer: b. Assembly language
Assembly language uses mnemonics (e.g., ADD, MOV) to represent machine instructions.
16. RISC stands for
Correct Answer: b. Reduced Instruction Set Computer
RISC uses a simplified instruction set for faster CPU processing.
17. Which term specifies the resolution of a laser printer?
Correct Answer: a. DPI
DPI (Dots Per Inch) measures a laser printer’s resolution, indicating print quality.
18. Which HTML tags are used for sub-headings?
Correct Answer: d. All of the above
<H1>, <H2>, and <H3> are used for main and sub-headings in HTML.
19. EBCDIC stands for
Correct Answer: a. Extended Binary Coded Decimal Interchange Code
EBCDIC is a character encoding system used primarily on IBM mainframes.
20. Ten computers connected to a hub represent which network topology?
Correct Answer: a. Star Topology
A star topology connects all devices to a central hub, common in LANs.
21. FTP stands for
Correct Answer: b. File Transfer Protocol
FTP is a protocol for transferring files between computers over a network.
22. Second-generation computers were developed during
Correct Answer: a. 1956 to 1965
Second-generation computers, using transistors, were developed from 1956 to 1965.
23. Which of the following is not part of the CPU?
Correct Answer: b. Mouse
The CPU includes the ALU, memory, and control unit; the mouse is an external input device.
24. Which of the following can be updated to improve system performance?
Correct Answer: a. BIOS
BIOS updates improve system compatibility and performance; ROM and CPU require hardware changes.
25. What are software updates that fix bugs or vulnerabilities but may affect system performance?
Correct Answer: b. Security patches
Security patches fix bugs and vulnerabilities but may occasionally slow down system performance.
26. Which power options are available on a desktop computer?
Correct Answer: d. All of the above
Shutdown, Sleep, and Hibernate are standard power options for managing a desktop’s energy use.
27. How do you access Administrative Tools and Control Panel in Windows?
Correct Answer: a. Start Menu
The Start Menu in Windows provides access to the Control Panel and Administrative Tools.
28. What is the shortcut key to jump to a specific page in MS-Word?
Correct Answer: b. Ctrl + G
Ctrl + G opens the 'Go To' dialog in MS-Word to navigate to a specific page.
29. Which feature in MS-Word can replace text with stylized designs?
Correct Answer: c. WordArt and Design Gallery
WordArt and Design Gallery in MS-Word offer stylized text and design elements to enhance documents.
30. Which of the following is the correct term for a spelling error in font settings context?
c. misspelled
d. mispelled
Correct Answer: c. misspelled
‘Misspelled’ is the correct spelling, relevant for text editing in font settings.
31. What is the default style used for formatting text, such as address lists, in MS-Word?
Correct Answer: a. Normal Style
Normal Style is the default formatting style in MS-Word for text, including address lists.
32. Which MS-Word feature integrates with the thesaurus for document editing?
Correct Answer: b. Review Tab
The Review Tab in MS-Word provides access to the thesaurus for synonym suggestions.
33. Which shortcut key combination is associated with the thesaurus in MS-Word?
Correct Answer: a. Shift + F7
Shift + F7 opens the thesaurus in MS-Word to find synonyms.
34. Where in MS-Word can you adjust page margins and paragraph spacing?
Correct Answer: d. All of the above
Page margins are set in the Page Setup Dialog Box or Layout Tab, and paragraph spacing is adjusted in Paragraph Settings.
Page margins are set in the Page Setup Dialog Box or Layout Tab, and paragraph spacing is adjusted in Paragraph Settings.
35. What is the F12 shortcut key used for in MS-Word?
Correct Answer: b. Save As
F12 opens the Save As dialog box in MS-Word for saving a file with a new name.
36. Hyperlinks in MS-Word cannot be created to directly link to
Correct Answer: d. An application program
Hyperlinks in MS-Word can link to documents, webpages, or folders, but not directly to applications.
37. What are macros in MS-Word?
Correct Answer: a. Small programs to automate tasks using VBA
Macros in MS-Word use VBA to automate repetitive tasks.
38. Which statement is false about Conditional Formatting in MS-Excel?
Correct Answer: b. You can check for bold text and apply italics
Conditional Formatting cannot check font styles like bold; it works with cell values and formats.
39. How do you add comments to cells in MS-Excel?
Correct Answer: b. Insert -> Comment
In older Excel, comments are added via Insert -> Comment; in newer versions, it’s Review -> New Comment.
40. What is the correct formula to increase the number in cell A1 by 13% in MS-Excel?
Correct Answer: a. =A1*1.13
To increase A1 by 13%, multiply by 1.13 (100% + 13%). Option b is invalid syntax.
41. Which tool button is used for summing data in MS-Excel?
Correct Answer: b. Auto Sum
Auto Sum quickly inserts the SUM function to add selected cells in Excel.
42. What is the cell reference for the range G2 to M12 in MS-Excel?
Correct Answer: a. G2:M12
Excel uses a colon (:) to denote a range, so G2:M12 is correct.
43. What does the IF function in MS-Excel check?
Correct Answer: c. Whether a condition is true or false
The IF function evaluates a condition and returns a value based on its truth.
44. From which menu are macros executed in older versions of MS-Word?
Correct Answer: c. Tools
In older MS-Word versions, macros are run from the Tools menu; newer versions use the Developer tab.
45. Which function in MS-Excel displays row data in a column or column data in a row?
Correct Answer: c. Transpose
The Transpose function switches row data to columns or vice versa in Excel.
46. Which tool in MS-Excel finds the value needed in a cell to achieve a specific result?
Correct Answer: d. Goal Seek
Goal Seek finds the input value required to achieve a desired result in Excel.
47. When you insert an Excel file into a Word document, the data are
Correct Answer: c. Embedded
Inserting an Excel file into Word embeds the data, allowing editing within Word.
48. Which is not a data type in MS-Access?
Correct Answer: d. Identifier
MS-Access data types include Number, Date, and Text; Identifier is not a data type.
49. Which database object retrieves specific information from a database?
Correct Answer: c. Queries
Queries retrieve specific data from a database based on user-defined criteria.
50. Which database object retrieves specific information from a database?
Correct Answer: c. Queries
Queries retrieve specific data from a database based on user-defined criteria.