Computer Knowledge PYQs

The correct answer is Microsoft Word.

Key Points

• Microsoft Word:
• This is a word processing software developed by Microsoft.
• It allows users to create and edit documents such as letters, reports, resumes, and more.
• Word offers a wide range of features, including text formatting, spell check, grammar check, image insertion, and collaboration tools.

Additional Information

• Microsoft Excel:
• This is a spreadsheet software program also developed by Microsoft.
• It's used for organizing, analyzing, and manipulating data.
• Excel provides features like formulas, functions, charts, and pivot tables, making it a powerful tool for tasks such as budgeting, financial modeling, and data analysis.
• Google Chrome:
• This is a web browser developed by Google.
• It's known for its speed, security, and user-friendly interface.
• Chrome allows users to browse the internet, access websites, and interact with web applications.
• It also integrates with other Google services like Gmail and Google Drive.
• Adobe Photoshop:
• This is a professional-grade image editing software developed by Adobe.
• It's widely used by graphic designers, photographers, and artists for tasks such as photo editing, image retouching, digital painting, and creating digital art.
• Photoshop offers a vast array of tools and features for manipulating images with precision and creativity.

The correct answer is Home → Insert.

Key Points

• In computer terms, "home" has a few different meanings:
• Home Page: This refers to the default webpage that a web browser loads when you first open it or click the "home" button. It's your starting point on the internet, often set to a search engine like Google or a personal website.
• Home Directory: This is a special folder or location on your computer's hard drive or network where your personal files and settings are stored. It's like your own private space within the computer's file system.
• Home Key: This is a physical key on your keyboard, usually located in the bottom left corner. Pressing the "home" key quickly moves the cursor to the beginning of the current line or document, allowing for efficient navigation and editing.
• Home Button: On smartphones and tablets, the "home button" is a physical or virtual button that takes you back to the main screen or home screen of the device. It's the central point for accessing all your apps and features.

The correct answer is 13.

Key Points

• MS Word 365 in Windows 10" refers to the popular word processing software, Microsoft Word, running on the Windows 10 operating system.
• MS Word 365: This is a subscription-based version of Microsoft Word that provides access to the latest features and updates. It's part of the Microsoft 365 suite, which also includes other applications like Excel, PowerPoint, and Outlook.
• Windows 10: This is a widely used operating system developed by Microsoft. It provides the foundation for running applications like Word 365 on your computer.
• This combination allows users to leverage the power of a modern word processing application within a familiar and robust operating system environment. It enables seamless integration with other Microsoft services and offers a user-friendly interface for creating and editing documents efficiently.

The correct answer is Internet and email protocols.

Key Points

• TCP/IP stands for Transmission Control Protocol and Internet Protocol.
• The Internet protocol suite is the conceptual model and set of communications protocols used in the Internet and similar computer networks.
• It is commonly known as TCP/IP because the foundational protocols in the suite are the Transmission Control Protocol (TCP) and the Internet Protocol (IP).

Additional Information

• Hypertext Transfer Protocol (HTTP) is an application-layer protocol for transmitting hypermedia documents, such as HTML.
• SMTP stands for Simple Mail Transfer Protocol.
• The File Transfer Protocol (FTP) is a standard communication protocol used for the transfer of computer files from a server to a client on a computer network.

The correct answer is Ctrl + P.

Key Points

• Ctrl + P:
• This keyboard shortcut is universally recognized as the command to "Print" a document or webpage. It's a quick and efficient way to send the current file to your printer.

 Additional Information

• Alt + I:
• This shortcut typically opens the "Insert" menu or dialog box within an application. The exact function might vary depending on the software you're using.
• Ctrl + I:
• This shortcut usually "Italicizes" the selected text. It's a common formatting tool used to emphasize words or phrases.
• Alt + P:
• This shortcut often relates to "Printing" options or settings within a program. It might open a print preview, access printing preferences, or control specific print functions.

The correct answer is Both Header and Body.

Key Points

• Email, short for "electronic mail," is one of the most widely used features of the Internet, along with the web. It allows you to send and receive messages to and from anyone with an email address, anywhere in the world.

Additional Information

• Email uses multiple protocols within the TCP/IP suite. For example, SMTP is used to send messages, while the POP or IMAP protocols are used to retrieve messages from a mail server. When you configure an email account, you must define your email address, password, and the mail servers used to send and receive messages. Fortunately, most webmail services configure your account automatically, so you only need to enter your email address and password. However, if you use an email client like Microsoft Outlook or Apple Mail, you may need to manually configure each account. Besides the email address and password, you may also have to enter the incoming and outgoing mail servers and enter the correct port numbers for each one.
• The original email standard only supported plain text messages. Eventually, email evolved to support rich text with custom formatting. Today, email supports HTML, which allows emails to be formatted the same way as websites. HTML email messages can include images, links, and CSS layouts. You can also send files or "email attachments" along with messages. Most mail servers allow you to send multiple attachments with each message, but they limit the total size. In the early days of email, attachments were typically limited to one megabyte, but now many mail servers support email attachments that are 20 megabytes in size or more.

