Computer MCQs for Competitive Exams

The correct answer is = (equals sign). In Microsoft Excel, every formula must begin with an equals sign. This fundamental rule signals to Excel that the cell contains a calculation to be performed, rather than just text or a number.

• + (plus sign) can be used within a formula for addition, but it cannot initiate a formula on its own.
• $ (dollar sign) is used for absolute cell referencing, fixing a row or column reference when copying formulas, but it doesn't start a formula.
• @ (at symbol) is not typically used to start a standard Excel formula; it's more common in some programming contexts or specific Excel functions like structured references in tables.

The correct answer is Title Bar. The title bar is a standard graphical user interface element located at the very top of most application windows. Its primary function is to display the name of the open document or program, providing immediate context to the user.

• The Menu Bar is typically located below the title bar and contains drop-down menus (e.g., File, Edit, View) for accessing commands.
• The Status Bar is found at the bottom of a window and displays information about the current state of the program or document.
• The Tool Bar (or Ribbon in modern applications) contains buttons and icons for quick access to frequently used commands.

The question asks which option cannot be used to close the entire MS Word application. Understanding the difference between closing a document and closing the application is crucial.

• "From File menu choose Close submenu" is the correct answer because this action typically closes only the currently active document, leaving the MS Word application itself open. You would still see the Word interface, ready to open a new document or work on another.
• "Choosing File menu then Exit submenu" is a direct command to terminate the application.
• "Press Alt + F4" is a universal Windows shortcut to close the active application window.
• "Click X button on title bar" is the standard graphical user interface method to close any application window.

Therefore, 'Close' only affects the document, while 'Exit' or the other methods close the program.

In MS Excel, identifying the active cell's address is fundamental for navigation and formula creation. The question asks for the specific interface element that displays this address.

• The "Name Box" is the correct answer. Located to the left of the Formula Bar, it prominently displays the reference (e.g., A1, B5) of the currently selected cell or the first cell in a selected range. It also allows users to name ranges and quickly navigate to specific cells.
• The "Title Bar" shows the workbook's name and the application name.
• The "Formula Bar" displays the actual content or formula of the active cell.
• The "Status Bar" provides information about the current state of the workbook, such as calculation modes or zoom level, but not the active cell's address.

Keyboard shortcuts are essential for efficient navigation and multitasking in operating systems. Knowing common shortcuts can significantly improve productivity.

• A: Ctrl + Tab is typically used to switch between tabs within a single application, such as browser tabs or document tabs.
• B: Alt + F4 is used to close the currently active window or application.
• C: Alt + Tab is the correct answer. This shortcut is universally used in Windows to cycle through and switch between all open application windows, allowing users to quickly navigate between different tasks.
• D: Shift + Esc does not have a standard function for switching between open applications in Windows; it might be used for specific functions within certain programs.

The Zoom feature in MS Word 2016 allows users to adjust the magnification of the document view. It is conveniently accessible from multiple locations within the application interface.

• The "View tab" in the Ribbon contains a dedicated "Zoom" group, offering various options to control the document's display size, including specific percentages and page views.
• Additionally, the "Status bar", located at the very bottom of the Word window, provides a quick and interactive zoom slider along with a percentage display. This allows for rapid adjustments without navigating through tabs.
• The "Home tab" is primarily for text formatting and editing, not zoom.

Since Zoom controls are present in both the View tab and the Status bar, "Both A & C" is the accurate answer.

MS Excel offers various features to streamline data entry and manipulation. Understanding these tools helps in efficient spreadsheet management.

• A: Auto Complete helps complete text entries in a cell based on existing entries in the same column, but it doesn't generate a series of data.
• B: Auto Fill is the correct answer. This feature intelligently recognizes patterns and extends a series of data (like numbers, dates, or days of the week) into adjacent cells, often by dragging the Fill Handle.
• C: Fill Handle is the small square at the bottom-right corner of a selected cell or range that you drag to activate the Auto Fill feature, but it is not the feature itself.
• D: Sorting arranges data in a specific order (e.g., alphabetical or numerical), which is different from completing a series.

PowerPoint offers various views to help users create, organize, and present their slides effectively. The question specifically asks for the view that focuses solely on the textual content.

• The "Outline view" is the correct answer. This view displays the presentation's text content—titles and main bullet points—in an outline format on the left pane. It's ideal for organizing thoughts, structuring content, and quickly editing text without visual distractions from graphics or slide layouts.
• "Slide show" view is for presenting the slides in full-screen.
• "Slide sorter view" displays thumbnails of all slides for easy rearrangement.
• "Notes page view" shows one slide with its associated speaker notes.

