Computer Knowledge PYQs

The correct answer is Ctrl + E.

Key Points

• In MS Word 365, the shortcut for center aligning the selected text is Ctrl + E.
• Center alignment is useful for titles, headings, and other content that you want to appear in the middle of the page.
• Shortcut keys are designed to save time and improve efficiency by allowing quick access to various functions.
• Consistent use of keyboard shortcuts can significantly enhance productivity in document editing and formatting.
• Other common text alignment shortcuts in MS Word include Ctrl + L for left align and Ctrl + R for right align.

Additional Information

• MS Word Shortcuts
• Ctrl + B is used for bolding the selected text.
• Ctrl + I is used for italicizing the selected text.
• Ctrl + U is used for underlining the selected text.
• Document Navigation
• Ctrl + Home moves the cursor to the beginning of the document.
• Ctrl + End moves the cursor to the end of the document.
• Selection Shortcuts
• Ctrl + A selects all content in the document.
• Shift + Arrow Keys extends the selection of text.

The correct answer is displaying the title of a workbook.

Key Points

• The title bar in Microsoft Excel displays the name of the workbook that is currently open.
• It helps users easily identify which workbook they are working on, especially when multiple workbooks are open simultaneously.
• The title bar is located at the top of the Excel window and also includes the application name (Microsoft Excel).
• Besides the workbook title, the title bar may also show the status of the workbook, such as "Read-Only" or "Compatibility Mode."
• Users can quickly access the "File" menu and other window controls (minimize, maximize, close) from the title bar.

Additional Information

• Ribbon
• The ribbon in Excel is a set of toolbars at the top of the window that is organized into tabs.Each tab contains groups of related commands for various tasks such as formatting, data analysis, and chart creation.
• Formula Bar
• The formula bar is located below the ribbon and is used to enter and edit formulas and data in cells.
• It displays the content of the currently active cell.
• Status Bar
• The status bar is located at the bottom of the Excel window and provides information about the current mode and other details such as the sum, average, and count of selected cells.
• Users can customize the status bar to display various indicators and statistics.

The correct answer is Only (a).

Key Points

• The keyboard shortcut Ctrl + H is used to open the Find and Replace dialog box in MS Word 365.
• Using Ctrl + H allows users to quickly find and replace text within their document.
• Option (b), Ctrl + R, is not used for opening the Find and Replace dialog box in MS Word 365.
• The Ctrl + R shortcut is typically used for right-aligning text.
• Knowing keyboard shortcuts can significantly improve efficiency and productivity when working in software applications like MS Word 365.

Additional Information

• Find and Replace Function
• This feature allows users to search for specific text and replace it with new text within a document.
• It can be accessed via the Home tab in the Ribbon or by using the Ctrl + H shortcut.
• Keyboard Shortcuts
• Keyboard shortcuts are key combinations that perform specific commands, enhancing user efficiency.
• Common shortcuts in MS Word include Ctrl + C for copy, Ctrl + V for paste, and Ctrl + Z for undo.
• Customization
• Users can customize keyboard shortcuts in MS Word to better suit their workflow.
• Custom shortcuts can be set up through the Options menu under the File tab.

The correct answer is Peer-to-Peer architecture.

Key Points

• Peer-to-Peer (P2P) architecture connects individual devices directly without a central authority.
• In a P2P network, each device (peer) has equal responsibilities and powers.
• This type of architecture is commonly used in file-sharing networks.
• Peers in a P2P network can act both as clients and servers, sharing resources directly with each other.
• Peer-to-Peer networks are decentralized, which makes them more robust against failures or attacks on a single point of the network.

Additional Information

• Distributed Architecture
• This architecture involves multiple interconnected systems that share resources and work together to perform tasks.
• It can include both client-server and peer-to-peer models.
• Client-Server Architecture
• This model involves clients requesting resources or services from a centralized server.
• The server provides and manages resources, while clients consume these resources.
• Centralized Architecture
• All resources and processing power are managed by a central server or authority.
• Clients depend on the central server for services and resources.

The correct answer is POWER.

Key Points

• The POWER function in MS Excel 365 is used to raise a number to a specific power or exponent.
• The syntax for the POWER function is POWER(number, power), where "number" is the base number and "power" is the exponent.
• This function returns the result of the base number raised to the power of the exponent.
• It is particularly useful in mathematical calculations, financial analysis, and engineering problems where exponential growth or decay is involved.
• Using the POWER function can simplify complex formulas and make your Excel sheets more readable and easier to manage.

Additional Information

