Computer Knowledge PYQs

The correct answer is We can set condition to look for bold and apply italics on them..

Key Points

• Conditional Formatting in Excel allows users to format cells based on specific conditions or criteria.
• Users can apply various formats such as font color, cell color, and border styles.
• It is possible to add multiple conditions to format cells differently based on different criteria.
• However, Conditional Formatting does not support formatting actions based on the existing format of text (like changing bold text to italics).

Additional Information

• Conditional Formatting:
• Conditional Formatting is a feature in Excel that allows users to apply specific formatting to cells that meet certain criteria.
• It helps in visually analyzing data by highlighting important values or trends.
• Users can create rules based on cell values, formulas, or predefined formats.
• Formatting Options:
• Excel provides various formatting options such as font styles, colors, cell borders, and patterns.
• These formats can be applied manually or through Conditional Formatting based on specific conditions.
• Deleting a Condition:
• Users can delete any Conditional Formatting rule if it is no longer required.
• This can be done through the Conditional Formatting Rules Manager.
• Multiple Conditions:
• Excel allows applying multiple Conditional Formatting rules to a single cell or range of cells.
• This helps in creating complex formatting scenarios based on multiple criteria.

The correct answer is Spam folder.

Key Points

• Spam folder is designed to store unsolicited and unwanted junk emails.
• Emails in the spam folder are typically sent out in bulk to indiscriminate recipient lists.
• Spam folders help in keeping the main inbox clean by filtering out unwanted messages.
• Emails in the spam folder are often flagged by email service providers based on certain criteria such as content, sender reputation, and bulk sending patterns.

Additional Information

• Outbox:
• Outbox is a folder where emails are temporarily stored before they are sent out.
• Emails remain in the outbox when they are waiting to be sent or if they couldn't be sent due to some error.
• Once the email is successfully sent, it moves from the outbox to the sent folder.
• Inbox:
• The inbox is the main folder where incoming emails are received and stored.
• It is the default folder where new emails are delivered unless they are filtered to other folders like spam or specific category folders.
• Draft:
• The draft folder is where emails that are being composed are saved temporarily.
• It allows users to save their work and come back to it later before sending the email.

The correct answer is Ctrl + Shift + L.

Key Points

• The keyboard shortcut Ctrl + Shift + L is used to apply bullets to a list in MS Word 365.
• Using this shortcut, you can quickly format paragraphs into a bulleted list, which helps in organizing information clearly.
• This shortcut is beneficial for creating lists, outlining documents, and improving the readability of text.
• It provides a convenient way to add visual structure and emphasis to important points in your document.

Additional Information

• Keyboard Shortcuts in MS Word
• Keyboard shortcuts are combinations of keys that provide quick access to certain functions in MS Word and other software.
• They are designed to enhance productivity by reducing the time required to perform repetitive tasks.
• Common shortcuts include Ctrl + C for copy, Ctrl + V for paste, and Ctrl + B for bold text.
• Learning and using these shortcuts can significantly speed up your workflow and improve efficiency.
• Bullets and Numbering in MS Word
• Bullets and numbering are formatting options used to create lists within a document.
• Bulleted lists are typically used for items that do not follow a particular order, while numbered lists are used for items that need to be in a specific sequence.
• These features help in organizing content, making it easier to read and follow.
• You can customize bullets and numbering styles to suit the formatting requirements of your document.
• Customizing Shortcuts in MS Word
• MS Word allows users to customize keyboard shortcuts according to their preferences.
• This feature can be accessed through the "Customize Ribbon" option in the "File" menu.
• Customizing shortcuts can further enhance productivity by aligning the software's functionality with the user's workflow.
• Users can assign new shortcuts or modify existing ones to better suit their needs.
• Other Formatting Shortcuts
• Ctrl + M: Increase indent
• Ctrl + Shift + M: Decrease indent
• Ctrl + 1: Single line spacing
• Ctrl + 2: Double line spacing
• Ctrl + 5: 1.5 line spacing
• These shortcuts help in quickly adjusting the format and layout of your text, contributing to a more polished and professional document.

The correct answer is Add a header with text or page numbers to the top of each page.

