Computer Knowledge PYQs

The correct answer is Option 3: Select the cell<.

Key Points

• In MS Excel 365, deleting a column involves selecting any cell within the column that you want to delete.
• Right-clicking on the selected cell opens a context menu with various options.
• Choosing "Delete" from the context menu will open a dialog box with options to delete an entire row or an entire column.
• Selecting "Entire Column" will delete the entire column where the selected cell is located.

Additional Information

• MS Excel 365:
• MS Excel 365 is a powerful spreadsheet software developed by Microsoft, part of the Microsoft Office suite.
• It provides tools for data analysis, visualization, and calculation, making it essential for various professional and academic tasks.
• Deleting Columns:
• Deleting columns in Excel is a common task when you need to remove unnecessary data or reorganize your spreadsheet.
• To delete a column, you can also use the "Home" tab on the Ribbon, navigate to the "Cells" group, and select "Delete" to find options for deleting columns.
• Context Menu:
• The context menu in Excel is a shortcut menu that appears when you right-click on a cell, row, or column.
• It provides quick access to commonly used commands, such as cut, copy, paste, delete, and formatting options.
• Entire Column Option:
• When you select "Entire Column" in the delete dialog box, Excel removes the whole column containing the selected cell.
• This action cannot be undone, so it's important to ensure that you want to delete the column before confirming the action.

The correct answer is F12.

Key Points

• F12 is the shortcut key for the "Save As" option in MS Word 365.
• This shortcut quickly opens the "Save As" dialog box, allowing users to save their documents with a different name or in a different location.
• Using shortcut keys like F12 can greatly enhance productivity and efficiency while working with documents.
• Knowing and utilizing shortcut keys is crucial for advanced and efficient use of software applications like MS Word.

Additional Information

• MS Word:
• Microsoft Word is a widely used commercial word processor designed by Microsoft.
• It is part of the Microsoft Office suite and is used for creating, editing, formatting, and printing text documents.
• MS Word offers various features such as spell check, grammar check, text and font formatting, image support, and more.
• It supports a wide range of document formats and is used in various professional, academic, and personal settings.
• Shortcut Keys:
• Shortcut keys are combinations of keys that provide an alternative to using the mouse to perform tasks.
• They help users to execute commands and functions quickly and efficiently without navigating through menus.
• Examples include Ctrl+C for copy, Ctrl+V for paste, and Ctrl+S for save.
• Learning and using shortcut keys can significantly increase productivity and streamline workflow.
• Save As Function:
• The "Save As" function allows users to save a document with a new name or in a different location.
• This is useful for creating multiple versions of a document or saving backups.
• In MS Word, the "Save As" dialog box can be accessed through the File menu or by pressing the F12 shortcut key.
• It provides options to change the file format, file name, and storage location.

The correct answer is Changing the colour of the text.

Key Points

• The 'Font Color' option in Microsoft Word 365 allows users to change the color of the text to make it visually distinct.
• It provides a wide range of color choices including standard colors and custom colors.
• Changing the text color can enhance the readability of the document, especially for highlighting important information.
• This feature is easily accessible from the 'Home' tab in the ribbon under the 'Font' group.

Additional Information

• Font Style: This option allows users to change the appearance of the text, such as making it bold, italic, or underlined.
• Font Size: This option changes the size of the text, making it larger or smaller depending on the user's needs.
• Text Highlight Color: This feature applies a background color to the text, which is useful for highlighting important sections of the document.
• Text Effects: Microsoft Word 365 also provides various text effects such as shadow, reflection, and glow to enhance the appearance of the text further.

The correct answer is Home.

Key Points

• The Home tab in Microsoft Word's ribbon includes options for text formatting such as font type, size, color, and other character formats.
• It also contains editing tools like cut, copy, paste, and the format painter.
• This tab provides paragraph formatting options like alignment, line spacing, and indentation.
• The Styles group within the Home tab helps users apply predefined styles to text for consistent formatting.

Additional Information

• Text Formatting:
• Text formatting refers to the attributes of the text like font, size, and color.
• It helps in making the document visually appealing and emphasizes important information.
• Editing Tools:
• Editing tools include options for cutting, copying, and pasting text or objects within the document.
• The format painter allows users to copy formatting from one part of the document and apply it to another.
• Paragraph Formatting:
• Paragraph formatting includes adjusting the alignment, line spacing, indentation, and spacing before and after paragraphs.
• These tools are essential for structuring the document and improving readability.
• Styles:
• Styles are predefined sets of formatting options that can be applied to text to ensure consistency throughout the document.
• Using styles can save time and ensure that the document follows a uniform format.

The correct answer is Shift + Ctrl + N.

