Computer Science MCQS

Microsoft Word, along with other applications in the Microsoft Office suite (such as Excel and PowerPoint), primarily uses Visual Basic for Applications (VBA) to create macros. VBA is a programming language developed by Microsoft that is embedded within these applications. Macros written in VBA allow users to automate repetitive tasks, create custom functions, and extend the functionality of Office programs beyond their default capabilities. This enables users to streamline complex workflows, customize interfaces, and significantly boost productivity by tailoring the applications to their specific needs.

• A: Java: Java is a general-purpose programming language widely used for enterprise-level applications, Android development, and web services. It is not the native language used for creating embedded macros within Microsoft Office applications.
• B: C++: C++ is a powerful, high-performance programming language used for system programming, game development, and complex desktop applications. While Microsoft uses C++ extensively in developing its operating system and various applications, it is not the language provided for user-created macros in Word.
• D: Python: Python is a popular, high-level, general-purpose programming language known for its readability and versatility in areas like web development, data science, and scripting. Although Python can interact with Office applications through external libraries, it is not the native language for creating built-in macros.

The correct network protocol used to send email is SMTP, which stands for Simple Mail Transfer Protocol. SMTP is the industry-standard protocol for sending emails across the Internet. When you compose and send an email from your email client (e.g., Outlook, Gmail), your client communicates with your outgoing mail server using SMTP. This server then uses SMTP to relay the email to the recipient's mail server, which ultimately delivers it to the recipient's inbox. SMTP is solely responsible for the transmission aspect of email, ensuring messages are routed to their destination.

• A: POP3: Post Office Protocol version 3 (POP3) is used for retrieving emails from a mail server to a local email client. It allows users to download messages from the server, often deleting them from the server after download. It is for receiving, not sending, emails.
• B: FTP: File Transfer Protocol (FTP) is a network protocol used for transferring computer files between a client and server on a computer network. It is specifically designed for file transfers and is unrelated to email communication.
• D: SSH: Secure Shell (SSH) is a cryptographic network protocol used to operate network services securely over an unsecured network. It is commonly used for secure remote login, remote command execution, and secure file transfer (SFTP), but not for sending emails.

A Router is a crucial network device designed to connect two or more distinct network segments or subnets, forwarding data packets between them. Routers operate at the network layer (Layer 3) of the OSI model and are responsible for directing data traffic by making intelligent decisions about the best path for packets to travel based on IP addresses. For example, a router connects your home local area network (LAN) to the broader internet (a wide area network, WAN), enabling communication between devices in different networks. They are essential for inter-network communication and the functioning of the internet.

• B: Switch: A switch connects multiple devices within a single local area network (LAN) segment. It operates at the data link layer (Layer 2) and forwards data frames to specific destination devices based on their MAC addresses, but it does not connect different IP networks together.
• C: Primary Network: This term is a descriptive phrase that might refer to a main or central network, but it does not designate a specific type of network hardware device with the function of connecting segments.
• D: Topology: Network topology refers to the arrangement or structure of a network's connections, nodes, and devices. It describes the physical or logical layout (e.g., star, bus, mesh) of a network, rather than being a network device itself.

In SQL (Structured Query Language), Submit is NOT a valid keyword for database operations. SQL uses a well-defined set of commands to interact with databases. Keywords like DELETE, INSERT, and UPDATE are fundamental Data Manipulation Language (DML) commands that allow users to modify the data stored within database tables. While the concept of 'submitting' data might be familiar in web forms or application interfaces, it has no direct, standard SQL keyword counterpart for performing database transactions or data modification. Standard SQL uses `COMMIT` or `ROLLBACK` for transaction control, not `SUBMIT`.

• A: Delete: DELETE is a valid SQL command used to remove existing rows from a table based on specified conditions. It is a core DML operation.
• B: Insert: INSERT is a valid SQL command used to add new rows of data into a table. It is another fundamental DML operation for populating a database.
• C: Update: UPDATE is a valid SQL command used to modify existing data in one or more columns for rows that meet certain criteria within a table. It is also an essential DML operation.