• AVERAGE Function
• The AVERAGE function calculates the mean of a group of numbers.
• It is useful for determining the central tendency of a data set.
• RAND Function
• The RAND function generates a random number between 0 and 1.
• It is often used in simulations and for generating random data.
• MEDIAN Function
• The MEDIAN function finds the middle value in a data set.
• It is helpful in identifying the center of a data distribution, especially in skewed distributions.

The correct answer is Save As.

Key Points

• The "Save As" command in MS Word allows you to save the current document with a new name or in a different location.
• This is useful when you want to create a copy of the document with changes, without altering the original document.
• Using "Save As" ensures that the original document remains intact and unchanged.
• You can also use "Save As" to save the document in a different file format, such as PDF or an older version of Word.
• This command is often used when you are working on a template and want to save multiple versions of the document.

Additional Information

• Save
• This command saves the current document with its existing name and location, overwriting the previous version.
• It is used for quick saves while working on a document to ensure changes are not lost.
• Open
• This command is used to open an existing document from a specified location on your computer or network.
• It does not affect the current document you are working on.
• Close
• This command closes the current document. If there are unsaved changes, it prompts you to save them before closing.
• It does not exit the MS Word application; it only closes the document.

The correct answer is Pressing 'F7'.

Key Points

• Pressing 'F7' in Microsoft Word 365 initiates the spell check and grammar check functions.
• This shortcut helps users quickly identify and correct spelling and grammatical errors in their documents.
• The spell check function highlights any words that are not found in the built-in dictionary.
• Grammar check provides suggestions for improving sentence structure, punctuation, and other grammatical aspects.
• Using 'F7' is a convenient and efficient way to ensure documents are free from spelling and grammatical errors before finalizing them.

Additional Information

• Other Useful Keyboard Shortcuts in Microsoft Word 365
• Pressing 'Ctrl + C' copies the selected text or object.
• Pressing 'Ctrl + V' pastes the copied text or object.
• Pressing 'Ctrl + Z' undoes the last action.
• Pressing 'Ctrl + Y' redoes the last undone action.
• Customizing Keyboard Shortcuts
• Users can customize keyboard shortcuts in Microsoft Word 365 by navigating to File > Options > Customize Ribbon > Customize.
• This allows for a more personalized and efficient workflow tailored to individual preferences.
• AutoCorrect Feature
• Microsoft Word 365 includes an AutoCorrect feature that automatically corrects common typos and misspellings as you type.
• Users can customize the AutoCorrect options to add or remove specific entries according to their needs.

The correct answer is Column.

Key Points

• In Microsoft Excel, columns are defined using letters of the alphabet (e.g., A, B, C, etc.).
• Each column in Excel can hold data, such as text, numbers, or formulas.
• The intersection of a column and a row is called a cell, which is identified by a unique cell reference (e.g., A1, B2).
• Columns help in organizing data vertically, allowing for easier data entry and analysis.
• Excel can accommodate a large number of columns, facilitating the management of extensive datasets.

Additional Information

• Row
• Rows in Excel are defined using numbers (e.g., 1, 2, 3, etc.).
• They organize data horizontally across the spreadsheet.
• Sheet
• An Excel workbook can contain multiple sheets, also known as worksheets.
• Each sheet can be used to organize different sets of data within the same file.
• Table
• Tables in Excel are used to manage and analyze related data more efficiently.
• They come with features like sorting, filtering, and structured references.

The correct answer is Draft Mail.

Key Points

• A draft mail is a message you are writing but have not yet sent or trashed.
• Drafts allow you to save your progress on an email and return to finish it later.
• Most email clients automatically save drafts to prevent data loss in case of unexpected interruptions.
• Draft emails can be edited, and once completed, they can be sent to the recipient.
• Draft mail folders are typically found in all major email services like Gmail, Outlook, and Yahoo Mail.

Additional Information

• Sent Mail
• Sent mail refers to the emails that have been successfully sent to the recipients.
• These emails are stored in the 'Sent' folder for future reference.
• Starred Mail
• Starred mails are emails that have been marked with a star to indicate their importance or for easy access later.
• This feature helps users quickly find important messages in their inbox.
• Received Mail
• Received mails are the emails that have been delivered to your inbox from other senders.
• They can be read, replied to, forwarded, or deleted as needed.

The correct answer is Removes the selected text.

Key Points

• Pressing the 'Delete' key in Microsoft Word 365 removes the selected text.
• If no text is selected, it deletes the character to the right of the cursor.
• This action helps in quick editing by removing unwanted text efficiently.
• The 'Delete' key is different from the 'Backspace' key, which removes text to the left of the cursor.
• Using the 'Delete' key can also remove selected objects like images and shapes in the document.

