Computer MCQs for Competitive Exams

In the field of computing, acronyms are frequently used to represent complex terms concisely. Understanding these acronyms is crucial for anyone working with or studying computer systems and networks.

The correct answer is C: Network Operating System. An NOS is specialized software that runs on a server and enables it to manage network resources, users, security, and various other network-related functions. It facilitates communication and resource sharing among connected devices on a network. Examples include Windows Server, Linux, and Novell NetWare, which provide the infrastructure for client-server architectures and distributed computing.

• A: Node Open Software is not a recognized or standard acronym in computing terminology.
• B: Non-operating Software is a vague and incorrect term. Software either operates or it doesn't, but this phrase does not denote a specific category or type of software in the computing lexicon.
• D: None of these is incorrect because 'Network Operating System' is indeed the correct and widely accepted meaning of NOS in computing.

The question asks to identify which option is NOT a valid version of Microsoft Office. Microsoft Office is a widely used suite of productivity software developed by Microsoft, including applications like Word, Excel, and PowerPoint. Over the years, Microsoft has released numerous versions of this suite.

The correct answer is Office Vista. This is because "Vista" refers to Windows Vista, which was an operating system released by Microsoft, not a version of the Microsoft Office suite. Operating systems manage computer hardware and software resources, while Office is application software that runs on an operating system.

• Office 2007 was a significant version of Microsoft Office, introducing the Ribbon interface.
• Office 2016 is another valid, perpetual license version of the Office suite.
• Office 365 (now largely rebranded as Microsoft 365) is a subscription service that provides access to the latest versions of Office applications, cloud services, and other features.

Therefore, Office Vista is the only option that does not represent a version of Microsoft Office, making it the correct answer.

Every software application, including Microsoft Word, is launched by a specific executable file. Knowing the name of this file can be useful for troubleshooting or creating custom shortcuts.

The correct answer is A: Winword.exe. This is the official and historical executable file name for Microsoft Word. The "WIN" prefix signifies its origin as a program designed for the Windows operating system, a naming convention that has been maintained across many versions of Word. When you click the Word icon on your desktop or in the Start menu, it is this specific file that the operating system executes to launch the application.

The other options are common misconceptions or plausible but incorrect guesses. Word.exe (B) is a logical but inaccurate simplification; the full name includes the "WIN" prefix. Msword.exe (C) is also incorrect; while the product is known as MS Word, the executable file does not incorporate "MS" in its name. Word356.exe (D) is incorrect because "365" refers to the Microsoft 365 subscription service, not the core executable file name itself. The executable file name remains consistent regardless of the licensing model.

Function keys (F1 through F12) on a computer keyboard are designed to perform specific tasks, often acting as shortcuts within operating systems and applications. Their functions can sometimes vary between programs, but many have widely recognized standard uses.

The correct answer is B: F5. The `F5` key is almost universally used to refresh the active window or web page in most operating systems (like Windows Explorer) and web browsers (such as Chrome, Firefox, and Edge). Pressing `F5` reloads the content, ensuring that the most current version of the page or folder contents is displayed.

• A: F4 is often used in conjunction with the `Alt` key (`Alt + F4`) to close the active window or application. In some applications, it might repeat the last action.
• C: F8 is commonly associated with accessing advanced boot options in Windows, such as Safe Mode, during system startup.
• D: F9 has various uses depending on the application; for instance, it recalculates formulas in Microsoft Excel or sends/receives emails in Microsoft Outlook, but it is not used for refreshing a window.

This question tests knowledge of common file extensions associated with Microsoft Office applications. File extensions are suffixes added to the end of a file name, typically after a dot, which indicate the file's format or type. This helps the operating system determine which program should open the file.

The correct answer is ppt. The .ppt extension stands for PowerPoint Presentation and was the standard file format for Microsoft PowerPoint presentations prior to Office 2007. While newer versions primarily use .pptx, .ppt remains a valid and recognized extension for PowerPoint files, especially for compatibility with older software versions.

• xls is the file extension for Microsoft Excel spreadsheets, used for organizing and analyzing data.
• docx is the file extension for Microsoft Word documents, used for creating text-based documents.
• tts is not a standard or common file extension for Microsoft Office files. It is sometimes associated with text-to-speech files or other specific applications, but not PowerPoint.