In Microsoft Word, the default alignment for paragraphs is Left alignment. This means that text is aligned along the left margin, creating a straight, even left edge, while the right edge of the paragraph remains ragged or uneven. This is the most common and standard alignment for most Western languages because text is typically read from left to right. Word sets this as the default to provide the most conventional and readable format for users as they begin typing their documents, ensuring immediate familiarity and usability.

• A: Right: Right alignment aligns text along the right margin, leaving the left edge ragged. While useful for specific elements like dates, page numbers, or captions, it is not the default alignment for general body paragraphs in Word.
• B: Center: Center alignment positions text equidistant from both the left and right margins, resulting in both edges appearing ragged. This alignment is frequently used for titles, headings, or short lines of text for emphasis, but it is not the default for body text.
• C: Justify: Justified alignment evenly distributes text between both the left and right margins, making both edges straight. This alignment is commonly found in newspapers, magazines, and books for a formal and clean appearance, but it is not the default setting in Microsoft Word; it must be manually applied.

The correct answer is F5 because this function key is universally recognized and used in presentation software, such as Microsoft PowerPoint, to initiate a slide show from the beginning. Pressing F5 immediately launches the presentation into full-screen mode, allowing the presenter to begin delivering their content. This makes it a crucial shortcut for anyone giving a presentation.

• Option B, F1, is incorrect. F1 is typically used to open the help window or provide assistance in most applications, not to start a slide show.

• Option C, F3, is also incorrect. The F3 key often has varying functions depending on the software; in some applications, it might be used for searching or repeating the last action, but it does not start a slide show.

• Option D, F7, is incorrect. F7 is commonly associated with spell-checking and grammar-checking features in word processing and presentation applications, not for initiating a slide show.

The correct answer is Cell. In a computer worksheet application like Microsoft Excel, a cell is the fundamental unit where you input and store data, which can include text, numbers, formulas, or functions. Each cell is uniquely identified by its column letter and row number (e.g., A1, B5), forming the grid structure of the worksheet. It is the intersection point of a row and a column.

• Option A, Row, is incorrect. A row is a horizontal series of cells in a worksheet, identified by a number (e.g., Row 1, Row 2). While cells are part of a row, a row itself is not the basic unit for data entry.

• Option B, Column, is incorrect. A column is a vertical series of cells in a worksheet, identified by a letter (e.g., Column A, Column B). Similar to a row, a column contains multiple cells but is not the singular unit for entering text and numbers.

• Option D, Range, is incorrect. A range refers to a group or block of selected cells in a worksheet. While it involves cells, it is a collection of basic units rather than the basic unit itself.

The correct answer is Winzip. Winzip is a widely recognized and popular software utility specifically designed for file compression and archiving. It allows users to reduce the size of files and folders into a compressed format, typically the ZIP format. This compression saves storage space on a computer or server and significantly speeds up the transfer of files over networks or the internet, as smaller files take less time to upload or download. Beyond compression, Winzip also offers features for encryption and sharing of compressed files, making it a comprehensive tool for managing digital data efficiently.

Let's examine why the other options are incorrect:

• Adobe Reader: This software is used for viewing, printing, and annotating PDF (Portable Document Format) files. It does not perform file compression.
• VLC Media Player: VLC is a free and open-source cross-platform multimedia player that plays various audio and video file formats. Its primary function is media playback, not file compression.
• Microsoft Word: This is a powerful word processing application used for creating, editing, formatting, and saving text-based documents. While it can handle large document files, it does not serve as a general-purpose file compression utility for other types of files.

