Computer Knowledge PYQs

The correct answer is Hypertext Transfer Protocol.

Key Points

• Hypertext Transfer Protocol (HTTP) is the foundation of any data exchange on the Web.
• It is a stateless protocol, meaning each command is executed independently, without any knowledge of the previous commands.
• HTTP is an application layer protocol designed within the framework of the Internet protocol suite.
• It is used for transmitting hypermedia documents, such as HTML, and is an essential protocol for web browsers to communicate with web servers.

Additional Information

• Domain Name Server (DNS)
• DNS is a hierarchical and decentralized naming system for computers, services, or other resources connected to the Internet or a private network.
• It translates more readily memorized domain names to the numerical IP addresses needed for locating and identifying computer services and devices.
• It is an essential component for the functionality of the Internet.
• World Wide Web (WWW)
• The World Wide Web is an information system where documents and other web resources are identified by Uniform Resource Locators (URLs).
• It is accessible over the Internet and uses HTTP to transfer data.
• It was invented by Sir Tim Berners-Lee in 1989.
• Uniform Resource Locator (URL)
• A URL is a reference or address to a resource on the Internet.
• It is used to specify addresses on the World Wide Web.
• A URL has two main components: Protocol identifier (e.g., HTTP) and Resource name (e.g., www.example.com).

The correct answer is Option 3: Neither (1) Nor (2).

Key Points

• In MS Word 365, Ctrl + X is used to cut a document or selected text, not copy it.
• In MS Word 365, Ctrl + V is used to paste the content from the clipboard, not to move a document.
• To copy a document or selected text, the correct keyboard shortcut is Ctrl + C.
• To move a document or selected text, you typically cut it using Ctrl + X and then paste it using Ctrl + V.

Additional Information

• Ctrl + X (Cut):
• This command removes the selected text or item and places it on the clipboard for later use.
• It is commonly used to move text or objects from one location to another within a document or between different documents.
• Ctrl + C (Copy):
• This command copies the selected text or item to the clipboard without removing it from the original location.
• It allows users to duplicate text or objects within a document or across different documents.
• Ctrl + V (Paste):
• This command inserts the content from the clipboard into the current location of the cursor within the document.
• It is used to paste text or objects that have been cut or copied from another location.
• Clipboard:
• The clipboard is a temporary storage area in a computer's memory where cut, copied, or dragged data is stored.
• It holds the data until it is pasted into a new location or the computer is turned off.

The correct answer is F2.

Key Points

• The F2 key is used in MS Excel to enter edit mode for the selected cell, allowing you to make changes to its content.
• When you press F2, the cursor appears at the end of the cell's contents, enabling you to start editing immediately.
• Using F2 is a quick way to modify cell data without having to double-click the cell.
• This shortcut is highly efficient for users who frequently need to edit data in Excel spreadsheets.

Additional Information

• Ctrl + F1
• This shortcut toggles the display of the ribbon in MS Excel.
• Using Ctrl + F1, you can hide or show the ribbon, which contains the tabs and commands.
• F1
• Pressing F1 in MS Excel opens the Help pane.
• This key provides quick access to the Help documentation and support resources.
• Ctrl + F2
• Ctrl + F2 opens the Print Preview window in MS Excel.
• This allows you to see how your spreadsheet will look when printed.

The correct answer is TRIM.

Key Points

• The TRIM function in MS Excel 365 removes all spaces from a text string except for single spaces between words.
• This function is particularly useful for cleaning up data that may have irregular spacing issues due to copying, pasting, or human entry errors.
• The syntax for the TRIM function is TRIM(text), where text is the string from which you want to remove extra spaces.
• Applying the TRIM function can make text data more consistent and easier to process for further analysis.

Additional Information

• AVERAGE Function:
• The AVERAGE function calculates the mean of a group of numbers.
• The syntax is AVERAGE(number1, [number2], ...).
• It's used for finding the central value of a set of numbers.
• SUM Function:
• The SUM function adds all the numbers in a range of cells.
• The syntax is SUM(number1, [number2], ...).
• It's a fundamental function for quickly calculating totals in Excel.
• VLOOKUP Function:
• The VLOOKUP function searches for a value in the first column of a table and returns a value in the same row from a specified column.
• The syntax is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
• It's often used for looking up and retrieving data from a specific column in Excel.