Additional Information

• Undo Function
• The 'Undo' function in Microsoft Word 365 reverses the last action taken by the user.
• This is usually accomplished by pressing 'Ctrl + Z' on the keyboard.
• Cut Function
• The 'Cut' function removes the selected text or object and places it in the clipboard.
• This can be done by pressing 'Ctrl + X' on the keyboard.
• Copy Function
• The 'Copy' function duplicates the selected text or object and places it in the clipboard without removing it from the document.
• This is usually done by pressing 'Ctrl + C' on the keyboard.

The correct answer is Ncc.

Key Points

• An email message typically consists of several components, including:
• To: The primary recipient(s) of the email.
• Cc: Stands for "Carbon Copy," and is used to send a copy of the email to additional recipients.
• Subject: A brief summary of the email's content.
• Body: The main content of the email.
• However, Ncc is not a standard component of an email message.
• In contrast, Bcc (Blind Carbon Copy) is another common component that is used to send a copy of the email to recipients without disclosing their email addresses to others.

Additional Information

• The To, Cc, and Bcc fields are used to specify the recipients of the email in different ways.
• The Subject line helps recipients understand the purpose of the email at a glance.
• The email's body can contain text, images, links, and other multimedia content.
• Understanding these components is essential for effective email communication.

The correct answer is Print Layout.

Key Points

• Print Layout mode in Microsoft Word 365 allows users to see how text and graphics will appear on the printed page.
• It provides an accurate representation of the document as it will look when printed, including margins, headers, footers, and page breaks.
• Users can easily adjust the layout and formatting of the document to ensure it meets their printing requirements.
• Print Layout mode is especially useful for finalizing documents before printing, ensuring that all elements are correctly positioned and displayed.
• This mode also supports the viewing of elements like watermarks, background colors, and other print-specific features.

Additional Information

• In addition to Print Layout, Microsoft Word 365 offers other layout modes such as Normal, Web Layout, and Read Mode, each serving different purposes.
• Normal Layout is used for general editing and may not display all document elements.
• Web Layout shows how the document would appear as a webpage, which is different from the printed version.
• Read Mode optimizes the document for easy reading on screen, often hiding some editing tools and features.
• Using the correct layout mode can significantly improve the efficiency and accuracy of document preparation.

The correct answer is Track Changes.

Key Points

• Track Changes is a feature in MS-Word 365 that allows users to monitor and review modifications made to a document.
• When Track Changes is enabled, any additions, deletions, or formatting changes are recorded and highlighted for easy identification.
• This feature is especially useful for collaborative work, as it allows multiple users to edit a document while keeping track of each person's contributions.
• Users can accept or reject changes, providing control over the final content of the document.
• It also helps in maintaining the integrity of the original document while allowing for comprehensive editing and review processes.
• The changes are typically shown with different colors and formatting, making it clear what modifications have been made.

Additional Information

• Track Changes can be enabled from the 'Review' tab in MS-Word 365.
• It is possible to customize how changes are displayed by adjusting the settings for markup and comments.
• This feature also allows for the addition of comments, facilitating discussion and feedback directly within the document.
• Track Changes is widely used in professional and academic settings to ensure transparency and accountability in document editing.

The correct answer is $A$1.

Key Points

• An absolute cell reference in MS Excel is a cell reference that remains constant, even if the formula is copied or moved to another cell.
• It is denoted by a dollar sign ($) before the column letter and row number.
• In the case of $A$1:
• The $ before A makes the column reference absolute.
• The $ before 1 makes the row reference absolute.
• This means that no matter where the formula containing $A$1 is moved or copied, it will always refer to cell A1.

Additional Information

• In contrast, a relative cell reference, such as A1, changes when the formula is copied or moved to another cell.
• A mixed cell reference, like $A1 or A$1, has either the column or row fixed.
• Absolute cell references are useful in scenarios where a fixed value or cell is needed across multiple cells in a formula.
• Understanding the use of different types of cell references can greatly enhance your efficiency in Excel$.

The correct answer is Ctrl + C and Ctrl + V.

Key Points

• Ctrl + C is the keyboard shortcut used to copy selected text or items to the clipboard.
• Ctrl + V is the keyboard shortcut used to paste the copied text or items from the clipboard to the desired location.
• These shortcuts are universally accepted in most text editing software, including MS Word 365.
• Using these shortcuts can significantly increase productivity and efficiency while working with text.

Additional Information