The correct answer is F2. In Microsoft Excel and similar spreadsheet programs, pressing the F2 key is the standard shortcut to edit the contents of the currently selected cell. When F2 is pressed, the cursor appears within the cell or in the formula bar, allowing you to modify the existing data or formula without having to retype everything from scratch. This significantly improves efficiency when making minor adjustments to cell entries.

• Option A, F1, is incorrect. The F1 key is typically used to open the help menu or provide assistance in most software applications, including Excel.

• Option C, F3, is incorrect. The F3 key generally does not have a direct function for editing a selected cell in Excel. Its functions vary across different applications and contexts, but cell editing is not one of its primary uses in spreadsheets.

• Option D, Edit, is incorrect.

The correct answer is Gigahertz. The speed of a CPU (Central Processing Unit) is primarily measured in Gigahertz (GHz). Gigahertz represents the clock speed of the processor, indicating the number of clock cycles the CPU can execute per second. A higher clock speed generally means the CPU can perform more operations and process instructions faster, contributing to the overall performance of the computer. Modern CPUs often operate in the range of several Gigahertz, providing immense processing power for complex tasks and applications.

Let's examine why the other options are incorrect:

• Megabytes: Megabytes (MB) are a unit of digital information, commonly used to measure the size of files, the capacity of RAM (Random Access Memory), or the amount of data stored on a hard drive. It measures size, not speed.
• Kilobytes: Kilobytes (KB) are also a unit of digital information, smaller than megabytes. Like megabytes, they are used to measure the size of data or storage capacity, not the processing speed of a CPU.
• bytes: Bytes are the fundamental unit of digital information, typically consisting of 8 bits. They are used to measure the size of data, such as characters or small files, but not the speed at which a CPU operates.

The correct answer is Archie. Archie is widely recognized as the first search engine for the internet, predating many of the more well-known search engines. It was created in 1990 by Alan Emtage, Bill Heelan, and J. Peter Deutsch at McGill University. Archie's purpose was to index FTP (File Transfer Protocol) archives, allowing users to efficiently search for specific files on the vast and growing internet. It automated the process of collecting directory listings from anonymous FTP sites, making it much easier for users to locate software and data.

Let's examine why the other options are incorrect:

• AltaVista: AltaVista was a very popular web search engine launched in 1995. While significant in its time for indexing a large portion of the web, it appeared several years after Archie.
• Yahoo: Yahoo! started in 1994, initially as a directory service named "Jerry and David's Guide to the World Wide Web." It later evolved into a search engine, but it was not the first.
• Google: Google was founded in 1998 by Larry Page and Sergey Brin. It revolutionized web search with its PageRank algorithm but was a much later development compared to Archie.

The correct answer is Brain. "Brain" is widely considered the first computer virus specifically designed for IBM PC compatible computers. It was created in 1986 by two Pakistani brothers, Basit and Amjad Farooq Alvi. The virus spread via floppy disks, infecting the boot sector of the disk. Their intention was reportedly to protect their medical software from piracy. Brain demonstrated how malicious code could self-replicate and spread between personal computers, marking a significant point in the history of cybersecurity threats for PCs.

Let's examine why the other options are incorrect:

• Melissa: Melissa was a fast-spreading macro virus that emerged much later in 1999. It specifically targeted Microsoft Word documents and spread through email, causing widespread disruption, but it was not the first PC virus.
• Trojan: A Trojan horse is a type of malicious software that disguises itself as legitimate software. It's a category of malware that deceives users into running it, rather than a specific first virus name. While early malicious programs existed, "Trojan" is a general classification, not a specific pioneer virus for PCs.
• Creeper: Creeper is often cited as the first computer worm, created in the early 1970s on ARPANET. While it was a self-replicating program, it predates personal computers and the concept of a "virus" in the context of infecting host files or boot sectors of PCs. For PC viruses, Brain is the generally accepted first.