Key Points

• The 'Header' section in the 'Page Setup' dialog box allows you to insert a header that appears at the top of each page in the document.
• You can add text, images, or page numbers to the header section.
• Headers are useful for displaying consistent information such as document titles, dates, or author names across all pages.
• By using headers, you can make your document look more professional and organized.

Additional Information

• Page Orientation
• This refers to the direction in which a document is displayed or printed.
• Common orientations are Portrait (vertical) and Landscape (horizontal).
• Page Margins
• Margins are the blank spaces that surround the content on a page.
• They define where a line of text begins and ends.
• Line Spacing
• This refers to the amount of space between lines of text within a document.
• Common settings include single, 1.5 lines, and double spacing.
• Header
• A header is a section of the document that appears at the top of each page.
• It often contains information such as the document title, chapter heading, or page numbers.
• Headers are typically used to provide context to the content on the page.

The correct answer is TODAY().

Key Points

• The TODAY() function in MS Excel returns the current date.
• It is a volatile function, meaning it updates itself every time the worksheet is recalculated.
• The TODAY() function does not take any arguments.
• It is useful for creating dynamic date-based calculations, such as calculating age or the number of days between dates.

Additional Information

• DATE()
• The DATE() function is used to create a date from individual year, month, and day components.
• Syntax: DATE(year, month, day)
• It is useful for combining date parts stored in separate cells into a single date.
• MONTH()
• The MONTH() function returns the month portion of a date as a number (1-12).
• Syntax: MONTH(serial_number)
• It is typically used to extract the month from a given date.
• DAY()
• The DAY() function returns the day portion of a date as a number (1-31).
• Syntax: DAY(serial_number)
• It is useful for extracting the day from a given date.
• Additional Functions
• NOW(): Returns the current date and time. Syntax: NOW()
• YEAR(): Returns the year portion of a date. Syntax: YEAR(serial_number)
• DATEDIF(): Calculates the difference between two dates. Syntax: DATEDIF(start_date, end_date, unit)

The correct answer is Both I and II.

Key Points

• The 'Grammar' check in Microsoft Word 365 primarily focuses on both spelling errors and sentence structure and syntax.
• It helps users in identifying and correcting grammatical errors, ensuring that the text is more readable and professionally presented.
• Microsoft Word 365 uses advanced algorithms and AI technology to detect and suggest corrections for both spelling and grammatical errors.
• This feature is crucial for users who want to maintain high-quality written content, whether for professional, academic, or personal purposes.

Additional Information

• Spelling Errors
• Spelling errors are mistakes in the use of individual words.
• Microsoft Word 365 identifies misspelled words and suggests the correct spelling.
• This feature is particularly useful for identifying typos and ensuring that all words are spelled correctly.
• Sentence Structure and Syntax
• Sentence structure refers to the way words are arranged in a sentence to convey a particular meaning.
• Syntax refers to the set of rules that govern the structure of sentences in a language.
• Microsoft Word 365 analyzes the syntax and structure of sentences to ensure they are grammatically correct and clearly convey the intended message.
• Advanced Algorithms and AI Technology
• Microsoft Word 365 employs advanced algorithms and artificial intelligence to perform grammar checks.
• These technologies enable the software to understand the context of the text and provide more accurate suggestions.
• AI technology helps in identifying more complex grammatical errors that might be overlooked by traditional grammar checkers.
• Importance of Grammar Check
• Using the grammar check feature helps in improving the overall quality of written content.
• It ensures that the text is free from grammatical errors, making it more professional and credible.
• Proper grammar and spelling are essential for effective communication, whether in professional documents, academic papers, or personal writing.

The correct answer is #ERROR!.

Key Points

• The #ERROR! symbol in MS Excel indicates that there is an issue with the formula entered in a cell.
• Common causes of #ERROR! include incorrect syntax, missing references, or unsupported operations within the formula.
• It serves as a prompt for users to review and correct the formula to achieve the desired result.
• Understanding and addressing #ERROR! messages is crucial for accurate data analysis and manipulation in MS Excel.

Additional Information

