Computer MCQs for Competitive Exams

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.

The Protect Document option in MS Word is found within the Review tab of the Ribbon. This tab is dedicated to tools for collaboration, proofing, tracking changes, and ensuring document security and integrity, making it the logical place for protection features.

• The Home tab contains basic editing, formatting, and styling options.
• The References tab is used for managing citations, bibliographies, tables of contents, and indexes.
• The term "Edit" is not a standalone tab in the Ribbon; editing functionalities are distributed across various tabs, primarily the Home tab.

Shimmer, Sparkle text, and Blinking Background are all visual enhancements applied to text or backgrounds to make them more dynamic or attention-grabbing. These are collectively known as Text effects. They go beyond basic formatting to add animation or special visual properties.

• Option A, "WordArt," is a specific feature for creating stylized text, but these are broader effects.
• Option B, "Font styles," refers to basic formatting like bold, italic, or underline, not animations.
• Option D, "Badge," is unrelated and typically refers to a small graphic or icon.

The functions of Copy and Paste are essential for duplicating or moving content within a document or between applications. In MS Word, these functions, along with Cut, reside in the Clipboard group on the Home tab. The Clipboard acts as a temporary storage area for the copied or cut content.

• Option A, "Home," is the tab itself, not the specific group.
• Option B, "Paragraph," is a group for paragraph-level formatting.
• Option C, "Style," is a group for applying predefined text styles.

Cookies in a web browser are small text files stored on a user's device by websites they visit. Their primary purpose is Storing user data and preferences. This allows websites to remember information about the user, such as login status, shopping cart contents, or personalized settings, for a more convenient browsing experience.

• Option A, "Cleaning the browser cache," is incorrect; cookies are distinct from the cache.
• Option B, "Displaying advertisements," is a secondary use by advertisers, not the fundamental function of cookies themselves.
• Option D, "Blocking pop-ups," is a browser setting, not a function of cookies.

To apply the formatting of one section or object to another without copying the actual text, the correct tool to use is the Format Painter. This tool allows you to copy only the formatting attributes (like font, size, color, paragraph spacing) and apply them elsewhere.

• Option A, "Copy-Paste," copies both the content and its formatting.
• Option C, "Format Text Box," is specific to the properties of a text box, not general formatting transfer.
• Option D, "Page Setup," is used for configuring page layout, margins, and orientation, not for copying formatting between elements.

The World Wide Web (WWW) is a system of interlinked hypertext documents accessed via the Internet. Its primary function is to access and share information globally through web browsers.

• "Sending e-mails" (A) is a function of email protocols (like SMTP, POP3, IMAP), not the WWW itself, although email clients can be accessed via the web.
• "File printing" (B) is a local or network printer function, not directly related to the WWW's core purpose.
• "Operating system functions" (D) refer to the core tasks managed by an OS (e.g., memory, process, file management), which are distinct from the WWW's role as an information system.

Bandwidth is the correct answer. It is a fundamental concept in computer networking, representing the maximum rate of data transfer across a given path or network connection. A higher bandwidth allows for more data to be transmitted per unit of time, directly impacting network performance and speed.

• Search engines (A) are software systems designed to find information on the World Wide Web.
• Web browsers (B) are applications used to access and view websites.
• Email servers (C) are computer systems that manage the sending and receiving of email messages.

None of the distractors relate to the measurement of data transmission capacity, which is precisely what bandwidth defines.