The correct answer is C: WAN. The Internet is a prime example of a Wide Area Network (WAN). A WAN is a telecommunications network that extends over a large geographical area, often connecting multiple smaller local area networks (LANs) across cities, countries, or even continents. The Internet achieves this global connectivity by linking countless individual networks and devices worldwide, allowing users to exchange data and information across vast distances. Its scale and reach inherently classify it as a WAN.

• A: LAN stands for Local Area Network. A LAN typically connects computers and devices within a limited geographical area, such as a home, office building, or campus. While the Internet is composed of many interconnected LANs, a single LAN does not define the Internet itself, which is far larger in scope.

• B: MAN stands for Metropolitan Area Network. A MAN covers a larger area than a LAN, usually a city or a large campus. It's larger than a LAN but smaller than a WAN. The Internet's reach extends far beyond a single metropolitan area, making MAN an insufficient classification.

• D: PAN stands for Personal Area Network. A PAN is the smallest type of network, used for connecting personal devices within a very short range, often a few meters, such as Bluetooth connections between a phone and headphones. This is clearly too small to describe the global Internet.

The correct answer is C: 700 MB. A standard CD-ROM (Compact Disc Read-Only Memory) typically has a storage capacity of around 700 megabytes (MB). This capacity was widely adopted for distributing software, music albums, and other forms of digital data before the advent of larger storage media like DVDs and Blu-ray discs.

• A: 4.7 GB refers to the standard storage capacity of a single-layer, single-sided DVD (Digital Versatile Disc). DVDs offer significantly more storage than CDs, making them suitable for video content and larger applications. Therefore, 4.7 GB is incorrect for a CD-ROM.

• B: 1.44 MB is the typical storage capacity of a 3.5-inch floppy disk. Floppy disks were an early form of portable storage, used for small files and booting operating systems, but their capacity is minuscule compared to a CD-ROM.

• D: 8.5 GB is the storage capacity of a dual-layer, single-sided DVD. This capacity allowed for even more data or longer video content than standard single-layer DVDs. It is also incorrect for a CD-ROM, which has much less storage.

The correct answer is D: .pptx. The file extension .pptx is the standard extension for presentations created with Microsoft PowerPoint, particularly from PowerPoint 2007 onwards. The 'x' denotes that it is an Open XML format, which replaced the older binary .ppt format, offering improved file recovery and smaller file sizes.

• A: .docx is the standard file extension for documents created with Microsoft Word, also from Word 2007 onwards. It is used for text documents, not presentations.

• B: .pdf stands for Portable Document Format. It is a universal file format developed by Adobe to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems. While PowerPoint presentations can be exported as PDFs, .pdf is not the native PowerPoint file extension.

• C: .xlsx is the standard file extension for spreadsheets created with Microsoft Excel, from Excel 2007 onwards. It is used for numerical data, charts, and calculations, not for presentations.

The correct answer is C: F4. In Microsoft Excel, the F4 function key serves as the primary shortcut to repeat the last action performed. This is incredibly useful for repetitive tasks, such as applying the same formatting, inserting a row, or copying a formula multiple times. For example, if you bold text in one cell, selecting another cell and pressing F4 will bold the text in that new cell.

• A: F2 is used to edit the active cell. When you press F2, the cursor appears at the end of the text in the active cell, allowing you to modify its contents without double-clicking.

• B: F3 is often used to display the 'Paste Name' dialog box in Excel, which allows you to insert a defined name into a formula. It does not repeat the last action.

• D: F5 is used to open the 'Go To' dialog box, allowing you to quickly navigate to a specific cell, range, or named item in your workbook. It is not used to repeat the last action.

The correct answer is B: Ctrl+Z. This shortcut is universally recognized across most applications, including word processors, graphic design software, and web browsers, as the command to undo the last action. It allows users to reverse a mistake, such as deleting text, moving an object, or applying incorrect formatting, thereby restoring the previous state of the document or application.

• A: Ctrl+A is the shortcut to select all content within the active window or document. For instance, in a word processor, it would select all text; in a folder, it would select all files.

