Search Previous Year Questions

The correct answer is Count().

Key Points

• The Count() function is used to count the number of cells that contain numbers within a specified range.
• It does not count empty cells or cells that contain text or logical values like TRUE or FALSE.
• For example, if you have a range of cells A1:A10, and some cells contain numbers while others are empty or have text, Count(A1:A10) will only return the count of cells with numbers.
• This function is particularly useful for quickly determining the number of numeric entries in a dataset.
• The syntax for the Count() function is straightforward: Count(range).
• Using this function can help in statistical analysis, data validation, and other functions where numeric counts are necessary.

Additional Information

• If you need to count cells based on specific criteria, you can use the Countif() function.
• For summing up numbers, the Sum() function is used, and for conditional summing, the Sumif() function is applicable.
• The Count() function is available in various spreadsheet software like Microsoft Excel, Google Sheets, and others.
• The Count() function can also be combined with other functions for more complex data analysis.

The correct answer is CSV.

Key Points

The correct answer is FTP.

• FTP  is a type of application software used for communication.

Key Points

The correct answer is Shift + F5.

Key Points

This table lists the most frequently used shortcuts in PowerPoint for Windows:

The correct answer is Application

Key Points

• An application, or application program, is a software program that runs on your computer. Web browsers, e-mail programs, word processors, games, and utilities are all applications. The word "application" is used because each program has a specific application for the user.
• In contrast, system software consists of programs that run in the background, enabling applications to run. These programs include assemblers, compilers, file management tools, and the operating system itself. Applications are said to run on top of the system software since the system software is made of "low-level" programs. While system software is automatically installed with the operating system, you can choose which applications you want to install and run on your computer.
• Macintosh programs are typically called applications, while Windows programs are often referred to as executable files. This is why Mac programs use .APP file extension, while Windows programs use the .EXE extension. Though they have different file extensions, Macintosh and Windows programs serve the same purpose and can both be called applications.

Key Points

• Multimedia is the name given to those applications that combine text, sound, graphics, motion video, and animation.
• Multimedia means that computer information can be represented through audio, video, and animation in addition to traditional media.
• A multimedia is a form of communication that combines different content forms such as text, audio, images, animations, or video into a single interactive presentation, in contrast to traditional mass media which featured little to no interaction from users, such as printed material or audio recordings.

Additional InformationMotion Ware is software that allows for the set-up, download, and analysis of data captured using the Motion Watch 8 or PRO-Diary hardware.

Hence, the correct answer is Multimedia.

The correct answer is Clear Formatting.

Key Points

• The "Clear Formatting" option allows you to quickly remove all applied formatting (like bold, italics, font size, color, etc.) from the selected text while preserving the actual text content.
• It can be found under the Home tab in the Font group, represented by an eraser icon labeled "Clear Formatting."
• You can also use the keyboard shortcut Ctrl + Spacebar to clear character formatting or Ctrl + Q to clear paragraph formatting.
• This feature is useful when you want to revert text to the default formatting without manually changing individual formatting elements.
• It removes custom formatting but retains the document's underlying style settings, such as the default font and paragraph styles set for the document.

Additional Information

• Cut function in MS Word
• The Cut function removes the selected text or object from its original location and places it in the clipboard, allowing you to paste it elsewhere in the document.
• You can quickly perform the Cut action using the keyboard shortcut Ctrl + X.
• The Cut option is typically used when you want to relocate content within the document or transfer it between documents.
• Paste Special in MS Word
• The Paste Special feature allows you to paste copied content in various formats, such as plain text, formatted text, or an image, depending on how you want the content to appear.
• You can access Paste Special by using the keyboard shortcut Ctrl + Alt + V or by selecting it from the Paste drop-down in the Home tab.
• It is useful when you need to control how content is pasted, for example, when you want to paste data as unformatted text or as a specific object, such as a picture or HTML content.
• Format Painter in MS Word
• Format Painter is a tool that allows you to copy formatting (such as font, color, size, and style) from one section of text and apply it to another, making formatting consistent across the document.
• It is located in the Home tab under the Clipboard group, represented by a paintbrush icon.
• You can use Format Painter by selecting the text with the desired formatting, clicking the Format Painter icon, and then selecting the text you want to apply the formatting to. Double-clicking the icon allows you to apply formatting to multiple sections.

Plug-in can be executed outside the web browser is incorrect.

Key Points

• A plugin is software that acts as an add-on to a web browser and gives the browser additional functionality.
• For example, Macromedia Flash Player is a plugin that allows the web browser to display animations using the Flash format.
• Since plug-ins act as extensions of web browsers, they cannot be executed outside it.​​
• Adobe Flash Player plug-in can be used to play videos, games, and other interactive content.

Additional Information

• An ActiveX control is a small program that other applications can reuse to enable the same functionality without extra development work.
• These controls typically have been implemented as plugins to enhance various types of web applications.

The correct answer is Open Source

Key Points

• Open Source Software -
• This refers to software whose source code is freely available and can be modified or distributed by anyone.
• Open source software is typically created as a collaborative effort in which programmers improve upon the code and share the changes within the community. Linux is an example of open source software.

Additional Information

• Application Software - This is a type of computer software designed to perform a group of coordinated functions, tasks, or activities for the benefit of the user. Examples include web browsers, word processors, and multimedia players.
• Adware - This is software that downloads or displays unwanted ads when a user is online, in some instances, it can be considered a type of malware (malicious software). Adware could lead to security vulnerabilities and slow system performance.
• Compiler - This is a type of software that transforms computer code written in one programming language (the source language) into another programming language (the target language). Essentially, it translates a human-readable programming language into a language that a computer can understand, enabling the code to be executed.

The correct answer is Herman Hollerith.

• Herman Hollerith is the Father of Data Processing.
• Data processing is the process of collection and manipulation of items of data to produce meaningful information.

Additional Information

• Alan Turing is the father of Computer science.
• Vinton Cerf is the father of the Internet.
• John McCarthy is the father of Artificial Intelligence.
• Important personalities and Inventions: