Computer Knowledge PYQs

The correct answer is Calibri, 11.

Key Points

• The default font style in MS Word 365 for Windows 10 is Calibri.
• The default font size in MS Word 365 for Windows 10 is 11.
• Calibri is a sans-serif typeface that has been the default font in Microsoft Office since 2007.
• The size 11 is chosen because it provides a good balance of readability and space efficiency on standard documents.

Additional Information

• Font Style: A font style refers to the visual appearance of the text. This includes characteristics such as typeface, weight (bold, light), style (italic, oblique), and other attributes.
• Font Size: Font size is the size of the text, typically measured in points (pt). One point is 1/72 of an inch. Therefore, 11pt is approximately 0.153 inches in height.
• Sans-Serif Typeface: Sans-serif typefaces do not have the small projecting features called "serifs" at the end of strokes. Calibri is a sans-serif typeface, which typically offers a cleaner and more modern look.
• Microsoft Office Suite: Microsoft Office 365 includes a suite of productivity applications such as Word, Excel, PowerPoint, and Outlook.

Each application comes with default settings, including font style and size, to standardize documents and presentations.

• Readability and Space Efficiency: The choice of Calibri 11pt as the default font and size in MS Word 365 is aimed at achieving optimal readability and space efficiency. It ensures that documents are easy to read while also making efficient use of page space.

The correct answer is Table Insertion.

Key Points

• Table Insertion is the feature in MS-Word 365 that allows users to insert tables into their documents.
• This feature is typically found under the "Insert" tab on the Ribbon.
• Users can customize the number of rows and columns when inserting a table.
• Table Insertion facilitates the organization of data in a structured format, making it easier to read and analyze.

Additional Information

• Table Creation: This term generally refers to the process of creating tables but is not a specific feature name in MS-Word 365.
• Table Design: This feature in MS-Word 365 allows users to style and format tables after they have been inserted, including changing borders, shading, and applying table styles.
• Table Layout: This feature provides options for modifying the structure of an existing table, such as merging cells, adjusting cell size, and distributing rows and columns evenly.
• Insert Tab: The "Insert" tab on the Ribbon is where users can find the Table Insertion feature along with other options for adding various elements to a document, such as pictures, charts, and hyperlinks.

The correct answer is Comma.

Key Points

• A comma is used to separate multiple email addresses in the recipient, CC (carbon copy), and BCC (blind carbon copy) fields of an email.
• This allows the email client to recognize each address as a distinct recipient and send the email to all listed addresses.
• Using commas helps prevent errors in email delivery by ensuring each email address is parsed correctly.
• Most email clients and services, such as Gmail, Outlook, and Yahoo Mail, use commas to separate multiple email addresses.

Additional Information

• Email Clients:
• Email clients are software applications used to access and manage a user’s email.
• Examples of popular email clients include Microsoft Outlook, Mozilla Thunderbird, and Apple Mail.
• These clients allow users to compose, send, receive, and organize emails.
• CC (Carbon Copy):
• CC is a way to send a copy of an email to additional recipients beyond the primary recipient.
• All recipients in the CC field can see each other's email addresses.
• It is used when the sender wants to keep others informed without requiring a response.
• BCC (Blind Carbon Copy):
• BCC is similar to CC but with a key difference: recipients in the BCC field are hidden from each other.
• It is used to send a copy of an email to multiple recipients without revealing their email addresses to each other.
• This is useful for maintaining privacy and preventing reply-all chains.
• Email Address Format:
• An email address typically follows the format: username@domain.com.
• The username is the unique identifier for the recipient within the email system.
• The domain indicates the email server hosting the recipient's mailbox.

The correct answer is Spelling and Grammar Check.

Key Points

• Spelling and Grammar Check is a feature in MS-Word 365 that helps users identify and correct spelling and grammar errors in their documents.
• It provides suggestions and explanations for each flagged item, allowing users to make informed corrections.
• This feature can be accessed from the Review tab on the Ribbon, making it easy for users to locate and utilize.
• The tool not only improves the accuracy of the document but also helps in enhancing the overall quality and professionalism of the written content.

Additional Information

• Thesaurus:
• The Thesaurus is a tool in MS-Word that helps users find synonyms (words with similar meanings) and antonyms (words with opposite meanings) for selected words.
• It is useful for improving the variety and richness of the language in a document.
• This feature can be accessed by right-clicking on a word and selecting 'Synonyms' or from the Review tab.
• Word Count:
• The Word Count feature provides information about the number of words, characters, paragraphs, and lines in a document.
• It is helpful for keeping track of the length of a document, particularly in academic and professional writing where word limits are common.
• This feature can be accessed from the Review tab or by clicking on the word count displayed in the status bar at the bottom of the MS-Word window.
• AutoCorrect:
• AutoCorrect is a feature that automatically corrects common typing errors and misspelled words as you type.
• It also allows users to create their own custom corrections for specific words or phrases.
• This feature helps in maintaining the accuracy and consistency of the document without manual intervention.

The correct answer is Ctrl + C.

Key Points

• Ctrl + C is the keyboard shortcut used to copy the selected text or cells in Microsoft Excel 365.
• This command places the copied content into the clipboard, allowing it to be pasted elsewhere.
• Using Ctrl + C is a quick and efficient way to duplicate data within the same worksheet or across different worksheets and workbooks.
• This shortcut is universally recognized across most software applications for the copy function, making it a standard practice.

Additional Information

• Clipboard
• The clipboard is a temporary storage area for data that the user wants to copy from one place to another.
• When you use the Ctrl + C command, the selected data is copied to the clipboard.
• The clipboard can store text, images, files, and other types of data.
• Data in the clipboard can be pasted into other locations using the Ctrl + V shortcut.
• Keyboard Shortcuts
• Keyboard shortcuts are combinations of keys that provide an alternative way to do something that you’d typically do with a mouse.
• In Microsoft Excel, keyboard shortcuts are used to perform tasks quickly and efficiently.
• Examples include Ctrl + C for copy, Ctrl + X for cut, and Ctrl + V for paste.
• Microsoft Excel 365
• Microsoft Excel 365 is a spreadsheet software included in the Microsoft Office suite.
• It provides tools for data analysis, calculation, and visualization.
• Excel 365 is part of Microsoft’s Office 365 subscription, offering cloud-based features and regular updates.
• It supports a wide range of functions, formulas, and data manipulation techniques.
• Cut, Copy, and Paste
• Cut (Ctrl + X) removes the selected content from its original location and places it in the clipboard.
• Copy (Ctrl + C) duplicates the selected content and places a copy in the clipboard without removing it from its original location.
• Paste (Ctrl + V) inserts the content from the clipboard into the new location.
• These functions are essential for moving and duplicating data within and between documents.

The correct answer is Infrared.

Key Points

• Infrared technology is a type of unguided transmission media that uses light waves to transmit data.
• It operates in the range of 300 GHz to 400 THz, which is just below visible light on the electromagnetic spectrum.
• Infrared communication is commonly used for short-range communication, such as in remote controls and some wireless devices.
• It does not penetrate walls, making it a secure method of communication within a confined space.

Additional Information

• Coaxial Cable
• This is a type of guided transmission media used for high-frequency signal transmission.
• It consists of a central conductor, an insulating layer, a metallic shield, and an outer insulating layer.
• Coaxial cables are commonly used in cable television and internet connections.
• Twisted Pair Cable
• This is another type of guided transmission media that consists of pairs of twisted copper wires.
• It is used for telephone and Ethernet networks.
• Twisted pair cables help reduce electromagnetic interference.
• Optical Fibre Cable
• This guided transmission media uses light to transmit data over long distances with minimal loss.
• It consists of a core made of glass or plastic, surrounded by a cladding layer, and an outer protective layer.
• Optical fibre cables are widely used in telecommunications and data networking because of their high bandwidth and low attenuation.

The correct answer is Line chart.

Key Points

• A line chart displays information as a series of data points called 'markers' connected by straight line segments.
• It is particularly useful for showing trends over time, such as monthly sales data or stock prices.
• In MS Excel 365, line charts can be created by selecting the data range and choosing the 'Insert Line Chart' option.
• Line charts help in visualizing the data trend, making it easier to identify any patterns or anomalies over a period.

Additional Information

• Bar Chart
• A bar chart represents data with rectangular bars with lengths proportional to the values they represent.
• Bar charts are used for comparing different categories of data.
• Pie Chart
• A pie chart is a circular statistical graphic divided into slices to illustrate numerical proportions.
• Each slice of the pie chart represents a category's contribution to the whole.
• Column Chart
• Similar to bar charts, column charts use vertical bars to display data.
• They are often used for comparing data across different categories over time.
• Trend Analysis
• Trend analysis is a technique used to analyze the current trend of data to predict future movements.
• Line charts are particularly useful for trend analysis as they show data points over a specific period.

The correct answer is Select the row and press Ctrl and the - (minus) key..

Key Points

• Pressing Ctrl and the - (minus) key simultaneously is a quick method to delete a row in MS Excel 365.
• This shortcut works efficiently without the need to navigate through context menus or ribbon options.
• This method is particularly useful for users who prefer keyboard shortcuts for faster operations.
• It can be used to delete multiple rows if multiple rows are selected before using the shortcut.

Additional Information

• Ctrl and - (minus) key:
• This is a keyboard shortcut used to delete selected rows or columns in Excel.
• When pressed, it will prompt a dialog box asking whether to shift cells up or left, or to delete the entire row or column, depending on the selection.
• It's a quick alternative to using the right-click context menu and selecting "Delete".
• It enhances productivity by reducing the need for mouse clicks and navigation.
• Other Methods to Delete Rows in Excel:
• Shift+Delete: This is generally used for permanently deleting files in Windows but does not apply to deleting rows in Excel.
• Delete key: Pressing the Delete key will clear the contents of the selected cells, but it will not delete the row itself.
• Alt+Delete: This combination does not have a default function to delete rows in Excel.
• Excel Shortcuts:
• Excel provides numerous keyboard shortcuts to speed up various tasks.
• Some common shortcuts include Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), and Ctrl+A (select all).
• Mastering these shortcuts can significantly improve efficiency and productivity when working with Excel.

The correct answer is Locate specific words or topics in the Help content.

Key Points

• The 'Search' or 'Find' functionality in MS Word 365 allows users to locate specific words or phrases within the document.
• This tool is essential for quickly navigating through large documents by highlighting the searched terms.
• It can be accessed by using the shortcut Ctrl + F on Windows or Command + F on Mac.
• The 'Find' feature is part of the Editing group on the Home tab in the ribbon interface of MS Word 365.

Additional Information

• Find and Replace
• The 'Replace' function works alongside 'Find' to not only locate but also replace the found text with new text. This can be accessed using Ctrl + H on Windows or Command + H on Mac.
• This is particularly useful for making bulk edits or correcting recurring mistakes throughout the document.
• Navigation Pane
• The Navigation Pane provides a visual outline of the document, allowing users to quickly jump to different sections. This can be opened by selecting 'View' and then checking 'Navigation Pane'.
• In the Navigation Pane, users can also use the search bar to locate text, which highlights the instances directly in the pane.
• Advanced Find Options
• MS Word 365 offers advanced search options such as searching for text with specific formatting or using wildcards for more complex searches.
• These options can be accessed by clicking on 'More' in the Find and Replace dialog box.
• Search in Help Content
• MS Word 365 also provides a search function within its Help content, allowing users to quickly find guidance on various features and troubleshooting tips.
• Users can access this by clicking on the help icon (usually a question mark) and typing their query into the search bar.

The correct answer is Find and Replace.

Key Points

• The "Find and Replace" option in Microsoft Word 365 allows users to search for a specific word or phrase in the document.
• It also allows users to replace the found word or phrase with another specified word or phrase.
• This feature is extremely useful for quickly correcting repetitive mistakes or making multiple changes throughout a document.
• The "Find and Replace" functionality can be accessed by pressing "Ctrl + H" on the keyboard.

Additional Information

• Font Formatting: This option allows users to change the appearance of the text, including font type, size, color, and style (bold, italic, underline).
• Cut and Paste: This feature enables users to remove selected text or objects from one part of a document and insert them into another location within the same or different document.
• Spelling & Grammar: This tool helps users check the spelling and grammatical accuracy of the text within the document, providing suggestions for corrections.
• Find and Replace: A versatile tool that lets users locate specific words or phrases in a document and replace them with new text. This is especially useful for editing large documents.
• Additional Information: The "Find and Replace" feature can be found under the "Home" tab in the "Editing" group. It can also be accessed through the "Navigation Pane" for more advanced search options.