• C: Ctrl+C is the shortcut to copy the currently selected item(s). This places a duplicate of the selected content onto the clipboard, from where it can be pasted elsewhere.

• D: Ctrl+V is the shortcut to paste the content that is currently stored on the clipboard. This content would typically have been copied or cut using Ctrl+C or Ctrl+X, respectively.

The correct answer is B: Print Layout View. In Microsoft Word, the Print Layout View is designed to show you how your document will appear when it is printed. This includes displaying headers, footers, page breaks, margins, and graphics in their correct positions. It provides a 'what you see is what you get' (WYSIWYG) representation, making it the ideal view for final adjustments before printing or converting to PDF.

• A: Draft View (also known as Normal View in older versions) focuses on the text content, making it easier to type and edit without distractions from page layout elements. Headers and footers are not visible in this view; instead, you see a simplified representation of your document.

• C: Web Layout View displays your document as it would appear in a web browser. It removes page breaks and shows the content as a continuous scroll, optimizing it for online reading. Headers and footers are typically not visible in this view as they are page-specific elements.

• D: Outline View is used for organizing and structuring your document's content, especially long documents with multiple headings. It displays headings and subheadings, allowing you to easily rearrange sections. This view does not show headers and footers, as its primary purpose is structural organization rather than visual layout.

The correct answer is C: Insert Menu. In Microsoft Word, the 'Header & Footer' tools are located within the 'Insert' tab on the Ribbon. This is because headers and footers are elements that you 'insert' into your document to appear consistently on multiple pages. By clicking on the 'Header' or 'Footer' option, you can choose from predefined styles or create a custom header/footer, and then add text, page numbers, dates, or other information.

• A: View Menu (or tab) allows you to change how you see your document, such as switching between Print Layout, Web Layout, or Draft views, or zooming in and out. While it affects how you *perceive* elements like headers and footers, it's not where you *insert* them.

• B: Home Menu (or tab) contains the most frequently used commands for formatting text, such as font styles, paragraph alignment, and clipboard operations (cut, copy, paste). It is not concerned with inserting structural page elements like headers and footers.

• D: Design Menu (or tab) is used for applying overall document formatting, themes, colors, fonts, and page backgrounds. While you might use it to style the appearance of your header/footer once inserted, the initial insertion point is not in the Design tab.

The correct answer is B: Shift+F5. In Microsoft PowerPoint, the shortcut Shift+F5 is used to start a presentation from the current slide. This is particularly useful when you are practicing or presenting a specific section of your presentation and don't want to start from the very beginning. You can navigate to any slide and then instantly begin the slideshow from that point.

• A: F5 is the shortcut to start the presentation from the beginning of the slideshow (the first slide). While it initiates the presentation, it doesn't offer the flexibility to start from any chosen slide.

• C: Ctrl+F5 is not a standard shortcut for starting a presentation in PowerPoint. In some applications, Ctrl+F5 might be used to force a refresh or reload of a web page, but it has no direct function for slideshow control in PowerPoint.

• D: Alt+F5 is also not a standard shortcut for starting a presentation from the current slide in PowerPoint. In some contexts, Alt+F5 can be related to restoring a window size, but it's not for presentation mode.

The correct answer is C: Graphical User Interface. GUI stands for Graphical User Interface. It is a type of user interface that allows users to interact with electronic devices through graphical icons and visual indicators, such as secondary notation, instead of text-based commands or typed command labels. GUIs make computers and software much more user-friendly and intuitive, as users can click on icons, open windows, and drag and drop items with a mouse.

• A: General User interface is incorrect. While a GUI is a type of user interface, the word 'General' does not accurately represent the 'G' in GUI.

• B: Graphical Unified interface is incorrect. The term 'Unified' is not part of the standard abbreviation for GUI. The key aspect of GUI is its graphical nature, not necessarily a unified approach across all interfaces, although many do share common elements.