• Functions in MS Excel
• Functions are predefined formulas in MS Excel that perform calculations using specific values, called arguments, in a particular order or structure.
• Examples of commonly used functions include SUM(), AVERAGE(), VLOOKUP(), and IF().
• Functions help automate complex calculations, making data analysis more efficient and accurate.
• To use a function, you typically start by typing the equal sign (=) followed by the function name and its arguments in parentheses.
• Error Messages in MS Excel
• MS Excel provides several error messages to help users identify and correct issues in their formulas.
• Common error messages include #DIV/0! (division by zero), #NAME? (unrecognized text in a formula), #REF! (invalid cell reference), and #VALUE! (wrong type of argument or operand).
• Understanding these error messages can help users troubleshoot and fix errors to ensure accurate data analysis.
• Each error message has specific causes and solutions, which are often detailed in Excel's help resources or online documentation.
• Syntax in MS Excel
• Syntax refers to the set of rules that define the structure and composition of valid formulas and functions in MS Excel.
• Correct syntax is essential for ensuring that Excel can interpret and execute the formula as intended.
• Common syntax rules include using parentheses to enclose function arguments, separating arguments with commas, and ensuring that cell references are correctly formatted.
• Incorrect syntax often results in error messages that prompt users to review and correct their formulas.

The correct answer is Ctrl + S.

Key Points

• Ctrl + S is the standard shortcut key used to save documents across various software applications, including Microsoft Word 365.
• Using the shortcut key Ctrl + S ensures that your work is saved instantly, preventing data loss due to unexpected issues like power failure or software crashes.
• In Microsoft Word 365, the Ctrl + S shortcut can be used to save both new and existing documents quickly and efficiently.
• Saving documents frequently with Ctrl + S helps maintain an up-to-date version of your work, making it easier to track changes and progress.

Additional Information

• Keyboard Shortcuts in MS Word
• Keyboard shortcuts are combinations of keys that provide quick access to certain functions in MS Word and other software.
• They are designed to enhance productivity by reducing the time required to perform repetitive tasks.
• Common shortcuts include Ctrl + C for copy, Ctrl + V for paste, and Ctrl + B for bold text.
• Learning and using these shortcuts can significantly speed up your workflow and improve efficiency.
• Bullets and Numbering in MS Word
• Bullets and numbering are formatting options used to create lists within a document.
• Bulleted lists are typically used for items that do not follow a particular order, while numbered lists are used for items that need to be in a specific sequence.
• These features help in organizing content, making it easier to read and follow.
• You can customize bullets and numbering styles to suit the formatting requirements of your document.
• Customizing Shortcuts in MS Word
• MS Word allows users to customize keyboard shortcuts according to their preferences.
• This feature can be accessed through the "Customize Ribbon" option in the "File" menu.
• Customizing shortcuts can further enhance productivity by aligning the software's functionality with the user's workflow.
• Users can assign new shortcuts or modify existing ones to better suit their needs.
• Other Formatting Shortcuts
• Ctrl + M: Increase indent
• Ctrl + Shift + M: Decrease indent
• Ctrl + 1: Single line spacing
• Ctrl + 2: Double line spacing
• Ctrl + 5: 1.5 line spacing
• These shortcuts help in quickly adjusting the format and layout of your text, contributing to a more polished and professional document.

The correct answer is Simple Mail Transfer Protocol (SMTP).

Key Points

• SMTP stands for Simple Mail Transfer Protocol and is used for sending emails from one server to another.
• SMTP functions primarily to send, receive, and relay outgoing mail between email senders and receivers.
• SMTP is an Application Layer protocol in the Internet Protocol suite and operates over TCP.
• SMTP uses port 25 by default, but other ports like 587 and 465 are also used for sending emails securely.

Additional Information