The correct answer is toolbars.

Key Points

• Toolbars:
• Toolbars are rows of buttons that provide quick access to frequently used commands in a word processing software.
• Each button represents a specific action, such as bolding text, changing font size, inserting images, or aligning text.
• Toolbars streamline the editing process by eliminating the need to navigate through menus for common tasks.
• Many word processors allow users to customize toolbars by adding or removing buttons based on their preferences.

Additional Information

• Status Bars:
• The status bar is typically located at the bottom of the word processing window.
• It displays essential information about the document, such as:
• Page number and total pages
• Word count and character count
• Zoom level
• Line and column numbers
• Language
• Real-time Updates: The status bar updates in real-time as you type or edit the document, providing immediate feedback.
• Dialog Boxes:
• Dialog boxes are windows that appear on top of the main application window.
• They provide options and settings for various commands and features, such as:
• Paragraph alignment and spacing
• Page layout
• Printing options
• Spell check and grammar check
• User Interaction: Dialog boxes typically include input fields, drop-down menus, checkboxes, and buttons for users to select their preferences.
• Menus:
• Menus are hierarchical lists of commands organized into categories.
• Main menu items typically appear at the top of the screen, with submenus branching out from them.
• Menus provide access to a wide range of features and options that may not be readily available on toolbars.

The correct answer is NetBIOS.

Key Points

• NetBIOS, an acronym for Network Basic Input/Output System, is a suite of protocols that enables applications on different computers within a local area network (LAN) to communicate with each other.
• Developed in the 1980s, NetBIOS primarily serves as an application programming interface (API), providing a set of functions that applications can use to access network services.

Additional Information

• Name Resolution: NetBIOS allows applications to locate other devices on the network using unique names instead of complex network addresses.
• This simplifies communication between devices.
• Session Management: NetBIOS facilitates the establishment, maintenance, and termination of communication sessions between devices. A session provides a reliable channel for data exchange between applications.
• Data Exchange: Once a session is established, NetBIOS enables applications to exchange data with other applications on the network. This data can include files, messages, and other types of information.
• While NetBIOS was originally developed for use on IBM PC networks, it has since been adapted to work with various operating systems and network technologies. It is particularly well-suited for smaller networks where simplicity and ease of use are paramount.
• However, NetBIOS has certain limitations, such as its lack of support for large-scale networks and its reliance on older protocols. As a result, newer technologies like TCP/IP and DNS have largely superseded NetBIOS in modern networking environments.
• Despite its limitations, NetBIOS remains relevant in some legacy systems and niche applications. It continues to provide a basic framework for communication within small, localized networks, especially where compatibility with older systems is a concern.

The correct answer is Ctrl + S.

Key Points

• Ctrl + S
• Purpose: This is the universally recognized shortcut for saving the current file.
• Significance: It's crucial for preventing data loss. By frequently pressing Ctrl + S, you ensure that your work is regularly saved to the storage medium (hard drive, cloud, etc.), minimizing the impact of unexpected system crashes or power outages.

Additional Information

• F6
• The functionality of F6 varies depending on the application.
• Common Uses:
• Web Browsers: Often cycles through open tabs or windows.
• File Explorers: May switch between different panes (e.g., folders and details).
• Word Processors: Might have specific actions assigned to it, such as moving to the next field or section.
• Ctrl + A
• This shortcut selects all content within the current document or application.
• Applications:
• Text Editors/Word Processors: Selects the entire text.
• Spreadsheets: Selects all cells in the current sheet.
• File Explorers: Selects all files and folders in the current view.
• F1
• This is the standard shortcut for accessing the help system of the current application.
• Usage: When pressed, it typically opens a help window, manual, or online documentation related to the software you're using. This is a valuable resource for finding information and troubleshooting issues.

The correct answer is Ctrl + M.

Key Points

• Ctrl + M
• This shortcut typically centers the current line or paragraph.
• In word processing software, it centers the selected text.
• In some applications, it might have other specific functions assigned to it.

Additional Information

• Ctrl + L
• This shortcut usually aligns the current line or paragraph to the left.
• In text editors and word processors, it aligns the selected text to the left margin.
• It might have other functions in different applications.
• Ctrl + Tab
• This shortcut is used to switch between open applications or tabs within the same application.
• In web browsers, it cycles through open tabs.
• In many other applications, it allows you to quickly switch between different windows or documents you have open.
• Ctrl + I
• This shortcut is used to italicize the selected text.
• In word processing software, it applies italics formatting to the selected text.
• It might have other functions in some specialized applications.