Key Points

• Shift + Ctrl + N is not a valid shortcut to open a spreadsheet in MS Excel 365.
• Alt + F + O is a valid method to open an existing spreadsheet in MS Excel 365.
• Ctrl + N is a shortcut to open a new spreadsheet in MS Excel 365.
• File -> Open is a common method to access and open existing spreadsheets in MS Excel 365.

Additional Information

• MS Excel 365:
• Microsoft Excel 365 is a powerful spreadsheet application that is part of the Microsoft Office 365 suite.
• It offers various features for data analysis, charting, and visualization.
• Excel 365 includes cloud integration, allowing users to access and collaborate on spreadsheets from different devices.
• Excel 365 provides several keyboard shortcuts to enhance productivity and streamline workflow.
• Keyboard Shortcuts:
• Keyboard shortcuts are combinations of keys that perform specific commands in software applications.
• They help users execute tasks quickly without using a mouse.
• Common shortcuts in Excel include Ctrl + C (copy), Ctrl + V (paste), and Ctrl + S (save).
• Knowing and using shortcuts can significantly improve efficiency when working with Excel.
• Opening Spreadsheets:
• In Excel, users can open spreadsheets using menus, toolbars, or keyboard shortcuts.
• Alt + F + O is a sequence used to navigate through the File menu to open an existing file.
• Ctrl + N creates a new blank workbook, allowing users to start from scratch.
• The File -> Open path is a traditional way to locate and open files through the graphical user interface.

The correct answer is Page number.

Key Points

• Page numbers are a common element in the header or footer of a Word document to help readers navigate through the document easily.
• Including a page number in headers or footers is essential for long documents like reports, research papers, and books.
• In MS Word 365, you can easily insert or modify page numbers through the "Insert" menu and the "Header & Footer" group.
• Page numbers can be formatted to appear in different styles, such as Roman numerals, Arabic numbers, or letters, depending on the document's needs.

Additional Information

• Header and Footer:
• Headers and footers are sections at the top and bottom of each page in a document.
• They can include elements like text, images, page numbers, dates, author names, and document titles.
• Using headers and footers helps in maintaining consistency and providing important information throughout the document.
• Document Title:
• A document title is a heading placed at the beginning of a document or section.
• It helps readers understand the main topic or purpose of the document.
• Titles are typically formatted with specific styles to stand out, such as bold or larger font sizes.
• Bullet Points:
• Bullet points are used to present information in a list format.
• They help in organizing content and making it easier to read and understand.
• Bullet points are commonly used in the body of a document rather than in headers or footers.
• Font Colour:
• Font colour refers to the colour of the text in a document.
• Different font colours can be used for emphasis or to differentiate between sections of text.
• Font colour is typically adjusted within the body of the document rather than in headers or footers.

The correct answer is Email address and password.

Key Points

• To sign in to an email client, users are typically required to provide their email address and password.
• The email address serves as a unique identifier for the user’s account.
• The password ensures that only authorized users can access the account, enhancing security.
• Many email clients also offer additional security measures, such as two-factor authentication, for extra protection.

Additional Information

• Email Address:
• An email address is a unique identifier that allows users to send and receive electronic messages.
• It typically consists of a username, the "@" symbol, and a domain name (e.g., user@example.com).
• Email addresses are required to create an account on an email client or service.
• Password:
• A password is a secret word or string of characters used for user authentication to prove identity or gain access to resources.
• Passwords should be kept confidential and complex (a mix of letters, numbers, and special characters) to ensure the security of the account.
• Regularly updating the password and not sharing it with others is recommended for enhanced security.
• Two-Factor Authentication (2FA):
• 2FA is an additional security layer used to ensure that people trying to gain access to an online account are who they say they are.
• First, a user will enter their username and a password. Then, instead of immediately gaining access, they will be required to provide another piece of information.
• This second factor could come from one of the following categories: something you know (password), something you have (smartphone), or something you are (fingerprint).
• Email Client:
• An email client is a software application used to access and manage a user’s email.Email clients can be web-based (like Gmail) or desktop applications (like Microsoft Outlook).
• Email clients provide users with functionalities such as sending, receiving, organizing, and storing email messages.

The correct answer is Option 2.

Key Points

• In MS Excel 365, to delete multiple rows at once, you need to first select the rows by clicking and dragging over the row numbers.
• Once the rows are selected, pressing 'Ctrl' and '-' (minus) will delete the selected rows.
• The 'Ctrl' and '-' shortcut is a quick method for deleting rows, columns, or cells in Excel.
• This method helps in managing data efficiently and saves time during data manipulation tasks.

Additional Information