• Hyper Text Transfer Protocol (HTTP)
• HTTP is the foundation of any data exchange on the Web and is a protocol used for transmitting hypertext requests and information between servers and browsers.
• It operates at the Application Layer in the Internet Protocol suite.
• HTTP uses port 80 by default.
• Transmission Control Protocol (TCP)
• TCP is one of the main protocols of the Internet Protocol suite and ensures reliable, ordered, and error-checked delivery of data between applications running on hosts communicating via an IP network.
• It operates at the Transport Layer in the Internet Protocol suite.
• TCP is used by many other protocols like HTTP, FTP, and SMTP.
• File Transfer Protocol (FTP)
• FTP is a standard network protocol used for the transfer of computer files between a client and server on a computer network.
• It operates at the Application Layer in the Internet Protocol suite.
• FTP uses port 21 by default for command and control, and port 20 for data transfer.

The correct answer is Ctrl + R.

Key Points

• The shortcut key Ctrl + R is used to align the selected text to the right in MS-Word 365.
• Aligning text to the right is a common formatting feature used in documents for headings, dates, and other text elements.
• Using shortcut keys enhances productivity by allowing users to perform actions quickly without navigating through menus.
• Other alignment shortcut keys include Ctrl + L for left alignment, Ctrl + E for center alignment, and Ctrl + J for justified alignment.

Additional Information

• Text Alignment in MS-Word
• Text alignment refers to the positioning of text within a document. It determines how the text is arranged horizontally on the page.
• There are four main types of text alignment: left, center, right, and justified.
• Left Alignment (Ctrl + L): Aligns text to the left margin, leaving the right margin uneven. This is the default alignment in most word processors.
• Center Alignment (Ctrl + E): Centers text evenly between the left and right margins.
• Right Alignment (Ctrl + R): Aligns text to the right margin, leaving the left margin uneven.
• Justified Alignment (Ctrl + J): Aligns text to both the left and right margins, adding extra space between words as necessary. This creates a clean look along both edges of the text block.
• Importance of Keyboard Shortcuts
• Keyboard shortcuts are combinations of keys that provide quick access to certain functions in software applications.
• They are designed to enhance efficiency and productivity by reducing the need to navigate through menus and toolbars.
• Commonly used shortcuts in MS-Word include Ctrl + C for copy, Ctrl + V for paste, and Ctrl + Z for undo.
• Learning and utilizing keyboard shortcuts can significantly speed up the process of document creation and editing.

The correct answer is Header and Footer

Key Points

• In MS Word 2010, the Page Number option is located under the Insert menu, specifically within the Header & Footer group.
• Menu Location:
• The Page Number option is under the Insert tab on the ribbon.
• Within the Insert tab, it is part of the Header & Footer group, as page numbers are often inserted into headers or footers.
• Accessing Page Numbers:
• Go to the Insert tab in the toolbar/ribbon.
• Look for the Header & Footer group, which includes options like Header, Footer, and Page Number.
• Click on the Page Number dropdown to see options for placing page numbers:
• Top of the Page
• Bottom of the Page
• Page Margins
• Current Position
• Customizing Page Numbers:
• After inserting page numbers, you can further customize their format by selecting the Format Page Numbers option from the dropdown.
• You can choose number formats (e.g., 1, 2, 3 or i, ii, iii) or specify a starting number.
• Relation to Header & Footer:
• When you insert a page number, Word automatically places it within the document's header or footer sections, depending on your choice.

Additional Information

• Pages: This group in the Insert tab includes options for adding a Cover Page or a Blank Page.
• Home Tab: 
• The Home tab is the default tab in Microsoft Word.
• The Home Tab displays the most commonly used commands.
• It has five groups of related commands - Clipboard, Font, Paragraph, Styles, and Editing.
• In Word and Excel, these include Copy, Cut, and Paste, Bold, Italic, Underscore, etc.
• Bold is used to highlight the text and capture the readers' attention.
• It could be used to draw extra attention to something important, describe emotions, or indicate actions.
• Page Layout:
• The Page Layout tab holds all the options that allow arranging document pages as required.
• It also allows to set margins, apply themes, control page orientation and size, add sections and line breaks, display line numbers and set paragraph indentation and lines.

The correct answer is Text

Key Points

• The most suitable data type for a person's first name in MS Excel 365 is Text
• A person's first name is made up of alphabetic characters, which are stored and recognized in Excel as text.
• Text data type is used for any data that is not numeric or doesn't fit other specific formats like dates or currency.
• Names, addresses, and other similar entries fall into this category.