The correct answer is Increase font size.

Key Points

• The "Increase font size" option in MS Word 365 allows users to change the font size of the selected text to the next larger size available in the font size list.
• This feature is very useful for quickly adjusting text size, especially when working with documents that require varying levels of emphasis or readability.
• Using this option ensures that the text formatting remains consistent with the font size increments predefined in MS Word.
• It is a more efficient way to adjust font size compared to manually selecting from the font size dropdown list.

Additional Information

• Italics
• This option is used to italicize the selected text, making it slanted to the right.
• Italics is often used for emphasis, titles of works, or for foreign words within a text.
• Bold
• The "Bold" option makes the selected text thicker and darker, which is often used for emphasis or headings.
• Bold text stands out more prominently compared to regular text.
• Reduce font size
• This option decreases the font size of the selected text to the next smaller size available in the font size list.
• It is useful for adjusting the text size downward quickly.
• Font Size List
• The font size list in MS Word contains predefined font sizes (e.g., 8, 10, 12, 14, etc.) that users can select to adjust the size of their text.
• Font sizes can also be customized by typing a specific number into the font size field.

The correct answer is Print area.

Key Points

• The Print Area in MS Excel is a specific range of cells that you designate to print.
• When you set a Print Area, only the cells within that range are printed, leaving out the rest of the spreadsheet.
• You can set multiple Print Areas in a single worksheet, and each area will print as a separate page.
• To set the Print Area, you can go to the Page Layout tab, click on Print Area, and then select Set Print Area.

Additional Information

• View
• In Excel, the View tab allows you to switch between different views of your workbook, such as Normal, Page Layout, and Page Break Preview.
• It also provides options to zoom in and out of your worksheet, and to show or hide gridlines, headings, and the formula bar.
• Print Preview
• Print Preview is a feature that allows you to see how your worksheet will look when printed.
• It shows the layout of the pages, including margins, headers, and footers, and allows you to make adjustments before printing.
• Print Margin
• Print Margins refer to the blank space around the edges of the printed page.
• You can adjust the margins of your worksheet from the Page Layout tab to ensure that the content fits well within the printed page.

The correct answer is To organize information into lists or sequences..

Key Points

• Bullets and numbering help in structuring content in a clear and organized manner.
• They are primarily used to create lists, whether ordered or unordered.
• Using bullets and numbering can enhance readability and make the document more visually appealing.
• They are helpful in emphasizing important points and ensuring the reader can follow the sequence of information.

Additional Information

• Bullets:
• Bullets are symbols used to mark items in a list.
• Common bullet symbols include dots, dashes, and other shapes.
• They are used for unordered lists where the sequence of items does not matter.
• Numbering:
• Numbering is used to create ordered lists.
• Each item in the list is prefixed with a number or letter to indicate its position.
• Numbering is useful when the sequence of items is important, such as in steps of a procedure.
• MS Word 365:
• MS Word 365 is a word processing application provided by Microsoft as part of the Office 365 suite.
• It offers various tools for document formatting, including bullets and numbering.
• Users can customize bullets and numbering styles to suit their document's needs.

The correct answer is Plain Grid.

Key Points

• Plain Grid is one of the predefined table styles available in Microsoft Word 365.
• It provides a simple, clean, and organized layout for tabular data.
• Table styles in Word help maintain consistency and enhance the visual appeal of documents.
• Users can easily apply and customize these styles to suit their formatting needs.

Additional Information

• Chicago Manual of Style
• It is a style guide for American English published by the University of Chicago Press.
• It is widely used in publishing and academia for formatting and citation.
• It is not related to table styles in Microsoft Word.
• MLA (Modern Language Association)
• MLA style is a system for documenting sources in scholarly writing.
• It is commonly used in the humanities, especially in writing on language and literature.
• Like the Chicago Manual of Style, it is not associated with table styles in Word.
• APA (American Psychological Association)
• APA style is used for writing and formatting research papers in psychology and other social sciences.
• It provides guidelines on paper structure, citations, and references.
• It is also not a table style in Microsoft Word.