The correct answer is To adjust page layout and formatting before printing.

Key Points

• Print Preview allows you to see exactly how your document will look when it is printed.
• It helps in adjusting the page layout such as margins, orientation, and paper size to ensure the document prints correctly.
• You can also check the formatting of the document, including fonts, spacing, and alignment, to make sure everything appears as expected.
• This feature helps in identifying any last-minute errors that need to be corrected before printing the final document.

Additional Information

• Print Preview is a feature available in most word processors, including MS Word 365, that shows a mock-up of the document on screen as it will appear when printed.
• Page Layout refers to the arrangement of text, images, and other objects on a page. It includes settings like margins, page orientation, and paper size.
• Formatting involves specifying the font, font size, text alignment, line spacing, and other attributes to enhance the document's readability and appearance.
• MS Word 365 is a word processing application by Microsoft that is part of the Microsoft Office 365 suite. It offers various tools and features for document creation, editing, and formatting.

The correct answer is Charts.

Key Points

• Charts in Microsoft Excel are used to visually represent data, making it easier to understand and analyze.
• They help in identifying patterns, trends, and relationships within the data.
• Excel provides various types of charts like bar charts, line charts, pie charts, and more to suit different types of data analysis needs.
• Charts can be customized with different colors, labels, and other formatting options to enhance readability and presentation.

Additional Information

• Macro
• A macro in Excel is a set of instructions that can be used to automate repetitive tasks.
• Macros are written in VBA (Visual Basic for Applications) and can significantly improve productivity.
• They are useful for tasks like data entry, formatting, and complex calculations.
• Macros can be recorded and edited to tailor them to specific needs.
• Formula
• A formula in Excel is an expression that operates on values in a range of cells or a single cell.
• Common formulas include SUM, AVERAGE, and VLOOKUP.
• Formulas are used for calculations, data analysis, and decision-making processes.
• They can be simple or complex, involving multiple functions and references.
• PivotTable
• A PivotTable is a powerful tool in Excel used for data summarization, analysis, and exploration.
• It allows users to quickly summarize large amounts of data and reorganize it for better insights.
• PivotTables can group, filter, and sort data, making it easier to find patterns and trends.
• They are highly customizable and interactive, providing a dynamic way to explore data.

The correct answer is It stands for 'Carbon Copy' and is used to include additional recipients who should be informed about the email..

Key Points

• The "CC" field in an email stands for "Carbon Copy".
• It is used to include additional recipients who need to be informed about the email but are not the primary recipients.
• Recipients in the "CC" field can see who else received the email.
• This field is useful for keeping people in the loop without requiring them to take action.

Additional Information

• BCC (Blind Carbon Copy)
• The "BCC" field stands for "Blind Carbon Copy".
• It is used to include recipients who should receive the email, but their email addresses are hidden from other recipients.
• Recipients in the "BCC" field are invisible to others, providing privacy.
• To Field
• The "To" field is the main field for specifying the primary recipients of the email.
• Recipients in the "To" field are expected to take action or respond to the email.
• Email Etiquette
• Using the "CC" field is important for transparent communication.
• It helps avoid unnecessary replies and keeps everyone informed.
• However, overusing the "CC" field can clutter inboxes and should be avoided unless necessary.

The correct answer is Ctrl + N.

Key Points

• Ctrl + N is the keyboard shortcut used to open a new, blank document in Microsoft Word 365.
• This shortcut command is a quick way to create a new document without using the mouse.
• Using keyboard shortcuts can greatly enhance productivity and efficiency when working with software applications.
• Microsoft Word 365 is part of the Microsoft Office suite, which includes various applications for productivity and collaboration.

Additional Information

• Microsoft Word 365
• Microsoft Word 365 is a word processing application that is part of the Microsoft Office 365 suite.
• It allows users to create, edit, format, and share documents.
• Word 365 includes various tools for text formatting, spell check, grammar check, and collaborative editing.
• The application supports various file formats, including .docx, .pdf, and .txt.
• Keyboard Shortcuts
• Keyboard shortcuts are combinations of keys that provide quick access to certain functions within software applications.
• For example, Ctrl + S is used to save a document, Ctrl + P is used to print a document, and Ctrl + O is used to open an existing document.
• Learning and using keyboard shortcuts can significantly speed up tasks and improve efficiency.
• Different software applications have their own set of keyboard shortcuts, which can usually be found in the help documentation or settings.