The keyboard shortcut Ctrl + Q in Microsoft Word is specifically designed to remove paragraph formatting. This includes resetting line spacing, paragraph spacing, and indents to the default style of the document or the selected text. It's a quick way to clear custom paragraph settings.

• Option A is correct because Ctrl + Q performs this exact function.
• Option B is incorrect; closing Word without saving typically involves Alt + F4 or File > Exit, often prompting for saving.
• Option C is incorrect; printing is usually initiated with Ctrl + P, and confirmation is standard.
• Option D is incorrect as the shortcut has a defined function.

In MS PowerPoint, controlling how slides advance during a presentation is a key aspect of delivery. The 'On mouse click' option determines manual slide progression.

• The "Transition & On mouse click" option is the correct answer. The 'Transitions' tab in the PowerPoint Ribbon is dedicated to defining how one slide moves to the next. Within this tab, in the 'Advance Slide' group, users can select 'On Mouse Click' to ensure that slides only advance when the presenter manually clicks the mouse or presses a key, providing control over the pace of the presentation.
• The 'Insert' tab is for adding objects like images or charts.
• The 'Format' tab is for styling selected objects.
• Therefore, options A, B, and D are incorrect as they do not relate to slide advancement settings.

File extensions are crucial for identifying the type of file and the application it's associated with. The .ppt extension (and its newer counterpart, .pptx) is universally recognized as the standard file format for presentations created using Microsoft PowerPoint.

• Option C, MS PowerPoint, is correct because it is the application that creates and uses files with the .ppt extension.
• Option A, MS Word, uses .doc or .docx for documents.
• Option B, MS Excel, uses .xls or .xlsx for spreadsheets.
• Option D, MS Access, uses .mdb or .accdb for databases.

In Microsoft Excel, extending a selection involves using the Shift key in combination with arrow keys. This allows users to quickly select a range of cells.

• Shift + Down Arrow is the correct shortcut to extend the current selection downwards by one cell. Holding Shift while pressing an arrow key extends the selection in that direction.
• Ctrl + Shift + Right Arrow extends the selection to the last non-empty cell to the right.
• Alt + Down Arrow is often used to open drop-down lists or filter menus.
• Ctrl + Down Arrow moves the active cell to the last non-empty cell in the current column downwards, without extending the selection.

Graphics typically consume the most memory because they are composed of many individual pixels, each requiring data to define its color and intensity. High-resolution images or complex 3D models contain vast amounts of pixel data, leading to significant memory usage.

• "Text" (A) and "Numbers" (B) are represented by character codes (e.g., ASCII, Unicode) or numerical formats, which are very compact.
• "Symbols" (D) are also character-based and require minimal memory, similar to text. The complexity and detail of graphical data far exceed that of simple textual or numerical representations.

The primary function of the Windows Task Manager is process and resource management. It allows users to monitor running applications, processes, and services, view system performance (CPU, memory, disk, network usage), and manage startup programs. Users can also end unresponsive tasks.

• "File management" (A) is handled by File Explorer.
• "System configuration" (B) is typically done through the Control Panel or Settings app.
• "Disk cleanup" (D) is a utility specifically designed to free up disk space, not the main role of Task Manager.

In many typical LAN systems, especially client-server architectures, the operation mainly depends on the server. The server provides centralized resources, services, and data to client nodes, managing network access, security, and shared applications. Without a server, many network functions would be unavailable or decentralized.

• A "Node" (A) is any device connected to the network, but it doesn't dictate the network's overall operation.
• A "Hub" (B) is a basic networking device that connects multiple devices, but it's a passive component and doesn't manage operations like a server. Modern LANs often use switches instead of hubs.
• A "Ring" (D) refers to a network topology, not a device that dictates operation. While a ring topology connects devices, the server still provides the core services.

In Microsoft Word, the keyboard shortcut Shift + F3 is used to cycle through different text cases for selected text: Sentence case, lowercase, and UPPERCASE. This is a highly efficient way to adjust text formatting without using the mouse.

• "Ctrl + Shift + A" (A) is used to toggle all caps for selected text.
• "Ctrl + F3" (C) is used to cut selected text to the Spike (a special clipboard).
• "Alt + F3" (D) is used to create a new building block from selected text. Therefore, Shift + F3 is the specific shortcut for changing case cyclically.