• Selection of Rows:
• To select multiple rows in Excel, click and drag over the row numbers on the left side of the sheet.
• You can also hold down the 'Shift' key and click on the first and last row numbers to select a range of rows.
• Deleting Rows:
• After selecting the rows, you can delete them by pressing 'Ctrl' and '-' (minus) on your keyboard.
• Alternatively, you can right-click on the selected rows and choose 'Delete' from the context menu.
• Keyboard Shortcuts:
• Keyboard shortcuts in Excel are designed to perform common tasks quickly and efficiently.
• Other useful shortcuts include 'Ctrl' and '+' (plus) to insert rows or columns, and 'Ctrl' and 'Z' to undo actions.
• Data Management:
• Efficient data management is crucial in Excel for organizing, analyzing, and manipulating large datasets.
• Using shortcuts and understanding Excel's functionalities can greatly enhance productivity and accuracy.

The correct answer is Ctrl + Shift + C.

Key Points

• Ctrl + Shift + C is the shortcut key used to copy formatting in MS Word 365.
• This shortcut copies the formatting of the selected text, allowing you to apply it to other text.
• The copied formatting includes font style, size, color, and other text attributes.
• This feature is useful for ensuring consistency in document formatting without manually adjusting each section.

Additional Information

• MS Word 365
• MS Word 365 is a part of the Microsoft Office 365 suite and is a widely used word processing software.
• It provides various features for document creation, editing, formatting, and collaboration.
• Some key features include text formatting, image insertion, table creation, and integration with other Office 365 apps.
• MS Word 365 also offers cloud-based storage and real-time collaboration, making it a powerful tool for both individual and group projects.
• Formatting in MS Word
• Formatting refers to the process of changing the appearance of text and paragraphs in a document.
• This includes adjusting font styles, sizes, colors, alignment, line spacing, and other text attributes.
• Proper formatting enhances the readability and presentation of a document.
• MS Word provides various tools and shortcuts to facilitate efficient formatting.
• Shortcut Keys
• Shortcut keys are combinations of keys that provide quick access to certain functions in software applications.
• They help improve productivity by reducing the need to navigate through menus and options.
• Common shortcut keys in MS Word include Ctrl + C (copy), Ctrl + V (paste), Ctrl + B (bold), Ctrl + I (italic), and Ctrl + U (underline).
• Learning and using shortcut keys can significantly speed up document creation and editing tasks.

The correct answer is E-commerce.

Key Points

• E-commerce refers to the buying and selling of goods or services using the internet, and the transfer of money and data to execute these transactions.
• E-commerce is often used to refer to the sale of physical products online, but it can also describe any kind of commercial transaction that is facilitated through the internet.
• Popular examples of e-commerce platforms include Amazon, eBay, and Alibaba.
• E-commerce platforms provide a range of services such as online storefronts, payment processing, and customer service solutions.

Additional Information

• Instant Messaging
• Instant messaging (IM) technology is a type of online chat that offers real-time text transmission over the internet.
• Popular instant messaging applications include WhatsApp, Facebook Messenger, and Telegram.
• IM allows users to send messages, share files, and make voice and video calls.
• Video Conferencing
• Video conferencing enables real-time video and audio communication between two or more people in different locations.
• Popular platforms include Zoom, Skype, and Microsoft Teams.
• Video conferencing is used for virtual meetings, webinars, and online classes.
• Streaming
• Streaming refers to the continuous transmission of audio or video files from a server to a client.
• Popular streaming services include Netflix, YouTube, and Spotify.
• Streaming allows users to consume content on-demand without downloading the entire file.

The correct answer is Copy.

Key Points

• The Copy function in MS Word allows users to duplicate selected text or objects to the clipboard, enabling them to paste it elsewhere without retyping.
• This feature significantly reduces time and effort, especially when dealing with repetitive text or formatting.
• It is particularly useful when you need to place the same content in multiple locations within a document or across different documents.
• The copied text or object remains in the clipboard until another item is copied, allowing for repeated pasting as needed.

Additional Information

• Replace
• The Replace function in MS Word is used to find specific text and replace it with different text. This is useful f

The correct answer is Justify.

Key Points

• The "Justify" alignment option in Excel aligns text to both the left and right sides of a cell.
• This option is useful for creating a neat, justified appearance of text, making it look more professional.
• Justified text is commonly used in newspapers, magazines, and other professional documents.
• In Excel, you can find the "Justify" option under the "Home" tab in the "Alignment" group.

Additional Information