• Ctrl + C and Ctrl + V are part of the standard keyboard shortcuts supported by various operating systems, including Windows, macOS, and Linux.
• These shortcuts help in quick data manipulation and movement across different applications.
• Other common shortcuts include Ctrl + X for cut, Ctrl + Z for undo, and Ctrl + Y for redo.
• Mastering these shortcuts can lead to a more seamless and user-friendly computing experience.

The correct answer is 2) You will go to Cell D5.

Key Points

• When you are in Cell D4 and press the Enter key in Microsoft Excel, the cell selection will move one cell downward.
• This behavior is the default setting in Excel, which facilitates data entry in columns.
• Hence, pressing Enter from Cell D4 will move the selection to Cell D5.

Additional Information

• You can change the direction of the cell movement after pressing Enter by modifying the settings in Excel options.
• In Excel, go to File > Options > Advanced, and under the "Editing options" section, you can change the direction to move up, down, left, or right.
• Using the Tab key instead of Enter moves the selection to the next cell on the right.
• Shift + Enter moves the selection to the cell above, and Shift + Tab moves it to the cell on the left.

The correct answer is Option 4.

Key Points

• In MS-Excel 365, the correct syntax of the DATE() function is:
• =DATE(year, month, day)
• This function combines individual year, month, and day values into a valid date recognized by Excel.
• Example: =DATE(2025, 10, 15) will return 15-Oct-2025.
• If the month or day values exceed their normal range, Excel automatically adjusts them. For example, =DATE(2025, 14, 10) → 10-Feb-2026.
• This function is widely used in Excel for creating date values when year, month, and day are stored separately in different cells.

Additional Information

• The DATE() function helps prevent errors when working with text-based dates or regional format differences.
• Common related functions include:
• TEXT() – Converts a date to text in a specified format.
• DATEVALUE() – Converts a text string that looks like a date into a serial number that Excel recognizes as a date.
• TODAY() and NOW() – Return the current date or current date and time.
• Excel automatically adjusts for leap years and allows calculations such as adding or subtracting days, months, or years.
• Correct syntax ensures consistent date calculations across different versions and regional settings of Excel.

The correct answer is Ctrl + O.

Key Points

• Ctrl + O is the shortcut key used to open an existing document in MS-Word 365.
• When you press Ctrl + O, the Open dialog box appears, allowing you to navigate to the location of the document you want to open.
• This shortcut is a standard across many Microsoft Office applications, providing a quick and efficient way to access files.
• Using keyboard shortcuts like Ctrl + O can significantly improve productivity by reducing the need to navigate through menus.

Additional Information

• Ctrl + W is used to close the current document in MS-Word.
• Ctrl + B is used to bold the selected text.
• Ctrl + V is used to paste the copied content.
• Keyboard shortcuts are designed to facilitate quick access to frequently used commands and can be customized in the settings.

The correct answer is Start->All Programs->Microsoft Word.

Key Points

• To open a word processing package such as Microsoft Word, you typically start from the Start menu in Windows.
• The path is usually: Start->All Programs->Microsoft Word.
• Microsoft Word is a widely used word processing software developed by Microsoft.
• This method ensures that you are launching the correct application directly from its installed location.

Additional Information

• Microsoft Word is part of the Microsoft Office suite, which includes other productivity tools like Excel and PowerPoint.
• Modern versions of Microsoft Word can also be opened via desktop shortcuts or taskbar icons if they have been pinned there for easier access.
• Microsoft Word offers a wide range of features for document creation, editing, and formatting.
• Additionally, Microsoft Word can be accessed through Office Online, which allows users to work on documents from a web browser.

The correct answer is DHCP (Dynamic Host Configuration Protocol).

Key Points

• DHCP (Dynamic Host Configuration Protocol) is a network management protocol used on IP networks.
• DHCP automates the process of assigning IP addresses, subnet masks, gateways, and other IP parameters to devices on a network.
• When a device joins a network, it sends a broadcast query requesting necessary information from a DHCP server.
• The DHCP server dynamically assigns an IP address to the device and provides other necessary network configuration details.
• This ensures that each device has a unique IP address and can communicate with other devices on the network.
• DHCP simplifies network administration by reducing the need for manual IP address configuration and management.

Additional Information

• DHCP can also provide other configuration information such as DNS servers, NTP servers, and more.
• DHCP is essential in larger networks where manually assigning IP addresses would be impractical and error-prone.
• In the absence of a DHCP server, devices would need to be manually configured with static IP addresses.
• DHCP is widely supported by various operating systems and network devices, making it a standard protocol in networking.