The correct answer is Email.

Key Points

• Email stands for electronic mail, which is a method of exchanging digital messages over the Internet.
• Emails are typically sent through SMTP (Simple Mail Transfer Protocol) and received through IMAP (Internet Message Access Protocol) or POP3 (Post Office Protocol).
• Email services often include features such as attachments, enabling users to send files, documents, images, and other types of media.
• Emails are widely used for personal, business, and official communication due to their speed, reliability, and ability to be archived for future reference.

Additional Information

• Chrome
• Google Chrome is a cross-platform web browser developed by Google.
• It is known for its speed, simplicity, and security features.
• Chrome supports a wide range of web standards and technologies, including HTML5, CSS3, and JavaScript.
• It also has a large library of extensions and add-ons available through the Chrome Web Store.
• Bing
• Bing is a web search engine owned and operated by Microsoft.
• It provides various search services, including web, image, video, and map search results.
• Bing also powers search features in other Microsoft services, such as Cortana and Microsoft Edge.
• It competes directly with other search engines like Google and Yahoo.
• Mozilla
• Mozilla is a free software community known for its open-source products, primarily the Firefox web browser.
• Firefox is known for its focus on privacy and user control.
• Mozilla also develops other products, such as the Thunderbird email client and the Firefox OS mobile operating system.
• The organization promotes open standards and supports the advancement of the open web.

The correct answer is MS-Word.

Key Points

• MS-Word is a word processing software developed by Microsoft, which is part of the Microsoft Office suite.
• It allows users to create, edit, format, and save documents.
• Users can start a new blank document by selecting "File" > "New" > "Blank document" or by pressing "Ctrl + N".
• MS-Word provides various templates for different types of documents, such as resumes, reports, and letters, but a blank document is a common starting point.

Additional Information

• MS-Excel
• MS-Excel is a spreadsheet software developed by Microsoft.
• It is used for data analysis and visualization, featuring tools like pivot tables and chart creation.
• Excel allows users to perform complex calculations and create financial models.
• MS Outlook
• MS Outlook is an email client software developed by Microsoft.
• It helps users manage emails, calendar events, tasks, and contacts.
• Outlook is often used in corporate environments for communication and scheduling.
• MS-Powerpoint
• MS-Powerpoint is a presentation software developed by Microsoft.
• It is used to create slideshows composed of a series of individual slides.
• PowerPoint is widely used for educational, business, and professional presentations.

The correct answer is Space chart .

Key Points

• Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications.
• It features calculation, graphing tools, pivot tables, and a macro programming language called VBA (Visual Basic for Applications).
• Excel is widely used for data analysis, financial modeling, and other tasks involving numerical data.
• Users can customize various aspects of Excel, including column widths, to better suit their specific needs and preferences.

Additional Information

• Space Chart: A visual representation of data using symbols or icons to depict information, often used for geographical or spatial data.
• Line Chart: A chart that uses lines to connect data points, showing trends and changes over time or across categories.
• Bar Chart: A chart that uses rectangular bars to represent data, comparing values across different categories.
• Pie Chart: A circular chart divided into slices, each representing a proportion of a whole.

The correct answer is Toggle case.

Key Points

• Toggle Case: Converts the case of each character in the selected text, switching between uppercase and lowercase.
• Reverse Case: Reverses the case of each character in the selected text, converting uppercase to lowercase and vice versa.
• Change Case: Allows you to change the case of the entire selected text to uppercase, lowercase, sentence case, or title case.
• Alter Case: A more advanced case-changing option that offers granular control over case changes, such as capitalizing the first letter of each word or sentence.
• Case Sensitivity: Refers to the distinction between uppercase and lowercase letters when searching or comparing text.

 Additional Information

• Microsoft Word 365
• Part of the Microsoft Office 365 suite, Word is a word processing application that allows users to create, edit, and format text documents.
• It offers various tools such as spell check, grammar check, and a thesaurus to assist in writing and editing documents.
• MS Word 365 is cloud-based, enabling users to access and collaborate on documents from any device with internet connectivity.
• It includes advanced features like real-time collaboration, which allows multiple users to work on a document simultaneously.