The correct answer is RAND.

Key Points

• RAND
• Purpose: Generates a random number between 0 and 1.
• Syntax: =RAND()
• How it works:
• Each time the worksheet is recalculated (e.g., when you open the file, edit a cell, or press F9), a new random number is generated.
• Useful for simulations, random sampling, or introducing randomness into your data.

Additional Information

• AVERAGE
• Purpose: Calculates the average (mean) of a set of numbers.
• Syntax: =AVERAGE(number1, [number2], ...)
• number1 is required, subsequent numbers are optional.
• How it works:
• Sums all the numbers within the specified range.
• Divides the sum by the count of numbers in the range.
• SUM
• Purpose: Adds all the numbers in a range of cells.
• Syntax: =SUM(number1, [number2], ...)
• number1 is required, subsequent numbers are optional.
• How it works:
• Can directly input numbers or refer to cells or ranges containing numbers.
• VLOOKUP
• Purpose: Searches for a specific value in the first column of a table or array and returns a value from the same row in a specified column.
• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
• lookup_value: The value to search for.
• table_array: The range of cells1 containing the lookup table.

The correct answer is The pasted text is merged with the existing text.

Key Points

• When pasting text into Microsoft Word 365, the default behavior is to replace the existing text with the newly pasted text.
• This means that any text already present at the insertion point will be deleted and replaced entirely by the content you are pasting.
• This default behavior ensures that the pasted text is inserted precisely where you intend it to be, without any unintended merging or overlapping of content.
• However, Word 365 also provides several options for customizing paste behavior to suit your specific needs.
• You can easily change the default paste behavior by:
• Using the Paste Options button: After pasting text, a small "Paste Options" button appears. Clicking this button reveals a drop-down menu with various paste options, including:
• Keep Text Only: Pastes the text without any formatting from the source document.
• Keep Source Formatting: Pastes the text with all the original formatting, including fonts, styles, and colors.
• Merge Formatting: Combines the formatting of the pasted text with the formatting of the destination document.
• Match Destination Formatting: Pastes the text using the formatting of the destination document.
• Using the Paste Special dialog box: You can access more advanced paste options by pressing Ctrl+Shift+V or right-clicking the pasted text and selecting Paste Special. This dialog box allows you to paste text as unformatted text, HTML, or even as a picture.

The correct answer is On every page.

Key Points

• In Microsoft Word 365, by default, headers and footers are displayed on every page of the document, including the first page.
• This default behavior ensures consistency throughout the document.
• Display different headers and footers on the first page: This is often useful for documents like reports or essays where the first page may have a different format or require unique information (like a title page). You can achieve this by checking the "Different First Page" option within the Header & Footer Tools.
• Display headers and footers on specific pages or sections: You can control the appearance of headers and footers more precisely by using section breaks. By inserting section breaks, you can create different sections within your document, each with its own header and footer settings.
• Suppress headers and footers altogether on certain pages: If you need to remove headers and footers from specific pages, you can do so by accessing the Header & Footer options for that particular section and making the necessary adjustments.
• These customization options provide flexibility in designing your document layout and ensuring that headers and footers are displayed appropriately on each page.

The correct answer is Ctrl+J.

Key Points

• Ctrl+J
• Function: Justifies the selected text.
• Explanation: This shortcut evenly distributes the spacing between words and letters within a paragraph so that both the left and right margins are aligned.

Additional Information

• Ctrl+B
• Function: Toggles bold formatting.
• Explanation: Pressing Ctrl+B will make the selected text bold. Pressing it again will remove the bold formatting.
• Ctrl+I
• Function: Toggles italic formatting.
• Explanation: This shortcut will make the selected text appear in italics. Pressing it again will remove the italic formatting.
• Ctrl+U
• Function: Toggles underline formatting.
• Explanation: Pressing Ctrl+U will underline the selected text. Pressing it again will remove the underline.

The correct answer is Creating and editing documents.

Key Points

• The primary purpose of a word processing package like Microsoft Word 365 is to create, edit, and format text documents. This encompasses a wide range of tasks that go beyond simple typing:
• Text Creation and Editing:
• Easy Text Entry: Users can efficiently type, insert, delete, and modify text within the document.
• Formatting Options: Control over font styles, sizes, colors, spacing, and alignment enhances readability and visual appeal.
• Spell Check and Grammar Correction: Built-in tools help ensure accuracy and professionalism in writing.
• Document Layout and Design:
• Page Layout Control: Adjust margins, page orientation, and column settings to suit the document's purpose.
• Headers and Footers: Add consistent information like page numbers, dates, and document titles.
• Lists and Tables: Create organized structures for presenting information effectively.
• Image and Object Insertion: Integrate images, shapes, and other elements to enhance visual communication.
• Collaboration and Sharing:
• File Sharing and Collaboration: Work with others on the same document simultaneously through cloud-based platforms.
• Document Version Control: Track changes made by different users and revert to previous versions if needed.

