Search Previous Year Questions

The correct answer is Speaker.

• Speaker is a 'not' input device.

Key PointsInput device 

• An input device is a piece of computer hardware equipment used to provide data and control signals to an information processing system such as a computer or information appliance.
• Examples of input devices include keyboards, mouse, scanners, digital cameras and joysticks.
• **Speakers are one of the most common output devices used with computer systems.**​

Additional InformationOutput Unit

• An output device is any piece of computer hardware equipment that converts information into human-readable form.
• It can be text, graphics, tactile, audio, and video. Some of the output devices are Visual Display Units i.e. a Monitor, Printer graphic Output devices, Plotters, Speakers, etc.

The correct answer is Desktop.

Key Points

• Desktop is the name of the main screen area you see after you turn on your computer and log on to Windows.
• ​It serves as a surface for work, like the top of an actual desk.
• It is the primary user interface of a computer.
• It includes the desktop background (or wallpaper) and icons of files and folders that may have been saved to the desktop.
• In Windows, the desktop includes a taskbar, which is located at the bottom of the screen by default.

Additional Information

• Application
• It is a computer software package that performs a specific function for an end user or another application based on carefully designed features.
• Applications for desktop or laptop computers are sometimes called desktop applications, while those for mobile devices are called mobile apps.
• Windows
• It is a graphical operating system developed by Microsoft.
• It allows users to view and store files, run the software, play games, watch videos, and provides a way to connect to the internet.
• Frame
• ​It is the digital data transmission unit in telecommunication and computer networking.
• It helps identify data packets used in networking and telecommunications structures.
• In packet switched systems, a frame is a simple container for a single network packet.
• In other telecommunications systems, a frame is a repeating structure supporting time-division multiplexing.

The correct answer is =E5+4.

Key Points 

• If a formula = B2 + 4 is in cell A1 then cell A1 is copied into D4, then the formula in D4 will be = E5 + 4.

• How to Write Formulas in Excel

• All Excel formulas start with an equal (=) sign.

• The answer to the formula is displayed in the cell into which the formula is entered.

• Cells are referenced in a formula by their column-row identifier.

• The symbols for addition, subtraction, multiplication, and division are: + - * /

• We do not have to enter capital letters in the formula, They will be capitalized automatically.

The correct answer is Router.

Key Points

• An Internet Protocol (IP) address is a series of numbers using which a computer or any electronic device is identified.
• Every computer or device has its own IP address and these are categorized as IPv4 and IPv6.
• The Routers are network layer devices that are used for receiving, analyzing and forwarding the data packets among computers in the different networks.
• In general, a network connects to the public internet through a router and this router is assigned an IP address by the Internet Service Provider or ISP. Hence option 4 is correct.
• When a data packet arrives, the router analyzes the optimal route for the transmission of the data.

Additional Information

• A Repeater (also called signal booster) is a device that regenerates signals after they travel over a longer distance maintaining the signal strength constant.
• A Modem is a networking device that modulates digital data from a computer into analog signals for transmission.
• A Switch is a multiport device that connects devices within the network and transmits the data packets between the devices.

The correct answer is Ctrl + W.

Key Points

In computer software like Internet browser, a tab is a clickable area at the top of a window. Some shortcuts related to tabs are:

• Ctrl+1-8 – Switch to the specified tab, counting from the left.
• Ctrl+9 – Switch to the last tab.
• Ctrl+Tab – Switch to the next tab – in other words, the tab on the right. (Ctrl+Page Up also works, but not in Internet Explorer.)
• Ctrl+Shift+Tab – Switch to the previous tab – in other words, the tab on the left. (Ctrl+Page Down also works, but not in Internet Explorer.)
• Ctrl+W, Ctrl+F4 – Close the current tab.
• Ctrl+Shift+T – Reopen the last closed tab.
• Ctrl+T – Open a new tab.
• Ctrl+N – Open a new browser window.
• Alt+F4 – Close the current window.

The correct answer is SUM.

Key Points

• Excel provides a few arithmetic in-built functions for faster calculations like SUM, COUNT, AVERAGE, COUNTIF etc.
• To calculate the aggregate of the values in the cell, use the SUM function. Hence option 1 is correct.
• Write the sum function in the formula bar as =SUM(value1, value2). Here values indicate the reference of the cell.
• If you want to add two numbers in the cells A2 and A15, then write the formula as =SUM(A2:A15).
• To calculate the sum of values present in cells from A2, A15 and B2, B15, use =SUM(A2:A15, B2:B15).

Additional Information