The correct answer is Save As.

Key Points

The correct answer is Paper clip icon.

Key Points

• Paper Clip Icon: Used to attach files to a cell, allowing you to link external documents or images to your spreadsheet.
• Pen Icon: Indicates that a cell is in edit mode, allowing you to modify its contents directly.
• Smiley Icon: Represents a formula or function that has been entered into a cell, typically used for calculations or data analysis.
• Trash Can Icon: Used to delete a selected cell, row, or column from the spreadsheet.
• Comment Icon: Indicates that a comment has been added to a specific cell, providing additional notes or explanations.

 Additional Information 

• The "send" part of an email typically specifies the email server.
• The email server is responsible for sending, receiving, and storing emails.
• It is a crucial component of the email infrastructure, handling the routing of messages between different users and domains.
• The email server information includes details such as the outgoing (SMTP) server address.
• 1. User Name:
• This is generally associated with the email account and is used for authentication when logging into the email system. It's often part of the email address (e.g., username@example.com).
• 2. Email Server:
• The email server is a computerized system that manages email. It has two main components:
• Incoming Mail Server (IMAP or POP3): Responsible for receiving emails. IMAP (Internet Message Access Protocol) and POP3 (Post Office Protocol) are two common protocols used for this purpose.
• Outgoing Mail Server (SMTP): Responsible for sending emails. When you send an email, your email client connects to the SMTP server to dispatch the message.
• 3. Email Client:
• An email client is a software application that allows users to send and receive emails. Examples include Microsoft Outlook, Mozilla Thunderbird, and Apple Mail. The email client interacts with the email server to manage emails.
• 4. Organization Name:
• This is typically not specified in the "send" part of an email. The organization name is more associated with the sender's information within the email content or signature. The email server, however, handles the routing and delivery of emails without necessarily specifying the organization name in the sending process.

When you send an email, your email client uses the specified email server to send the message to the recipient's email server. The recipient's email client then retrieves the email from their email server using the incoming mail server. This process is facilitated by standardized protocols like SMTP, IMAP, and POP3.

The correct answer is Finding information on the internet.

Key Points

Search Engine:

• A search engine is a software accessed on the Internet that searches a database of information according to the user's query.
• The engine provides a list of results that best match what the user is trying to find.
• Today, there are many search engines available on the Internet, each with its own abilities and features.
• The first search engine ever developed is considered Archie, which was used to search for FTP files, and the first text-based search engine is considered Veronica.
• Currently, the most popular and well-known search engine is Google. Other popular search engines include AOL, Ask.com, Baidu, Bing, DuckDuckGo, and Yahoo.

The correct answer is A curved arrow pointing to the left

Key Points

• The icon commonly used to undo the last action performed in MS Word 365 is A curved arrow pointing to the left
• Undo Function:
• The Undo command allows users to reverse their last action in Word, such as typing, formatting, or deleting.
• Icon Description:
• The curved arrow pointing to the left represents the "Undo" action in the toolbar or ribbon.
• In addition to the icon, you can use the keyboard shortcut Ctrl + Z (Windows) or Command + Z (Mac) to quickly undo your last action in MS Word 365.

Additional Information

• MS Word​
• The leading creators of MS Word software are Charles Simonyi and Richard Brodie, launched in 1983 under Microsoft corporation.
• Microsoft word is recognised as a word processor software which means that a user can rewrite, erase or modify a document as per the requirement.
• The documents created in MS Word are very high in quality. MS Word creates reports, stories, letters, resumes etc.
• It allows users to edit or modify the new or existing document with colour or any other formats like bold, italic and underline.
• The file extension used in Ms Word is .doc or .docx.

The correct answer is Ctrl+shift++(plus key)

Key Points

• The keyboard shortcut to insert a new row in MS Excel 365 is Ctrl + Shift + + (plus key).
• This shortcut will add a new row above the selected row.
• The same shortcut can be used to insert a new column.
• First, select the column or any cell in the column, and then press Ctrl + Shift + +.

Additional Information