The correct answer is 50.

Key Points

• Gmail is a free email service developed by Google. It was initially launched as a limited beta release on April 1, 2004.
• The creator of Gmail is Paul Buchheit, a Google engineer who conceived and developed the service.
• Key features of Gmail include:
• Large Storage Capacity: Gmail initially offered a significantly larger storage capacity compared to other email services at the time, a key factor in its early popularity.
• Powerful Search Functionality: Gmail's search engine is highly sophisticated, allowing users to quickly find specific emails based on various criteria.
• Spam Filtering: Gmail employs advanced algorithms to effectively filter out spam emails, minimizing the amount of unwanted mail in user inboxes.
• Conversation View: Gmail groups related emails into conversations, making it easier to follow the thread of a discussion.
• Labels and Filters: Users can create labels and filters to organize emails and automatically sort them into different folders.
• Integration with Google Services: Gmail seamlessly integrates with other Google services like Google Drive, Google Calendar, and Google Meet.
• Mobile App: The Gmail mobile app is available for both iOS and Android devices, providing convenient access to your emails on the go.
• Security Features: Gmail incorporates robust security measures to protect user accounts from hacking and phishing attacks.

The correct answer is Both absolute reference and mixed reference.

Key Points

• Dollar ($) sign: In Excel, the dollar sign is used to create absolute references. For example, if you want to refer to cell A1 in a formula and you don't want that reference to change when you copy the formula to another cell, you would use $A$1. However, the dollar sign doesn't signal the start of a formula.

 Additional Information

• Equal (=): This is the correct symbol to start a formula in an Excel cell.
• Any calculation or formula in Excel begins with this equal sign. For example, =A1+10 would add 10 to the value in cell A1.
• Ampersand (&): The ampersand is not used to start a formula in Excel, but rather within formulas to concatenate (link together) different text strings or cell values. For example, the formula =A1&B1 would join together the contents of cells A1 and B1.
• Percent (%): In Excel, a percent sign is neither used to start a formula nor within a formula typically. It's usually used to represent percentage values. While you can include this in a formula (e.g. =A1*20% to get 20% of the value in A1), it's not used to initiate a formula$.

The correct answer is  F1.

Key Points

• F1:
• This key opens the Help menu in Microsoft Word 365.
• It provides access to various resources, including tutorials, troubleshooting guides, and support documentation.

Additional Information

• Ctrl + F1:
• This shortcut key toggles the display of the Ribbon.
• The Ribbon is the horizontal bar at the top of the Word window that contains various tabs and groups of commands.
• This shortcut allows you to quickly hide or show the Ribbon to maximize your workspace.
• Alt + F1:
• This key combination does not have a specific function in Microsoft Word 365.
• Shift + F1:
• This shortcut displays the Reveal Formatting pane.
• This pane shows the detailed formatting applied to the selected text, such as font, font size, spacing, and styles.
• This is helpful for understanding and modifying the formatting of your document.

The correct answer is General Packet Radio Service.

Key Points

General Packet Radio Service

• GPRS, or General Packet Radio Service, is a best-effort packet-switching communications protocol for cellular networks.

GPRS was one of the first widely used data transfer protocols on cellular networks.

• GPRS is a third-generation step toward internet access.

GPRS is also known as GSM-IP that is a Global-System Mobile Communications Internet Protocol as it keeps the users of this system online, allows them to make voice calls, and access the internet on-the-go.

The correct answer is =.

Key Points

• Creating a formula in Excel
• To create a simple formula to add, subtract, multiply or divide values in your worksheet
• Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), an asterisk(*), or forward-slash (/).
• MS-Excel
• It is a spreadsheet program for data analysis and documentation.
• It contains a number of rows and columns, where the intersection of a column and cell and a row is a "cell".
• Each cell contains one point of data.
• It is developed by Microsoft.
• It features calculation, graphing tools, pivot tables.

Additional Information

• All Excel formulas begin with an equal to sign (=)
• After the equal symbol, you enter either a calculation or function
• For example, to add up values in cells B1 through B5, you can either:
• Type the entire equation: = B1+B2+B3+B4+B5
• Use the SUM function: = SUM(B1: B5)
• Press the Enter key to complete the formula.