Search Previous Year Questions

The correct answer is DeskTop Publishing.

Key Points

• DTP is a computer abbreviation, it means DeskTop Publishing.
• Desktop publishing (DTP) refers to the use of a digital desktop for laying out and constructing documents.
• It is also known as computer-aided publishing.
• It may also refer simply to the creation and construction of digital documents on a desktop.

Important Points

• Desktop-publishing software can be used to create layouts for a wide range of different publications, such as newspaper and magazine brochures, posters, flyers, leaflets and catalogue books and e-books PDF web pages banners newsletter designs. Start.

The correct answer is it returns the average of the values in the list of arguments.

Key Points

• AVERAGEA() function in MS Excel calculates the average of the values in the list of arguments. Hence option 2 is correct.
• Its syntax is AVERAGEA(value 1, [value 2],.....). Here value 1 is required and the subsequent values are optional. 1 to 255 cells, or variables for which you want to calculate the average.
• Arguments can be numbers, names, arrays or references that contain numbers, the text representation of numbers or logical values such as True or False etc.
• Arguments that contain TRUE evaluate as 1 and arguments that contain FALSE are evaluated as 0.

Additional Information

• The AVERAGE() function returns the average of the arguments. Its syntax is AVERAGE(number 1, [number 2],......). For example, AVERAGE(B1:25) returns the average of the numbers in between the cells B1 and B25.
• AVERAGEIF() function returns the average of all the cells in the range that meet the given criteria. Its syntax is AVERAGEIF(range, criteria, [average_range]). Here, the range is the number of cells and it is required. Criteria means conditions, it can be an expression, number or array, logical etc.
• AVERAGEIFS() function returns the average of all cells that meet multiple criteria. Its syntax is AVERAGEIFS(average_range, criteria_range1, [criteria_range 2, criteria2],....).

The correct answer is F5.

Key Points

• In MS Word, pressing F5 opens the "Find and Replace" dialog box, allowing users to quickly search and replace text within the document.
• This feature is essential for editing large documents efficiently, as it helps locate specific text and make necessary changes without manual searching.

Additional Information

• Option 2: CTRL + F5 – This shortcut is generally used to refresh the page in web browsers or reset the window size in some applications.
• Option 3: CTRL + F4 – This combination is typically used to close the active document or window.
• Option 4: F4 – In MS Word, the F4 key is used to repeat the last action performed.

The correct answer is Ctrl+F1.

Key Points

• To go to the Ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys.
• To hide the Ribbon so you have more room to work, press Ctrl+F1. Repeat to display the Ribbon again.

Additional Information

The correct answer is Option 1.

Key Points

• Statement (i): "Landscape" is a valid page margins option in MS Word:
• In MS Word, "Landscape" is not a page margin option but a page orientation. Page orientation refers to the layout of the page, either horizontal (Landscape) or vertical (Portrait). Page margins, on the other hand, define the blank spaces between the content and the edges of the page.
• Thus, the statement "Landscape is a valid page margins option" is False.
• Statement (ii): "Portrait" is a valid page margins option in MS Word:
• Similar to Landscape, "Portrait" is a page orientation, not a page margin option. Portrait refers to a vertical layout, while page margins refer to customizable blank spaces around the content.
• Thus, the statement "Portrait is a valid page margins option" is False.
• Clarification of Page Margins:
• Page margins in MS Word are customizable blank spaces around the text on a page. They include options such as Normal, Narrow, Moderate, Wide, Mirrored, etc.
• These options can be adjusted via the "Layout" tab under the "Margins" section.
• Page Orientation:
• The "Orientation" feature in MS Word allows users to choose between two layouts: Landscape (horizontal) and Portrait (vertical).
• This feature is located under the "Layout" tab in the "Page Setup" section.

Additional Information