Understanding file extensions is crucial for managing and identifying different types of digital documents.

Acronyms are prevalent in technology, representing complex concepts with concise abbreviations. Understanding these acronyms is fundamental to comprehending technical discussions and documentation.

The correct answer is B: Application Programming Interface. An API is a set of defined rules, protocols, and tools for building software applications. It specifies how software components should interact, allowing different software programs to communicate with each other. For example, when you use an app on your phone, it often uses APIs to connect to external services, like fetching weather data or processing payments, without the app developer needing to build those functionalities from scratch. APIs are crucial for modern software development, enabling modularity and integration.

The other options are plausible-sounding but incorrect. Algorithmic Protocol Interface (A), Adapter Protocol Interface (C), and Accelerated Programming Interface (D) are all fabricated terms that do not correspond to the widely accepted and industry-standard definition of API. These distractors are designed to sound technically relevant but do not represent the actual meaning of the acronym.

A firewall is a crucial network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules. Its primary function is to establish a barrier between a trusted internal network (like a server) and untrusted external networks (like the internet), thereby preventing unauthorized access. It acts as a gatekeeper, allowing only legitimate traffic to pass while blocking suspicious or unwanted connections.

In contrast, Antivirus software is designed to detect, prevent, and remove malicious software such as viruses, worms, and Trojans, but it doesn't regulate network traffic or block unauthorized access attempts at the network perimeter. A Gateway is a network device that connects two different networks, often performing protocol translation, facilitating communication but not inherently providing the access control functions of a firewall. Flow control is a mechanism used in data communication to manage the rate of data transmission between two nodes to prevent a fast sender from overwhelming a slow receiver, focusing on data integrity and efficiency rather than security against unauthorized access. Therefore, the firewall is the dedicated solution for protecting against unauthorized network access.

Keyboard shortcuts are invaluable for improving efficiency and speed when working with software applications. Many shortcuts are standardized across different programs, making them intuitive to learn and use.

The correct answer is A: Create a new document. The "Ctrl + N" shortcut is a widely recognized and standard command across a multitude of applications, including word processors like Microsoft Word, web browsers, and image editing software. The 'N' in this shortcut typically stands for 'New', signifying its function to open a new, blank document, file, or window within the application. This allows users to quickly start fresh without navigating through menus.

Let's examine why the other options are incorrect. Save document (B) is almost universally achieved using the "Ctrl + S" shortcut. Open document (C) is typically performed with the "Ctrl + O" shortcut, which brings up a dialog box to select an existing file. Close document (D) is usually done with "Ctrl + W" (to close the current tab or document) or "Alt + F4" (to close the entire application window). Each of these common actions has its own distinct and widely adopted keyboard shortcut, making "Ctrl + N" specific to creating new content.

In Microsoft Excel, to move an entire column from one location to another, you must use the Shift key in conjunction with dragging. First, select the entire column you wish to move. Then, position your mouse cursor over the border of the selected column until it changes into a four-headed arrow. While holding down the Shift key, click and drag the column to its new desired position. Releasing the mouse button and then the Shift key will insert the column into the new spot, shifting existing columns to accommodate it.

Using the Ctrl key while dragging a selected column would copy the column instead of moving it. The Alt key is typically used for accessing ribbon shortcuts or specific functions in combination with other keys, but not for this drag-and-drop column movement. The Tab key is used for navigating between cells to the right or between fields in a dialog box, not for manipulating entire columns. Thus, Shift is the correct key for moving columns.

Authentication is the process of verifying the identity of a sender or user. In the context of email, it ensures that the message truly originated from the claimed sender and has not been altered. The correct answer is Digital Signature.

• Digital Signature: A digital signature uses cryptographic techniques to provide authenticity, integrity, and non-repudiation for an email. The sender signs the email with their private key, and recipients use the sender's public key to verify the signature. This process confirms the sender's identity and guarantees that the email content has not been tampered with since it was signed.
• Password: A password authenticates a user to an email *account* or service (e.g., logging into Gmail), but it does not authenticate individual email messages sent from that account.
• Encryption: Encryption protects the *confidentiality* of an email, making its content unreadable to unauthorized parties. While vital for security, encryption alone does not verify the sender's identity or ensure message integrity.
• Spam alert: A spam alert is a system designed to identify and filter unsolicited or malicious emails. It's a filtering mechanism, not a method for authenticating the sender of a legitimate email.