The correct answer is To highlight specific cells or rows in the table.

Key Points

• Shading in a table is used to emphasize certain parts of the table, making specific cells or rows stand out.
• It helps in visually distinguishing important data or categorizing different sections within the table.
• Applying shading can improve readability and make it easier for viewers to navigate complex tables.
• Shading options can be customized in terms of colors and patterns to suit different presentation needs.

Additional Information

• Table Shading
• In Microsoft Word, table shading refers to the background color or pattern applied to the cells within a table.
• It is found under the "Table Design" or "Design" tab in the Ribbon when a table is selected.
• Users can choose from a variety of shading colors and patterns to customize the appearance of their tables.
• Shading can be applied to individual cells, rows, columns, or the entire table, depending on the requirement.
• Sorting Data in a Table
• Sorting data involves arranging the data in a specific order, usually ascending or descending.
• This feature is accessed through the "Layout" tab under the "Table Tools" section.
• Adjusting Column Widths
• Column widths in a table can be adjusted manually by dragging the column borders or using the "AutoFit" feature.
• This can be done by selecting the table and navigating to the "Layout" tab under "Table Tools".
• Changing Font Color
• The font color within a table can be changed by selecting the text and using the font color options in the "Home" tab.
• This allows for further customization and emphasis of specific data within the table.

The correct answer is Select the cell << Right click << Insert << Entire Row.

Key Points

• To insert a row above a given row in MS Excel 365, you need to first select the cell in the row where you want the new row to be inserted.
• After selecting the cell, right-click to open the context menu.
• From the context menu, select the "Insert" option.
• In the "Insert" dialog box, choose "Entire Row" to insert a new row above the selected cell.

Additional Information

• MS Excel 365
• MS Excel 365 is a part of the Microsoft Office 365 suite, which provides cloud-based services and applications.
• It is widely used for data analysis, data visualization, and performing complex calculations.
• The user interface includes features like the Ribbon, Quick Access Toolbar, and various tabs such as Home, Insert, Page Layout, Formulas, Data, Review, and View.
• Excel 365 supports collaboration tools, allowing multiple users to work on the same spreadsheet simultaneously.
• Inserting Rows and Columns
• Inserting rows and columns is a fundamental feature in Excel used to modify the structure of a spreadsheet.
• Rows are horizontal lines of cells, while columns are vertical lines of cells in a spreadsheet.
• To insert a row, you can also use the shortcut key combination Ctrl + Shift + "+" after selecting the row.
• Similarly, to insert a column, you select a cell and choose the "Entire Column" option in the Insert dialog box.
• Context Menu
• The context menu is a menu in a graphical user interface (GUI) that appears upon user interaction, such as a right-click mouse operation.
• It provides a list of options or commands that are context-specific, meaning they vary depending on where the user clicks.
• In Excel, the context menu offers functions related to the selected cell or range, like Cut, Copy, Paste, Insert, Delete, Format Cells, and more.

The correct answer is .doc.

Key Points

• The file extension .doc is used to save documents in MS Word 2003.
• MS Word 2003 is a word processing software developed by Microsoft.
• The .doc format was the default file format for Word documents before the introduction of the .docx format in MS Word 2007.
• Documents saved with the .doc extension can be opened by all versions of MS Word and are compatible with many other word processing programs.

Additional Information

• MS Word 2003:
• Microsoft Word 2003 is part of the Microsoft Office 2003 suite and was released in 2003.
• It includes features for creating, editing, formatting, and sharing text documents.
• In addition to basic text editing, it supports advanced formatting options, such as tables, images, and graphics.
• File Extensions:
• A file extension is a suffix at the end of a filename that indicates the file type.
• Examples of common file extensions include .doc for Word documents, .xls for Excel spreadsheets, and .ppt for PowerPoint presentations.
• File extensions help the operating system to determine which program to use to open a file.
• .docx Format:
• The .docx file extension was introduced with Microsoft Word 2007.
• It is based on the Open XML format and offers improved file compression and better data recovery.
• While .docx files are not natively supported by older versions of Word, compatibility packs can be installed to open and save .docx files in Word 2003.