• The COUNT function provides the number of entries in the range of the given cells. Its syntax is COUNT(value1, value2...).
• If you have an array from A1 and A10, use the formula =COUNT(A1:A10), this gives you the output as 10.
• IF function in Excel lets you make logical comparisons between different values. It gives the results as True/False.
• 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.

The correct answer is Domain Name System.

Key Points

DNS is an acronym for Domain Name System.

• The Domain Name System (DNS) is the phonebook of the Internet. Humans access information online through domain names, like testbook.com or espn.com. Web browsers interact through Internet Protocol (IP) addresses. DNS translates domain names to IP addresses so browsers can load Internet resources.
• Each device connected to the Internet has a unique IP address which other machines use to find the device. DNS servers eliminate the need for humans to memorize IP addresses such as 192.168.1.1 (in IPv4), or more complex newer alphanumeric IP addresses such as 2400: cb00: 2048: 1:: c629: d7a2 (in IPv6).

Additional Information 

• The process of DNS resolution involves converting a hostname (such as www.testbook.com) into a computer-friendly IP address (such as 104.20.37.240). An IP address is given to each device on the Internet, and that address is necessary to find the appropriate Internet device - like a street address is used to find a particular home. When a user wants to load a webpage, a translation must occur between what a user types into their web browser (testbook.com) and the machine-friendly address necessary to locate the testbook.com webpage.
• In order to understand the process behind the DNS resolution, it’s important to learn about the different hardware components a DNS query must pass between. For the web browser, the DNS lookup occurs “behind the scenes” and requires no interaction from the user’s computer apart from the initial request.

The correct answer is Web pages for information using specified search terms

Key Points

• A search engine is a web-based tool that enables users to locate information on the World Wide Web. Popular examples of search engines are Google, Yahoo!, and MSN Search. Search engines utilize automated software applications (referred to as robots, bots, or spiders) that travel along with the Web, following links from page to page, site to site. The information gathered by the spiders is used to create a searchable index of the Web.

• Every search engine uses different complex mathematical formulas to generate search results. The results for a specific query are then displayed on the SERP. Search engine algorithms take the key elements of a web page, including the page title, content, and keyword density, and come up with a ranking for where to place the results on the pages.

• Each search engine’s algorithm is unique, so a top ranking on Yahoo! does not guarantee a prominent ranking on Google, and vice versa. To make things more complicated, the algorithms used by search engines are not only closely guarded secrets, they are also constantly undergoing modification and revision. This means that the criteria to best optimize a site must be surmised through observation, as well as trial and error — and not just once, but continuously.

The correct answer is Inconsistent use of slide masters and templates.

Key Points

• Inconsistent use of slide masters and templates can lead to a lack of uniformity in design, making the presentation appear unprofessional and reducing its credibility.
• Proper use of slide masters ensures consistent formatting, including font styles, colors, and layouts throughout the presentation.
• Templates provide a structured and visually appealing design, contributing to the clarity and impact of the presentation.
• Disorganized or conflicting slide designs may distract the audience, undermining the content's effectiveness and overall message delivery.
• Maintaining design consistency aligns with best practices for creating high-quality presentations that convey professionalism and attention to detail.

Additional Information

• Slide Masters:
• Slide masters are pre-designed layouts that control the appearance of slides in a presentation.
• Using slide masters ensures uniformity in font styles, colors, and layout across multiple slides.
• They save time by allowing users to apply consistent formatting without manually editing each slide.
• Templates:
• Templates are pre-designed slide decks that provide a cohesive visual structure.
• They allow users to focus on content creation rather than design elements.
• Templates are especially useful for maintaining brand identity in corporate presentations.
• Best Practices for PowerPoint Presentations:
• Limit the use of animations and transitions to avoid distracting the audience.
• Ensure text is legible by using appropriate font sizes and contrasting colors.
• Include visuals like charts and images to complement the content and aid understanding.
• Proofread content thoroughly to avoid grammatical errors or inconsistencies.
• Impact of Poor Design:
• Poor design choices can divert attention from the presentation's core message.
• It may result in disengagement from the audience and a loss of credibility.
• Professionally designed presentations foster trust and enhance the speaker's authority.

The correct answer is Joint Photographic Experts Group (JPEG).

Key Points

• JPEG stands for Joint Photographic Experts Group.
• JPEG is a standard image format for containing lossy and compressed image data.
• JPEG is a unique compression feature, that allows JPEG files to be used widely on the Internet, Computers, and Mobile Devices.

Additional Information 

• Some important abbreviations used in Computer:
• BIOS - Basic Input Output System
• CAD - Computer-Aided Design
• EDVAC - Electronic Discrete Variable Automatic Computer
• EPROM - Erasable Programmable Read-Only Memory
• FORTRAN - FORmula TRANslation
• GPRS - General Packet Radio Service