In most text editing applications, including Microsoft Word, the keyboard shortcut Ctrl + Left Arrow is used to move the cursor one word to the left. This allows for much faster navigation through text compared to moving character by character with just the Left Arrow key alone. It's a fundamental shortcut for efficient text editing, enabling users to quickly jump between words without having to repeatedly press the single arrow key.

Let's look at the incorrect options: Moving the cursor to the beginning of the line is typically achieved by pressing the Home key. Moving one paragraph up is usually done with Ctrl + Up Arrow. Similarly, moving one paragraph down is accomplished with Ctrl + Down Arrow. These shortcuts demonstrate how the Ctrl key, combined with arrow keys, provides enhanced navigation capabilities beyond simple character or line movements, making 'Move one word left' the accurate function for Ctrl + Left Arrow.

When working with lengthy documents, it's often necessary to quickly navigate to specific sections or points of interest. The most effective tool for this purpose is a bookmark. The correct answer is Bookmarks.

• Bookmarks: In word processing software like MS Word, a bookmark is a named location or selection of text that you identify for future reference. Once a bookmark is set, you can instantly jump to that exact spot from anywhere else in the document, saving time and improving navigation efficiency. They act like internal anchors within the document.
• Sub-documents: Sub-documents are used in master documents to break a large document into smaller, more manageable files. They are organizational units, not direct navigation points within a single document.
• Cross references: Cross-references link to other parts of the same document (e.g., a specific heading, figure, or page number). While they aid navigation, they require an existing element to link to, whereas bookmarks can mark any arbitrary spot.
• Outlines: Outlines provide a hierarchical view of a document's structure, typically based on headings. They are useful for organizing and navigating by section, but they don't allow marking specific, arbitrary locations within the text like bookmarks do.

The default page orientation for slides in Microsoft PowerPoint is Landscape. This means that the slide is wider than it is tall. This orientation is specifically chosen for presentations because it maximizes the horizontal space available for content, images, charts, and text, making it ideal for display on projection screens, monitors, and televisions, which are typically wider than they are tall. This design choice ensures that presentations are visually appealing and easy to read for an audience.

In contrast, Portrait orientation means the page is taller than it is wide. This is the default orientation for word processing documents, such as those created in Microsoft Word, as it is more suitable for reading and printing text-heavy documents. Vertical is synonymous with Portrait, and while Horizontal is synonymous with Landscape, 'Landscape' is the specific and correct terminology used within PowerPoint and other software applications to describe this orientation. Therefore, Landscape is the standard default for PowerPoint slides.

Document formatting involves various elements that control the visual presentation of text. One fundamental aspect is how lines of text are spaced vertically. The correct answer is Space between lines of text.

• Space between lines of text: Line spacing, also known as leading, refers to the vertical distance between the baselines of consecutive lines of text within a paragraph. Adjusting line spacing significantly impacts the readability and aesthetic appeal of a document. For example, single spacing provides minimal vertical separation, while double spacing adds a full line of empty space between each line of text, making the document appear less dense.
• Height of the line: While line spacing affects the overall visual height of a block of text, it is not the direct definition. The actual height of a line is primarily determined by the font size and the presence of ascenders and descenders in the characters.
• Width of the line: The width of the line refers to the horizontal extent of a line of text, typically controlled by page margins or column settings, not line spacing. Line spacing is a vertical measurement.
• Both A & B: Since 'Height of the line' is not the precise definition of line spacing, this option is incorrect. Line spacing is exclusively concerned with the vertical distance between lines.

In Microsoft Word and most other text editing applications, pressing the Enter key is the standard and most common action to start a new paragraph. When you press Enter, the cursor moves to the beginning of the next line, and a new paragraph mark is inserted. This paragraph mark carries its own formatting properties, such as line spacing, indentation, and alignment, allowing for distinct blocks of text.

Let's examine why the other options are incorrect: The Shift key is typically used for capitalization or, when combined with Enter (Shift + Enter), it inserts a soft return or a line break within the same paragraph, rather than starting a new one. The Alt key is generally used for accessing menu shortcuts or in combination with other keys for special characters or functions. Ctrl + Enter is a specific shortcut used to insert a page break, forcing the text after the cursor to begin on a new page, not just a new paragraph on the current page. Thus, the Enter key alone is the correct method for initiating a new paragraph.