This code provides a detailed explanation of the correct answer, along with key points and additional information about the terminologies associated with the question.

The correct answer is Voice over Internet Protocol.

Key Points

• Voice over Internet Protocol (VoIP) is a technology that allows you to make voice calls using a broadband Internet connection instead of a regular (or analog) phone line.
• VoIP converts your voice into a digital signal that travels over the Internet. If you are calling a regular phone number, the signal is converted to a regular telephone signal before it reaches the destination.
• VoIP services can be used with a VoIP phone, a traditional phone with a VoIP adapter, or a computer with VoIP software.
• VoIP is advantageous because it can offer lower costs, especially for long-distance or international calls, and can integrate with other services available over the Internet, such as video calls, messaging, or data sharing.

Additional Information

• VoIP Protocols
• VoIP uses various protocols to facilitate communication over the internet, including SIP (Session Initiation Protocol), H.323, and RTP (Real-time Transport Protocol).
• SIP is widely used for signaling and controlling multimedia communication sessions.
• RTP is used for delivering audio and video over IP networks.
• Advantages of VoIP
• Cost Savings: VoIP calls, especially international ones, are generally cheaper than traditional phone calls.
• Flexibility: VoIP can be used on various devices, including smartphones, tablets, laptops, and desktop computers.
• Integration: VoIP services can be integrated with other internet services, such as email, web browsing, and instant messaging.
• Disadvantages of VoIP
• Reliability: VoIP services depend on a stable internet connection. Any disruptions in internet service can affect call quality or cause dropped calls.
• Emergency Calls: VoIP services may not provide reliable location information for emergency services, which is a significant concern in case of emergencies.
• Security: VoIP communications are susceptible to hacking, eavesdropping, and other security breaches if not properly secured.

The correct answer is Columns in MS Excel are identified by numbers..

Key Points

• In MS Excel, columns are identified by letters (A, B, C, etc.).
• The cell in the second column and third row is B3.
• The cell in the first column and first row is A1.
• Rows in MS Excel are identified by numbers.

Additional Information

• Cell Addressing in MS Excel:
• Each cell in Excel is identified by a unique cell reference, formed by combining the column letter and the row number.
• For example, the cell in the second column and third row is referred to as B3.
• Columns and Rows:
• Columns in Excel are labeled with letters starting from A, B, C, and so on.
• Once the letters are exhausted, columns are identified as AA, AB, AC, and so on.
• Rows in Excel are labeled with numbers starting from 1, 2, 3, and so on.
• Understanding Cell References:
• A cell reference is a combination of the column letter and the row number, such as A1, B2, C3, etc.
• It is used to identify and access the value or formula contained in a specific cell.
• Importance of Correct Cell Addressing:
• Accurate cell referencing is crucial for performing calculations, creating formulas, and analyzing data effectively.
• Incorrect cell addressing can lead to errors in data analysis and results.

The correct answer is Table.

Key Points

• The "Table" option within the Table group of the Insert tab is used to create and insert a table in an MS Word 365 document.
• Using the "Table" option, users can select the number of rows and columns to insert a table of the desired size.
• This option also allows users to draw a custom table or convert existing text into a table format.
• Inserting tables helps in organizing data in a structured manner, making it easier to read and interpret.

Additional Information

• Insert Tab:
• The Insert tab in MS Word 365 contains various options to add different elements like tables, pictures, shapes, charts, and more to a document.
• This tab helps enhance the document by including visual and structural elements.
• Table Group:
• The Table group within the Insert tab is specifically designed to handle all table-related functionalities.
• It offers options to insert, draw, and format tables in a document.
• Other Options in Insert Tab:
• Pictures: Insert images from your computer or online sources.
• Shapes: Add various shapes like rectangles, circles, arrows, etc.
• Charts: Insert different types of charts like bar, line, pie, etc., to represent data graphically.
• Copy, Cut, Paste:
• These options are used to manipulate text and objects within the document.
• Copy: Duplicates the selected text or object.
• Cut: Removes the selected text or object from its original location.
• Paste: Inserts the copied or cut text or object at the new location.