HERE ARE THE answers and explanation to the first set of Computer Operator MCQ Practice Sheets 75-01. The correct answers are marked with blue color. Explanation of each question is marked with green color.
You can download this solution as PDF file. Please find the link at the bottom of this post.
Computer Operator MCQ Practice Sheet 75-01
Q1. Excel displays the current cell address in the…
a. Formula bar
b.. Status bar
c. Name box
d. title bar
Explanation: In excel, to the left of formula bar lies Name box that displays the cell address of active cell or range name depending upon what is currently selected.
Q2. The output quality of a printer is measured in
a. Dot per inch
b. Dot per sq. inch
c. Dots printed per unit time
d. All of above
Explanation: Dots per inch (DPI) is the measurement of how many dots can be printed per inch. However, the quality of printout is determined by the dots per square inch in case the printer cannot print an equal number of dots horizontally and vertically.
In earlier days the dot matrix printers could print a fairly larger number of dots in one-inch length horizontally whereas it could print a very low number of dots vertically. Thus to determine the printer quality you had to consider dots per square inch rather than dots per inch.
Even though today’s printers can print an almost equal number of dots both horizontally and vertically, you’ll need to choose dots per square inch for this question if you have this option available considering the question is composed taking a reference to the older collection.
Q3. Which of the following is the feature of 5th generation computers?
d. All of above
Explanation: Valves were used in First Generation. Micro-chips are being used in current generation. Bio-Chips and genetically engineered protein molecules are expected as fifth-generation processing devices.
Q4. Collection of related records in a database is known as…
Explanation: In relational database terminology a tuple is a record which is the collection of attributes or fields. A table is called relation and relationship is the connection of two relations on some common attribute. Thus Relation is the correct term for a collection of related records.
Q5. The most efficient method to reduce the duplication of data is:
a. Primary key
Explanation: Normalization is the method of breaking tables into smaller ones so that you can eliminate data duplication and enhance data integrity.
Q6. How many bits you’ll need to code 100 different objects?
a. 5 bits
b. 6 bits
c. 7 bits
d. 8 bits
Explanation: You will need 7 bits to represent 100 different objects because 2^7 = 128. If you pick only 6 bits, then you can code only 2^6 = 64 different objects.
Q7. if name profit is defined to cell D5, then
a. Value of D5 is “profit”
b. Formula D5/2 may be written as “profit”/2
Explanation: Once you define range names you can use it in a formula as cell addresses. Option ‘a’ is not valid because defining range name do not assign a value to the cells.
Q8. Which of the following device is used for serial access?
b. Magnetic Cassette
c. Magnetic disk
d. L1 Cache
Explanation: Magnetic Cassette is the magnetic tape which is sequential by nature. Other options such as RAM, Disks and L1 Cache are direct access or random access device.
Q9. Hypertext Markup Language is somehow similar to
a. Event Driven Programming Language
b. Structured Programming Language
c. Scripting Language
d. MS Word
Explanation: HTML is very similar to scripting languages. HTML documents are not like event-driven programs nor are they like structured programs. Also, HTML is very different than MS Word document.
Q10. Which of the following device check the physical address to route data to its destination?
Explanation: Bridge checks the physical address (MAC Address) and routes the data accordingly. It is layer 2 device on OSI model. The router checks network address (IP Address) to rout packets. Hub does not check any address, it just amplifies and distributes the data to all the ports on it. Gateway is a special computer in a network through which data goes out of the network or comes into the network from outside world.