• Some other keyboard shortcuts for Excel: 
• Alt + Enter: Inserts a new line within a cell
• Ctrl + K: Inserts a hyperlink
• Ctrl + Space: or Shift + Space Selects an entire row or column
• Ctrl + -. or Cmd+- Deletes rows or columns
• Alt + H + D + C: Deletes columns
• Alt + H + D + R: Deletes rows

The correct answer is By pressing ‘Ctrl + Home’ 

Key Points

• To move the cursor to the beginning of a Microsoft Word 365 document, you can press Ctrl + Home
• It is even if you are currently several pages down.
• The equivalent shortcut is Command + Home, or Fn + Command + Left Arrow on some keyboards.
• This shortcut is quicker and more precise than scrolling or using the mouse to navigate to the beginning of a lengthy document.

Additional Information

• Some other keyboard shortcuts for navigating a Word document:
• Ctrl + Page Up: Moves the cursor to the top of the previous page
• Ctrl + End: Moves the cursor to the end of the document
• Shift + F5: Moves the cursor to the location of the previous revision
• Page Down: Moves the cursor to the next page
• Ctrl + Page Down: Moves the cursor to the top of the next page
• Ctrl + F: Finds a keyword
• Tab: Moves the cursor to the next table cell
• End: Moves the cursor to the end of the line
• Ctrl + Left arrow key: Moves the cursor one word to the left
• Ctrl + Right arrow key: Moves the cursor one word to the right
• Ctrl + Up arrow key: Moves the cursor up by one paragraph
• Ctrl + Down arrow key: Moves the cursor down by one paragraph

The correct answer is Tables

Key Points

• You can add a table in an MS Word document by navigating to the Insert Tab.
• Within the Insert Tab, you can find the option to create a table, allowing you to specify the number of rows and columns.
• The Insert Tab provides various other functionalities such as inserting pictures, shapes, charts, and other elements into your document.
• Using the Insert Tab for adding tables helps in organizing data effectively in a structured format.

Additional Information

• Links
• The Links group allows you to insert and manage hyperlinks and related tools.
• Hyperlink:
• Insert a link to a web page, document, or email address.
• Shortcut: Ctrl + K (Windows) or Command + K (Mac).
• Bookmark:
• Create a reference point within the document to jump back to later.
• Pages
• The Pages group helps you insert page elements to organize your document.
• Cover Page:
• Insert a professionally designed cover page at the beginning of your document.
• Blank Page:
• Add a new blank page at the cursor's position.
• Page Break:
• Start a new page from the current cursor position. Shortcut: Ctrl + Enter.
• Illustrations
• The Illustrations group allows you to visually enhance your document.
• Pictures:
• Insert images from your computer or online.
• Shapes:
• Add customizable shapes like lines, arrows, or geometric designs.
• Icons:
• Use built-in icons for professional-looking visual elements.
• SmartArt:
• Create diagrams to visually represent data or ideas.
• Chart:
• Insert charts for data visualization, such as bar graphs or pie charts.
• Screenshot:
• Insert a screenshot of an open window or a screen clipping.​

The correct answer is Toolbar icons

Key Points

• The icons below the menu bar in a word processing application, such as Microsoft Word, are typically part of the Toolbar or Ribbon.
• A Toolbar contains a row of icons that represent commonly used commands or actions.
• Examples: Save, Undo, Redo, Cut, Copy, Paste, etc.
• In modern word processors like Microsoft Word, the Ribbon has replaced traditional toolbars.
• It organizes commands into Tabs (e.g., Home, Insert, Layout) and Groups (e.g., Font, Paragraph, Styles).

Additional Information

• The status bar is the area at the bottom of the Word window that indicates information about the current document.
• It displays information about what page you are on, as well as your line number on the page and character number on the line.
• The Standard toolbar is located just below the menu bar.
• It contains buttons representing commands such as New, Open, Save, and Print.
• It contains buttons representing text modifying commands, such as font, text size, bold, numbering, and bullets.
• The “drawing toolbar” allows you to quickly and easily label pictures (e.g., maps) in a MS Word file.
• You can add arrows, circle spots, or label with words.
• You can quickly change the color and line width of these objects as well