Additional Information

• Microsoft 365 is a cloud-powered productivity platform.
• A subscription to Microsoft 365 provides all of the following:
• The latest productivity apps, such as Microsoft Teams, Word, Excel, PowerPoint, Outlook, OneDrive, and so much more.
• The ability to install on PCs, Macs, tablets, and phones.

The correct answer is Line Spacing

Key Points

• Line Spacing specifically controls the vertical distance between lines of text within a paragraph.
• You can access the Line Spacing options in the Home tab under the Paragraph group.
• Alternatively, you can right-click on the paragraph, choose Paragraph, and find the Line Spacing settings in the dialog box.
• There are several types of line spacing, including single, 1.15, 1.5, and double.
• Single spacing is the standard, where a new line of text is placed directly below the previous one.

Additional Information

• Text Indentation: 
• ​Indentation is the space between the margin and the text.
• It's often used to set a first-line indent for paragraphs.
• Indents can be used to create multilevel lists or to visually set paragraphs apart from one another.
• To indent text in Microsoft Word, you can use the Tab key, the Increase/Decrease Indent buttons, or the Paragraph dialog box
• Paragraph Border:
• Borders can be lines or boxes that surround a paragraph on one or more sides.
• They can be useful for emphasizing headings.
• To add a border to a paragraph in Microsoft Word, you can:
• Select the paragraph
• Go to Home > Borders
• Choose the type of border you want
• Paragraph Alignment:
• ​This determines the horizontal alignment of text (e.g., Left, Right, Center, Justify),
• Alignment refers to how text flows in relation to the page, column, table cell, or text box.
• shortcuts to align text:
• Left-align: Press Ctrl+L
• Right-align: Press Ctrl+R
• Center: Press Ctrl+E
• Justify: Press Ctrl+J

The correct answer is Active Sheet

Key Points

• The default print range in Microsoft Excel 365 when printing an entire worksheet is the active sheet
• To print the entire worksheet: Don't select anything, and then select File > Print > Print.
• To print a range of cells: Select the cells you want to print.
• To print the entire workbook: Before clicking Print, under Settings, click the arrow next to Print Active Sheets, and then click Print Entire Workbook.
• Excel prints sheets at their actual size by default, so the size of the worksheet determines how many pages it will take.
• To print an Excel sheet on one page, you can choose a scaling option in the Print Preview window.
• You can also set or clear a print area on a worksheet by clicking Print Area in the Page Setup group on the Page Layout tab.

Additional Information

• Microsoft 365 is a cloud-powered productivity platform. A subscription to Microsoft 365 provides all of the following: The latest productivity apps, such as Microsoft Teams, Word, Excel, PowerPoint, Outlook, OneDrive, and so much more. The ability to install on PCs, Macs, tablets, and phones.

The correct answer is Shift+ spacebar

Key Points

• Shift + Spacebar selects the entire row of the currently active cell.
• This shortcut is useful when you want to make changes to or apply formatting to an entire row
• If you want to select the row above, you would first need to move to a cell in that row (e.g., by pressing the Up Arrow key) and then use Shift + Spacebar to select it.

Additional Information

• Ctrl + Spacebar: This selects the entire column of the currently active cell, not the row.
• Alt + Spacebar: This opens the System Menu of the Excel application window; it doesn’t select any row or column.
• Ctrl + +: This is used to insert a new row, column, or cell, depending on the selection.

The correct answer is the Physical Layer

Key Points

• The Physical Layer is not a part of the Internet Protocol Suite (TCP/IP).
• The TCP/IP model has four layers – Application, Transport, Internet, and Network Access (Link) Layer.
• In contrast, the OSI model has seven layers, which includes the Physical Layer at the bottom.
• The TCP/IP model focuses on end-to-end communication, packet delivery, routing, and addressing in the internet.

Additional Information

• Application Layer: Provides services like HTTP, FTP, SMTP, DNS for user interaction and resource sharing.
• Transport Layer: Ensures reliable delivery through TCP/UDP, flow control, and error handling.
• Internet Layer: Responsible for logical addressing, routing, and packet forwarding (IP, ICMP, ARP).
• Network Access (Link) Layer: Handles data transfer over physical networks using Ethernet, Wi-Fi, etc.