• Right Align
• Aligns the text to the right side of the cell.
• Commonly used for aligning numbers or dates to improve readability.
• Can be accessed from the "Home" tab in the "Alignment" group.
• Centre Align
• Aligns the text to the center of the cell.
• Useful for headings or titles to make them stand out.
• Available under the "Home" tab in the "Alignment" group.
• Left Align
• Aligns the text to the left side of the cell.
• This is the default alignment for text in Excel.
• Can be found in the "Home" tab within the "Alignment" group.

The correct answer is Subject.

Key Points

• The Subject field in an email message is a brief description of the content of the message.
• It helps the recipient to understand the purpose or main idea of the message before opening it.
• A clear and concise subject line can increase the chances of the email being read and acted upon.
• It is a standard field in email messages, often displayed prominently in the recipient's inbox.

Additional Information

• Date
• This field indicates the date and time when the email was sent.
• It helps the recipient know when the email was composed and dispatched.
• To
• This field contains the email address of the main recipient(s) of the message.
• It is a mandatory field in an email, without which the email cannot be sent.
• Signature
• This is a block of text automatically appended at the end of an email message.
• It often contains the sender's name, contact information, and other relevant details.
• Signatures help in providing consistent contact information and can also be used for branding purposes.

The correct answer is Specify how many copies of the document to print.

Key Points

• The 'Number of Copies' option in the Print Settings dialog in MS Word 365 allows you to specify how many copies of the document you want to print.
• This option is useful when you need multiple copies of the same document without having to print each one individually.
• You can set the number of copies by entering a number in the 'Number of Copies' field or using the up and down arrows to adjust the number.
• Ensuring the correct number of copies is selected can save time and resources, especially for bulk printing tasks.

Additional Information

• Print Settings Dialog:
• The Print Settings dialog in MS Word 365 is where you configure various printing options before sending a document to the printer.
• It includes settings for selecting the printer, specifying the number of copies, choosing the paper size, and other print-related configurations.
• Paper Size:
• This option allows you to select the size of the paper you want to print on, such as A4, Letter, Legal, etc.
• Font Size:
• Font size refers to the size of the text in the document. This is typically adjusted in the main document editing interface rather than the print settings dialog.
• Number of Pages:
• This setting allows you to specify which pages of the document you want to print. For example, you can print all pages, a range of pages, or specific pages.

The correct answer is Ctrl + C.

Key Points

• Ctrl + C is the standard keyboard shortcut for copying selected text or items in most applications, including MS Word 365.
• This shortcut allows users to quickly duplicate text or objects without using the mouse, enhancing efficiency.
• After copying the text or item, it can be pasted elsewhere using the Ctrl + V shortcut.
• Using keyboard shortcuts can significantly speed up tasks and improve productivity in document editing and other applications.

Additional Information

• Ctrl + X (Cut)
• This shortcut removes the selected text or item and places it on the clipboard.
• It is used when you want to move text or items from one location to another.
• Ctrl + Z (Undo)
• This shortcut reverses the last action taken, effectively undoing it.
• It is useful for correcting mistakes made during editing or formatting.
• Ctrl + V (Paste)
• This shortcut inserts the text or item from the clipboard into the current location.
• It is used in conjunction with Ctrl + C (Copy) and Ctrl + X (Cut) to move or duplicate text or items.

The correct answer is Align Text Middle.

Key Points

• Align Text Middle is typically a vertical alignment option and not a text alignment option in MS Word 365.
• In MS Word 365, common text alignment options include Left, Center, Right, and Justify.
• Text alignment refers to the horizontal placement of text within a text box or document.
• Vertical alignment options, such as Align Text Middle, are commonly used in table cells or text boxes.

Additional Information

• Align Text Center
• This alignment option centers the text horizontally across the page or within the text box.
• It's commonly used for titles or headings to give a balanced appearance.
• Align Text Right
• This alignment option aligns the text to the right margin of the page or text box.
• It's often used for dates and other information that needs to be aligned to the right side.
• Align Text Justify
• This option aligns text to both the left and right margins, adding extra space between words as necessary.
• It creates a clean, block-like appearance and is often used in newspapers and magazines.
• Text Alignment
• Text alignment refers to how the text is positioned horizontally within a document.
• The main types of text alignment are Left, Center, Right, and Justify.
• Each type of alignment serves different purposes and is used based on the document's design requirements.
• Vertical Alignment
• Vertical alignment refers to the positioning of text vertically within a text box or table cell.
• Common vertical alignment options include Top, Middle, and Bottom.
• These options are typically used to control the vertical placement of text within a specific area, such as a table cell.

The correct answer is Save the workbook with a new name or location.

Key Points