Software can be broadly categorized based on its function. An operating system is a critical component that manages a computer's resources and provides a platform for other programs. The correct answer is System software.

• System software: An operating system (OS) is the most fundamental type of system software. It acts as an intermediary between the computer hardware and the user, managing all hardware and software resources. The OS performs essential tasks such as memory management, process scheduling, file management, and handling input/output operations. It provides the necessary environment for application software to run. Examples include Windows, macOS, Linux, Android, and iOS.
• Personal software: This term is too general and not a standard classification. While an OS is used on personal computers,
  

The question asks about the specific function key used to initiate a slideshow presentation. Understanding the common uses of function keys in software applications is key here.

The correct answer is F5. In most presentation software, such as Microsoft PowerPoint, pressing the F5 key is the standard and widely recognized shortcut to start a slideshow from the beginning. This allows presenters to quickly transition from editing mode to full-screen presentation mode.

• F1 is incorrect because it typically opens the help menu for the active program, providing assistance or documentation.
• F2 is incorrect as it is commonly used to rename a selected file or folder, or to edit a cell in spreadsheet programs like Excel.
• F10 is incorrect; it usually activates the menu bar in many applications, allowing navigation through menus using keyboard arrows, or can be combined with Shift to simulate a right-click.

Each function key serves a distinct purpose, and F5 is specifically assigned to starting a slideshow.

Typography involves the art and technique of arranging type to make written language legible, readable, and appealing. Word processing software like MS Word offers various tools for typographic correction and refinement. The correct answer is All of these.

• Underlining hyperlink: This is a common typographic convention that visually distinguishes clickable links from regular text. It's a design choice that enhances user experience by clearly indicating interactive elements.
• Adjusting extra space: This refers to correcting inconsistencies in spacing, such as removing double spaces between words or after punctuation, or adjusting kerning (space between individual characters). These adjustments contribute to a cleaner, more professional appearance and improved readability.
• Replacing two hyphens with em-dash: This is a specific typographic substitution. An em-dash (—) is a longer dash used for various grammatical purposes, such as indicating a break in thought, an emphatic pause, or a range. Replacing two consecutive hyphens (--) with an em-dash is a common typographic refinement that improves the visual flow and grammatical correctness of text.
• Since all the listed options are valid examples of refining the visual presentation and correctness of text, 'All of these' is the most accurate answer.

This question defines the term 'cursor' in the context of computer interfaces. It's important to distinguish between the visual indicator and the devices or components associated with it.

The correct answer is Thin blinking line. Specifically, an 'insertion point cursor' or 'text cursor' is represented as a thin, often blinking, vertical line or a block that indicates where the next character typed will appear on the screen. This is its primary visual form when interacting with text input fields.

• Pointing device is incorrect because a pointing device (like a mouse or trackpad) is the hardware used to control the cursor's position on the screen, but it is not the cursor itself. The cursor is the on-screen visual representation.
• Pixel is incorrect. A pixel is the smallest individual unit of a digital image or display. While a cursor is composed of many pixels, it is not a single pixel; it's a collection of pixels forming a specific shape or line.
• All of these is incorrect because options B and C are not accurate definitions of a cursor.

Therefore, the most precise description of a cursor, especially in text-based interactions, is a thin blinking line.

A drop cap is a large initial letter that drops below the first line of text, often used at the beginning of a paragraph or section to add visual emphasis and a touch of classic design, commonly seen in books and magazines. In most word processing applications, such as Microsoft Word, the default number of lines that a drop cap will occupy is 3. This standard setting provides a balanced aesthetic without being overly dominant or too subtle. While users can customize the number of lines a drop cap spans (e.g., to 1, 2, or 5 lines), these are not the default options. Choosing 1 line would essentially make it a larger initial letter rather than a true 'drop' cap, while 5 lines might be too large for typical document layouts. Therefore, 3 lines is the established and most common default.

The question asks to identify the type of software that organizes data into rows and columns. Different software applications are designed for specific data handling and presentation tasks.