• D: General Unified interface is incorrect. Neither 'General' nor 'Unified' correctly defines the 'G' or 'U' in GUI within the context of computer science and human-computer interaction.

The correct answer is C: American standard code for information interchange. ASCII stands for American Standard Code for Information Interchange. It is a character encoding standard for electronic communication. ASCII codes represent text in computers, telecommunications equipment, and other devices. It assigns numeric values to letters, numbers, punctuation marks, and other symbols, allowing different computer systems to exchange text-based information consistently.

• A: American Standard code for information coding is incorrect. The last word should be 'Interchange', not 'coding'. The core purpose of ASCII is the interchange of information between systems using a standardized code.

• B: Advanced Standard code for information Interchange is incorrect. The first word is 'American', not 'Advanced'. ASCII was developed in the United States, hence the 'American' designation in its name.

• D: American system code for information interchange is incorrect. The third word is 'Standard', not 'system'. It's a widely adopted standard for character representation, not merely a system.

The correct answer is Circular Wait. Deadlock occurs in a computer system when a set of processes are blocked indefinitely, each waiting for a resource held by another process in the set. The four necessary conditions for deadlock are: Mutual Exclusion, Hold and Wait, No Preemption, and Circular Wait. While all four must be present, Circular Wait is often considered the most direct and summarizing condition that describes the cyclic dependency leading to deadlock. It means there is a chain of processes, P0, P1, ..., Pn, such that P0 is waiting for a resource held by P1, P1 is waiting for a resource held by P2, and so on, with Pn waiting for a resource held by P0.

• Option A, Mutual Exclusion, is incorrect as a sole cause. Mutual Exclusion means that at least one resource must be held in a non-sharable mode. While necessary for deadlock, it alone doesn't cause it.

• Option B, No Preemption, is incorrect as a sole cause. No Preemption means a resource cannot be forcibly taken from a process holding it. This is another necessary condition but not sufficient on its own.

• Option C, Hold and Wait, is incorrect as a sole cause. Hold and Wait means a process holding at least one resource is waiting to acquire additional resources held by other processes. It's a key condition, but deadlock requires the circular dependency implied by circular wait.

In presentation software such as Microsoft PowerPoint, Ctrl+M is the correct and widely used keyboard shortcut for inserting a new, blank slide into your existing presentation. This action efficiently adds a new slide, maintaining the current presentation's design and theme, allowing users to continue building their content without interrupting their workflow. It's a productivity-boosting shortcut for anyone working with slide decks.

• Ctrl+N: This shortcut is generally used to create a new, entirely blank document or presentation file. It initiates a new project window, rather than adding a slide to an open one.
• Ctrl+S: This is the universal shortcut for saving the current document or file. It commits changes to storage but does not introduce new content like a slide.
• Ctrl+I: This shortcut is commonly used to apply italic formatting to selected text. It is a text manipulation command and has no function related to inserting new slides.

The correct answer is Google. Android OS was initially developed by Android Inc., a company founded in October 2003. However, Android Inc. was acquired by Google in 2005. Following this acquisition, Google took over the primary development and continued to evolve the Android platform into the world's most widely used mobile operating system. Google releases new versions of Android annually and manages the Android Open Source Project (AOSP), which forms the basis for various Android distributions.

• Option A, Microsoft, is incorrect. Microsoft developed its own mobile operating systems, such as Windows Mobile and Windows Phone, which competed with Android but did not develop Android itself.

• Option B, Apple, is incorrect. Apple developed and exclusively uses its own proprietary mobile operating system, iOS, for its iPhone devices. Apple has no involvement in the development of Android.

• Option D, Samsung, is incorrect. While Samsung is the largest manufacturer of Android smartphones and heavily customizes the Android OS for its devices (e.g., with its One UI), it did not primarily develop the core Android operating system. Samsung is a key partner and contributor but not the original developer.