• The 'Save As' option allows you to save the workbook with a new name, which can help in creating a new version of the file while preserving the original.
• It enables you to save the workbook in a different location, which is useful for organizing files or backing them up in different directories.
• You can use 'Save As' to save the workbook in a different file format, which is essential when you need to share files with users who might not have the same software.
• It is a useful feature when you need to create a template or duplicate a workbook with a different name or in a different location without affecting the original file.

Additional Information

• Save:
• The 'Save' option updates the current workbook and saves all the changes made to the existing file.
• It does not allow you to change the file name, location, or format. It simply overwrites the existing file with the latest changes.
• Save As:
• The 'Save As' option provides the flexibility to save the current workbook under a new name, location, or format.
• This option is particularly useful for creating backup copies, saving different versions of the same file, or sharing files in different formats.
• When you choose 'Save As', you will be prompted to enter a new file name, select a location, and choose a file format before saving.
• Common file formats in MS Excel include .xlsx, .xls, .csv, .pdf, and more.

The correct answer is Page Break.

Key Points

• Page Break
• A page break forces a new page to begin at a specific point in your document.
• It is useful for starting a new section, chapter, or simply ensuring content appears on a fresh page.
• You can insert a page break manually or by using specific formatting options.

Additional Information

• Page Size:
• Refers to the dimensions of a single sheet of paper in your document.
• Common page sizes include Letter, A4, Legal, and more.
• You can adjust the page size to suit your needs, such as for printing on specific paper sizes or for presentations.
• Page Margins:
• The blank space around the edges of your document.
• Margins provide a visual frame and ensure readability.
• You can customize margins to suit your preferences or printing requirements, such as increasing top margins for binding.
• Orientation:
• Determines whether your document is displayed in Portrait (taller than wide) or Landscape (wider than tall) format.
• Orientation is particularly useful for wide tables, images, or presentations that require a horizontal layout.
• You can easily switch between Portrait and Landscape orientation to optimize the presentation of your content.

The correct answer is Internet Service Provider.

Key Points

• Internet Service Provider (ISP) is a company that provides individuals and organizations access to the internet and other related services.
• ISPs may also provide a variety of services including web hosting, email, domain registration, and more.
• ISPs operate at different levels: Tier 1, Tier 2, and Tier 3, depending on their scale and the infrastructure they own.
• Examples of major ISPs include companies like Comcast, AT&T, Verizon, and smaller local providers.

Additional Information

• Internet Service Protocol (ISP):
• This is not a correct term in the context of internet architecture. The proper term is Internet Protocol (IP), which is a set of rules governing the format of data sent over the internet or local network.
• IP is one of the main protocols in the Internet Protocol Suite, and it is used to deliver packets from the source host to the destination host based on their IP addresses.
• International Service Provider:
• This term is not commonly used in the context of internet architecture. An ISP that operates internationally would simply be referred to as an international ISP.
• These ISPs provide internet services across multiple countries and regions, often collaborating with local ISPs to provide comprehensive coverage.
• Intranet Service Provider:
• This term is also not commonly used. Intranet refers to a private network accessible only to an organization's staff.
• An intranet service provider would be a company that assists in setting up and maintaining these private networks within an organization.
• Internet Service Provider (ISP):
• An ISP is a company that provides customers with Internet access. The ISP connects to its customers using a data transmission technology appropriate for delivering Internet Protocol datagrams, such as dial-up, DSL, cable modem, wireless or dedicated high-speed interconnects.
• ISPs may also provide other services such as email, domain registration, web hosting, and data center services.
• Examples include major companies like Comcast, AT&T, and Verizon, as well as smaller local providers.

The correct answer is A3.

Key Points

• In MS Excel, cells are identified by a combination of column letters and row numbers.
• Columns in Excel are labeled with letters, starting from A, B, C, and so on.
• Rows in Excel are labeled with numbers, starting from 1, 2, 3, and so on.
• A cell reference combines a column letter with a row number to uniquely identify a cell, such as A3.

Additional Information

• Cell Reference:
• A cell reference in Excel refers to the cell or a range of cells on a worksheet and can be used in formulas to access the values or data contained within those cells.
• For example, the cell reference A3 refers to the cell at the intersection of column A and row 3.
• Column Letters:
• Columns in Excel are denoted by letters, starting from A to Z, then AA, AB, and so on.
• Each column letter uniquely identifies a vertical group of cells in the worksheet.
• Row Numbers:
• Rows in Excel are denoted by numbers, starting from 1 and increasing sequentially.
• Each row number uniquely identifies a horizontal group of cells in the worksheet.
• Cell Address:
• The cell address is a combination of the column letter and the row number and uniquely identifies a cell on the worksheet.
• For example, in the cell address A3, 'A' is the column letter and '3' is the row number.