The correct answer is C: Spreadsheet. Spreadsheet software, such as Microsoft Excel or Google Sheets, is specifically engineered to create, organize, analyze, and store data in a tabular format. This format inherently consists of a grid of rows and columns, with individual data points entered into cells at their intersections. Spreadsheets are widely used for financial calculations, data tracking, and various analytical tasks due to their structured layout and powerful functions.

• A: Database software manages large, structured collections of data, often using tables with rows and columns, but the software itself is not *called* 'rows and columns'; it's a system for data management.
• B: Drawing software (e.g., Adobe Illustrator, Paint) is used for creating and editing visual graphics and images, not for tabular data organization.
• D: Word Processing software (e.g., Microsoft Word) is designed for creating and editing text documents, focusing on text formatting, layout, and content, not structured data in rows and columns.

Thus, software built around the row-and-column structure is precisely what defines a spreadsheet application.

Text alignment is a fundamental formatting feature in word processing that controls how text is positioned horizontally between the margins. Center alignment places text an equal distance from both the left and right margins, often used for headings, titles, or short blocks of text to create a symmetrical appearance. The standard keyboard shortcut to apply center alignment in many applications, including Microsoft Word, is Ctrl + E. This shortcut efficiently toggles the selected text or current paragraph to be centered. The other options are incorrect: Ctrl + C is the universal shortcut for 'Copy' selected content. Ctrl + M is typically used for indenting paragraphs or creating a new slide in presentation software. Ctrl + L is the shortcut for 'Left Align' text, positioning it flush with the left margin.

The question concerns the method to completely close or exit the PowerPoint application window. Understanding the difference between closing a document and closing the application is crucial in Windows environments.

The correct answer is B: Double-click the application’s control menu icon. In Windows, every application window has a control menu icon (usually a small program icon) located at the top-left corner of the window title bar. Double-clicking this icon is a standard and quick method to send a 'close' command to the entire application, effectively shutting down PowerPoint and all its open presentations.

• A: Document close button (the 'X' on the document window) typically closes only the currently active presentation file, leaving the PowerPoint application itself running.
• C: Double-click the document control menu icon would also only close the current presentation, not the entire PowerPoint application.
• D: Minimize button (the underscore symbol) reduces the application window to the taskbar, keeping PowerPoint running in the background but not exiting it.

Therefore, to fully exit the PowerPoint program, double-clicking the application's control menu icon is the correct action.

In word processing and document navigation, various keyboard shortcuts allow users to move the cursor efficiently through a document. The Ctrl + Page Down shortcut is specifically designed to move the cursor to the beginning of the next logical page or the next full screen of content within the document. This is incredibly useful for quickly navigating through lengthy documents without having to scroll manually. While 'one screen down' might seem similar, 'one page down' more accurately reflects the typical behavior of this command, which often respects actual page breaks. The other options are incorrect: Moving 'one line down' is achieved by pressing the Down Arrow key. Moving 'one paragraph down' is typically done using Ctrl + Down Arrow. Therefore, Ctrl + Page Down is the precise command for advancing the cursor by one full page.

The question asks which menu in Excel is used to remove duplicate values. Microsoft Excel organizes its functionalities into various tabs on the Ribbon interface, each grouping related commands for specific tasks.

The correct answer is A: Data. The 'Data' tab on the Excel Ribbon is specifically dedicated to tools for managing, analyzing, and manipulating data within a worksheet. This tab contains commands for sorting, filtering, data validation, text to columns, and importantly, the 'Remove Duplicates' feature. This tool allows users to quickly identify and eliminate redundant entries from a selected range or table, which is essential for data cleaning and ensuring data integrity.

• B: Tools is incorrect. While older versions of Excel might have had a 'Tools' menu, modern Excel uses the Ribbon interface, and 'Tools' is not a standard tab for this function.
• C: Formatting is incorrect. The 'Formatting' commands (found primarily on the 'Home' tab) deal with the appearance of cells and data, such as fonts, colors, and borders, not with the structural manipulation or removal of data entries.
• D: Layout is incorrect. The 'Page Layout' tab is primarily concerned with page setup options for printing, including margins, orientation, and themes, not with data cleaning or manipulation.

Thus, for tasks involving data management like removing duplicates, the 'Data' tab is the appropriate menu.