In Microsoft Excel, a range refers to a collection of two or more cells. It is typically represented by the cell address of the top-left cell, followed by a colon, and then the cell address of the bottom-right cell. Therefore, B1:B2 correctly denotes a range encompassing cells B1 and B2.

• "A1" (A) represents a single cell, not a range.
• "#REF!" (B) is an error message indicating an invalid cell reference.
• "100" (D) is a numerical value, not a cell reference or a range. Understanding ranges is fundamental for performing calculations and applying formatting to multiple cells simultaneously.

Kerning is a fundamental typographic concept that involves adjusting the space between specific pairs of characters to achieve a visually pleasing and evenly spaced appearance for an entire word. This feature is crucial for professional document presentation, preventing awkward gaps or overlaps between letters like "VA" or "To".

• Spacing is a general term for the distance between elements, not specifically character pairs for visual balance.
• Positioning refers to the placement of text blocks or objects on a page, not the fine-tuning of space between individual characters.
• Scaling involves changing the overall size of characters or objects, rather than their inter-character spacing.

The process of arranging data in a logical sequence, such as alphabetical, numerical, or chronological order, is known as Sorting. This is a core data management function that helps in organizing and analyzing information efficiently.

• Filtering involves displaying only the data that meets specific criteria, hiding the rest, but it does not rearrange the order of the data.
• Grouping organizes data into categories based on common attributes, but it doesn't necessarily sequence the entire dataset in a logical order.
• Formatting refers to changing the appearance of data, such as font, color, or cell borders, without altering its underlying order or content.

MS Word is categorized as Application Software. This type of software is designed to perform specific tasks for the end-user, such as word processing, creating spreadsheets, or browsing the internet. It directly helps users accomplish productive work.

• System Software manages computer hardware and software resources, like operating systems (e.g., Windows, macOS).
• Programming Software provides tools for developers to write, test, and debug computer programs (e.g., compilers, debuggers).
• Utility Software helps maintain and optimize computer performance (e.g., antivirus programs, disk defragmenters).

Email communication relies on specific protocols to ensure messages are sent and received across different networks. The question asks for the protocol responsible for providing email facilities between hosts.

• "SMTP" (Simple Mail Transfer Protocol) is the correct answer. SMTP is the standard protocol used for sending and routing email messages between mail servers. When you send an email, your email client typically uses SMTP to send it to your outgoing mail server, which then uses SMTP to relay it to the recipient's mail server.
• "HTTP" (Hypertext Transfer Protocol) is used for accessing web pages.
• "FTP" (File Transfer Protocol) is used for transferring files between computers.
• "SNMP" (Simple Network Management Protocol) is used for managing network devices.

Thus, SMTP is fundamental for email delivery on the internet.

In MS Excel, the COUNTIF function is specifically designed to count the number of cells within a specified range that meet a single given condition or criterion. This is incredibly useful for conditional data analysis.

• COUNTIFB is not a standard or recognized function in MS Excel.
• COUNTA counts the number of cells in a range that are not empty, regardless of their content type (numbers, text, errors).
• COUNT counts the number of cells in a range that contain only numbers. It ignores empty cells and cells containing text or logical values.

In spreadsheet applications like MS Excel, the fundamental unit where data is entered is called a Cell. It represents the intersection of a specific row and a specific column, uniquely identified by its address (e.g., A1, B5). This is where all data, formulas, and functions reside.

• Option A, "Box," is too generic and not the precise term used in spreadsheets.
• Option B, "Field," is typically used in database contexts to refer to a category of information.
• Option D, "Sheet," refers to the entire grid of cells, which is the complete workspace, not the individual intersection.

The keyboard shortcut Alt + = is used in Excel to quickly create a formula that sums all the cells directly above the active cell. This feature, known as AutoSum, automatically inserts the SUM function and selects the most probable range of cells to be summed, saving time and effort.

• Alt + S is not a standard shortcut for AutoSum in Excel.
• Ctrl + = is typically used for subscript formatting in some applications, not for summing cells in Excel.
• Shift + = is used to type the equals sign, which is the starting character for any formula in Excel, but it does not automatically insert the SUM function or select a range.

Gmail, Hotmail (now Outlook.com), and Yahoo Mail are all prominent examples of Email servers. These services provide the infrastructure for sending, receiving, and storing electronic mail messages for users. They host user accounts and manage the communication protocols necessary for email exchange.

• Option A, "Search engines" (like Google Search or Bing), are used to find information on the internet.
• Option B, "Web browsers" (like Chrome or Firefox), are software applications used to access and view websites.
• Therefore, "None of these" is incorrect as "Email servers" accurately describes them.