• Page Margins in MS Word:
• Page margins are the spaces between the text and the edge of the page.
• MS Word provides pre-defined margin options such as Normal (1 inch), Narrow (0.5 inch), Wide (2 inches), Moderate, and customizable margins.
• Margins are essential for ensuring proper alignment of text and enhancing the visual presentation of documents.
• Users can access margin settings under the "Layout" tab and select the "Margins" dropdown menu.
• Page Orientation in MS Word:
• Page orientation determines the direction in which the content is displayed on the page.
• There are two types of orientations: Portrait (vertical layout) and Landscape (horizontal layout).
• Users can change page orientation under the "Layout" tab in the "Page Setup" section.
• Orientation is commonly used for presentations, brochures, and documents requiring specific layouts.
• Differences Between Margins and Orientation:
• Margins: Refer to the blank spaces around the text, measured in inches or centimeters.
• Orientation: Refers to the overall layout of the page, either vertical or horizontal.
• Both settings are independent of each other but contribute to the overall formatting of a document.
• Applications of Margins and Orientation:
• Margins ensure proper alignment and readability of text in professional documents.
• Orientation is used for specific document types, such as landscape for charts or tables and portrait for letters or essays.

Important Points

• Quick Access: Margins and orientation settings in MS Word are located under the "Layout" tab.
• Customization: Both page margins and orientation can be customized based on the document's requirements.
• Professional Usage: Proper use of margins and orientation is critical for creating professional and visually appealing documents.
• Printing Considerations: Adjusting margins and orientation ensures the document fits well when printed.

The correct answer is Abacus.

Key Points

• The Abacus is regarded as the first counting tool. It was used in ancient times for arithmetic processes and is still in use in some parts of the world today.
• It is composed of a frame with rods, on which beads are moved to perform mathematical calculations.
• The Abacus predates modern numerical systems and was instrumental in the development of mathematical concepts.

Additional Information

• Aba Zaba: This is actually a type of candy bar and has no relevance to counting tools or historical mathematical instruments.
• Punch Card: Punch cards were used for data input and storage in early computing machines, such as those developed by Herman Hollerith for the 1890 U.S. Census. They are not considered counting tools.
• Stepped Reckoner: Invented by Gottfried Wilhelm Leibniz in the 17^th century, the Stepped Reckoner was an early mechanical calculator capable of addition, subtraction, multiplication, and division. While significant, it was developed much later than the Abacus.

The correct answer is Printing drawings and maps.

Key Points

• The plotter is basically a type of Printer.
• It is an output device of the computer.
• It uses a pen to create a print on paper or media.
• The output is created on vector graphics.
• It means that the dots are printed which are joined by lines and curves to produce text and images.
• Plotters are present in many designs used for printing large format prints.
• It includes architecture like layouts, building plans, ship designs, CAD (computer-aided design), big canvas prints, and any other engineering drawing.
• The plotters utilize pens or markers to draw graphics on an output media.
• These pens move differently according to the technology deployed by a plotter.
• Three types of plotters are most popular for their ability to allow you to create different designs.
• Drum Plotters.
• Flat Bed Plotters
• Ink Jet Plotters

The correct answer is Option 2. 

Key Points

• The important system components like the central processing unit (CPU) and random access memory (RAM) modules are connected directly to the Motherboard.
• The motherboard acts as the main circuit board of a computer system, providing electrical connections and pathways for various hardware components to communicate with each other.
• The CPU is typically inserted into a socket on the motherboard, and the RAM modules are installed into slots on the motherboard.

Additional Information

• Magnetic Tape: Magnetic tape is a medium used for long-term storage of data.
• It is typically used for backup purposes rather than directly connecting components like CPU and RAM.
• Magnetic tape drives are separate devices that connect to a computer system.
• Optical Disk: An optical disk is a storage medium that uses laser technology to read and write data.
• Examples of optical disks include CDs, DVDs, and Blu-ray discs.
• While optical drives can be connected to the motherboard, they are used primarily for reading and writing data from optical disks rather than directly connecting the CPU and RAM.
• Flash memory is a type of non-volatile memory that retains data even when power is removed.
• It is commonly used in USB flash drives, solid-state drives (SSDs), and memory cards.
• Flash memory can be connected to the motherboard through various interfaces such as USB, SATA, or PCIe.

The computer loads data from read-only memory (ROM) and performs a power-on self-test (POST) to make sure all the major components are functioning properly.

The correct answer is When downloading unknown software from the internet.

Key Points

• There are several ways a computer can get infected by a virus and most of them involve downloading – either intentionally or unintentionally – infected files.
• Pirated music or movies, photos, free games and toolbars are common culprits, as are phishing/spammy emails with attachments.
• The computer can be protected from viruses by installing valid anti-virus software on our computer.

Additional Information

Types of Computer Virus:

• Boot Sector Virus.
• Polymorphic Virus.
• Resident Virus.
• Multipartite Virus.
• Web Scripting Virus