Important Points

• The Physical Layer is a part of the OSI model, not TCP/IP, and deals with hardware specifications like cables, signals, and transmission medium.
• Data Link Layer (in OSI) ≈ Network Access Layer (in TCP/IP): Ensures error detection and framing of packets on local networks.
• Internet Layer (TCP/IP) ≈ Network Layer (OSI): Sends packets across multiple networks to the correct destination.

The correct answer is The text is deleted to the left of the cursor

Key Points

• When you select text in MS Word 365 and press the Backspace key, the selected text is deleted from the document.
• The deletion removes the selected text entirely, regardless of its position relative to the cursor, as the selection takes precedence.
• Each time you press and release the Backspace key, the insertion point moves back one space and the character occupying that space is deleted.
• You can also select text in Word by using the keyboard or mouse.
• For example, you can select all text in a document by pressing Ctrl+A.

Additional Information

• The text is moved to the end of the document: Pressing Backspace does not move text; it deletes it.
• Text can only be moved by cut-and-paste or drag-and-drop actions.
• The text is formatted with a bold style: Bold formatting is applied using Ctrl + B, not the Backspace key.
• The text is copied to the clipboard: Copying requires Ctrl + C, not the Backspace key.
• Backspace does not copy text.

The correct answer is to Increase the font size

Key Points

• The keyboard shortcut Ctrl + Shift + > in MS Word 365 increases the font size of the selected text:
• Ctrl + ]: Increases the font size by one point
• Ctrl + [: Decreases the font size by one point

Additional Information

• Some other keyboard shortcuts for font size in MS Word:
• Align text
• In Microsoft Word, you can align text by selecting the Dialog Box Launcher in the Paragraph group, then selecting the Alignment drop-down menu.
• You can also use the keyboard shortcut Ctrl + J to justify text.
• In PowerPoint, you can choose Left, Center, Right, Justified, or Distributed from the Alignment box.
• Change text size in Windows
• To change the text size in Windows, you can go to Start > Settings > Accessibility > Text size. You can also adjust the Scale drop-down menu to make everything larger, including images and apps
• Ctrl + Shift + <: Decreases the font size
• Ctrl + Shift + F: Opens the Font dialogue box to change the font

The correct answer is Font styling

Key Points

• Font styling refers to text formatting options like bold, italic, or underline to emphasize or visually distinguish specific text in documents.
• These options can be accessed from the Home tab in the Font group in MS Word 365. You can also use keyboard shortcuts:
• Bold: Ctrl + B
• Italic: Ctrl + I
• Underline: Ctrl + U

Additional Information

• Hyperlinking: This is used to add links to web pages or locations in the document, not for text styling.
• Page margins: These define the blank spaces around the edges of the document and are unrelated to text emphasis.

The correct answer is Both(1) and (2)

Key Points

• An attachment in an email can include various types of files, such as:
• Digital photos: Files in formats like JPEG, PNG, GIF, etc.
• Documents: Text files (e.g., DOCX, PDF), spreadsheets, presentations, or other digital content.
• Email systems allow you to attach files of different types, making it versatile for sharing.
• Modern email services support multiple file formats as attachments.

Additional Information

• History of Electronic Mail (EMAIL)
• Electronic mail, or email, is a method of exchanging messages electronically over a computer network.
• It was one of the first applications of the internet and has had a significant impact on communication since its inception.
• The first email was sent in the early 1970s by an engineer named Ray Tomlinson.
• Tomlinson developed a program that allowed users to send messages to one another on the same computer.
• He chose the @ symbol to separate the user's name from the name of the computer they were using, and this is still used in email addresses today.
• In the 1980s, the internet began to expand beyond government and academic research institutions, and email became more widely used.
• The development of graphical user interfaces for computers made it easier for people to use email, and it became a popular way for individuals and businesses to communicate.
• Today, email is an essential part of modern communication, and billions of messages are sent every day.
• It is used for a wide range of purposes, including personal communication, business communication, and marketing.