Computer Knowledge PYQs

The correct answer is Line chart.

Key Points

• A line chart is specifically designed to display data points over time to show trends.
• It is used to connect individual data points through straight lines, making it easier to visualize changes over periods.
• Line charts are ideal for tracking metrics such as sales, stock prices, and other time-series data.
• They can effectively highlight trends and patterns over intervals, aiding in forecasting and decision-making.
• Line charts are valuable in data analysis for their ability to present continuous data clearly.

Additional Information

• Bar Chart:
• Used to compare data across categories.
• Ideal for showing discrete data.
• Bars can be displayed vertically or horizontally.
• Pie Chart:
• Best for showing proportions and percentages.
• Not suitable for showing trends over time.
• Limited in handling large data sets.
• Scatter Plot:
• Used to determine the relationship between two variables.
• Shows how much one variable is affected by another.
• Useful in identifying correlations and distribution trends.
• Area Chart:
• Similar to line charts but with areas below the lines filled in.
• Used to show the magnitude of trends over time.
• Effective for displaying cumulative totals.

The correct answer is Option 1 - Right-click and select "Font".

Key Points

• Right-clicking on selected text in Microsoft Word 365 opens a context menu that provides quick access to various text formatting options, including changing the font.
• The "Font" option in the context menu allows users to change the font without the need to open the Font dialog box, making it a faster method for font customization.
• This method is particularly useful for users who want to quickly apply a different font style to specific portions of their document without navigating through multiple menus.
• Using the right-click context menu for font changes is a common practice in Word processing applications, enhancing user efficiency and document editing speed.

Additional Information

• Keyboard Shortcuts
• Microsoft Word provides a variety of keyboard shortcuts to enhance productivity, such as Ctrl + B for bold, Ctrl + I for italics, and Ctrl + U for underline.
• These shortcuts help users quickly format text without using a mouse, making the editing process more efficient.
• Font Dialog Box
• The Font dialog box in Microsoft Word offers advanced text formatting options, including font style, size, color, and effects like strikethrough and shadow.
• It can be accessed by pressing Ctrl + D or through the Home tab on the Ribbon.
• Ribbon Interface
• The Ribbon interface in Microsoft Word organizes commands into tabs such as Home, Insert, and Review, making it easier for users to find and use different features.
• Font-related options are primarily located in the Home tab, under the Font group.
• Contextual Menus
• Contextual menus in Word provide quick access to commonly used commands based on the current selection or task, improving user experience and workflow.
• Right-clicking text, images, or other elements in a document will display a contextual menu with relevant options.

The correct answer is @.

Key Points

• The at (@) symbol is employed to separate the username and domain name within an email address. Here are 4-5 key points about it:
• Standard Email Format: The "@" symbol is a critical part of the standard email format: username@domain.com. It separates the local part (username) from the domain part of the address.
• Historical Significance: The "@" symbol was chosen by Ray Tomlinson in 1971, as it was rarely used in programming languages and allowed for clarity in distinguishing between the user and the host.
• Domain Identification: The part after the "@" symbol (domain name) identifies the email server hosting the recipient's mailbox (e.g., "gmail.com").
• Internationalization: In some non-English languages, the "@" symbol is referred to by different names, such as "at" in English, "arroba" in Spanish, or "arobase" in French.
• Security: While it’s an essential part of email addresses, the "@" symbol has also become a target for spammers, who use it in phishing attempts or to generate fraudulent email addresses.

The correct answer is Page case.

Key Points

• MS Word 365 provides several options to change the case of selected text.
• Options available include Sentence case, Lowercase, Uppercase, Capitalize Each Word, and Toggle case.
• These options can be accessed from the "Home" tab in the "Font" group.
• "Page case" is not a valid text case option in MS Word 365.

Additional Information

• Sentence case:
• Capitalizes the first letter of the first word in the selected sentence.
• Lowercase:
• Converts all the letters in the selected text to lowercase.
• Uppercase:
• Converts all the letters in the selected text to uppercase.
• Capitalize Each Word:
• Capitalizes the first letter of each word in the selected text.
• Toggle case:
• Switches the case of each letter in the selected text, making uppercase letters lowercase and vice versa.

The correct answer is Broadband provides faster internet speeds compared to dialup..

Key Points

• Broadband connections offer significantly higher data transfer speeds compared to dialup connections, providing a more efficient and faster internet experience.
• Broadband internet is always on, meaning there is no need to dial in each time you want to connect to the internet, unlike dialup.
• Broadband allows for simultaneous use of internet and telephone services, whereas dialup uses the telephone line, making it unavailable for calls during internet usage.
• Broadband connections can support modern internet applications such as streaming, gaming, and large file downloads, which are difficult to manage on slower dialup connections.

Additional Information

• Dialup Connection:
• Dialup connection uses a modem and a standard telephone line to connect to an ISP.
• Typical dialup speeds are up to 56 kbps, which is significantly slower than broadband.
• Dialup connections often experience busy signals and require manual connection setup each time.
• Broadband Types:
• DSL (Digital Subscriber Line): Utilizes existing telephone lines but offers higher speeds without tying up the phone line.
• Cable Internet: Uses the cable television infrastructure to provide high-speed internet access.
• Fiber Optic: Provides the fastest internet speeds by using light to transmit data through fiber optic cables.
• Satellite Internet: Uses satellite communication for internet access, useful in remote areas.
• Latency:
• Latency refers to the delay in data transmission. Broadband connections generally have lower latency compared to dialup.
• Lower latency is crucial for real-time applications such as video conferencing and online gaming.
• Data Cap and Unlimited Plans:
• Broadband plans may come with data caps or unlimited data usage options, offering flexibility based on user needs.
• Dialup connections typically offer unlimited usage but are limited by slow speeds.

The correct answer is To provide assistance in creating documents.

Key Points

• ​The Help feature in Microsoft Word 365 serves several important functions to assist users in navigating the software and resolving issues. Here are 4-5 key points about its purpose:
• Access to Instructions and Guidance: The Help feature provides users with access to detailed instructions on how to use various tools and features within Microsoft Word, making it easier to learn and use the software effectively.
• Searchable Knowledge Base: Users can search for specific topics, keywords, or commands, and the Help feature provides relevant articles, tips, and troubleshooting guides related to their query.
• Contextual Help: It offers context-sensitive help, which means that when you're using a particular feature, the Help feature can suggest assistance specifically related to that task, enhancing efficiency.
• Training and Tutorials: The Help feature includes links to training materials, video tutorials, and other resources, helping both beginners and advanced users to master Word 365.
• Access to Online Support: It provides direct access to Microsoft's online support, where users can contact customer support, report issues, or get help from the community forums.

The correct answer is Access the ‘Home’ tab, use the ‘Font’ group.

Key Points

• To change the font style and size of selected text in Microsoft Excel 365, here are 4-5 key steps:
• Select the Text or Cell: First, highlight the cell or range of cells containing the text you want to modify. You can also click into a specific cell and start typing to change the font of new content.
• Font Style:
• Navigate to the Home tab on the Ribbon.
• In the Font group, click the drop-down menu next to the Font field (it shows the current font style).
• Choose your desired font from the list (e.g., Arial, Times New Roman, Calibri).
• Font Size:
• In the Font group on the Home tab, next to the font style, there’s a Font Size box.
• Click the drop-down arrow to select a new font size, or manually type a value (e.g., 12, 14, 18).
• Keyboard Shortcuts:
• Change Font Style: Use Ctrl + Shift + F to open the Font dialog box, where you can adjust font style and size in more detail.
• Increase or Decrease Font Size: Use Ctrl + Shift + > to increase the font size, or Ctrl + Shift + < to decrease it.
• Additional Options:
• In the Font group, you can also apply bold, italic, underline, or change the font color by using the respective buttons in the toolbar.

The correct answer is Insert Tab -> Table Button.

Key Points

• To create a table in Microsoft Word 2010, here are 4-5 key points explaining the process:
• Navigate to the "Insert" Tab:
• First, click on the Insert tab in the Ribbon at the top of the screen.
• Click "Table":
• In the Tables group, click the Table button. A drop-down menu will appear.
• Choose the Table Size:
• You can use the grid displayed in the drop-down menu to select the number of rows and columns. Hover over the grid to highlight the number of rows and columns you need, then click to insert the table.
• Insert Table Manually:
• Alternatively, you can select Insert Table from the drop-down menu. A dialog box will appear where you can manually set the number of rows and columns.
• Quick Tables:
• There’s also an option for Quick Tables in the Table drop-down menu, where you can choose from predefined table templates for easier insertion.

The correct answer is Paste the data.

Key Points

• When Ctrl + V is used in Microsoft Word 365, the following function is executed:
• Paste the Clipboard Content:
• Ctrl + V is the keyboard shortcut for pasting whatever content is currently on the clipboard into the document. This could be text, images, tables, or any other type of data you have copied or cut earlier.
• Here are 4-5 key points related to this function:
• Inserts Copied or Cut Content:
• It can paste text, images, or objects that were copied using Ctrl + C or cut using Ctrl + X.
• Maintains Formatting (by Default):
• By default, when you paste with Ctrl + V, it retains the original formatting of the content from the source, including font, size, and style. However, you can adjust the paste options by clicking the paste icon that appears after you use Ctrl + V.
• Paste Special Options:
• After using Ctrl + V, you can access more paste options by clicking the small arrow under the Paste button on the Home tab. This includes pasting as plain text, keeping source formatting, or pasting as an image, etc.
• Quick Editing:
• Ctrl + V is often used for quick editing or inserting content into your document without having to manually type it.

The correct answer is COUNTIF.

Key Points

• To count the number of students who scored above 90 in a worksheet, the appropriate Excel 365 function to use is COUNTIF. Here's how you can do it:
• COUNTIF Function:
• The COUNTIF function counts the number of cells that meet a specific condition. In this case, the condition is that the score should be greater than 90.
• Formula Structure:
• The syntax for the COUNTIF function is:

=COUNTIF(range, criteria)

• Steps:
• range: Select the range of cells where the student scores are listed.
• criteria: Use the condition ">90" to count scores greater than 90.
• Example:
• If the student scores are in column B (from B2 to B20), the formula would be:

=COUNTIF(B2:B20, ">90")

• This formula will return the number of students who have scores greater than 90.
• COUNTIF is useful for single-condition counting in Excel.
• You can modify the condition (criteria) for different ranges, such as counting scores less than a certain value or equal to a specific number.

The correct answer is Mozilla Firefox.

Key Points

• Mozilla Firefox is a free and open-source web browser developed by the Mozilla Foundation.
• It was first released on November 9, 2004, and is available for Windows, macOS, Linux, and Android.
• Firefox uses the Gecko layout engine to render web pages, which supports current and anticipated web standards.
• It is known for its speed, security features, and customization options, including a wide range of extensions and themes.
• Firefox also prioritizes user privacy with features like Enhanced Tracking Protection and a built-in password manager.

Additional Information

• Web Browser:
• A web browser is a software application used to access and view websites.
• Popular web browsers include Google Chrome, Mozilla Firefox, Microsoft Edge, Safari, and Opera.
• Browsers interpret and display HTML documents, allowing users to navigate between pages via hyperlinks.
• Modern web browsers support a variety of web technologies such as JavaScript, CSS, and multimedia content.
• Mozilla Foundation:
• The Mozilla Foundation is a non-profit organization that promotes open standards and the development of free software.
• It was established in July 2003 and is the parent organization of the Mozilla Corporation, which manages product development.
• The foundation supports various projects, including the Firefox browser and the Thunderbird email client.
• Gecko Engine:
• Gecko is the layout engine developed by Mozilla to render web pages in Firefox.
• It supports a wide range of web standards, ensuring compatibility with most websites.
• Gecko is known for its performance and support for modern web technologies.
• Enhanced Tracking Protection:
• Enhanced Tracking Protection is a feature in Firefox designed to block known trackers and improve user privacy.
• It prevents websites from tracking user activity across the web, reducing targeted advertising.
• This feature is enabled by default and can be customized based on user preferences.

The correct answer is By pressing 'Ctrl + Space bar'.

Key Points

• Pressing 'Ctrl + Space bar' in Microsoft Excel 365 highlights the entire column where the cursor is currently located.
• This shortcut is useful for quickly selecting and applying changes to an entire column, such as formatting or data entry.
• 'Ctrl + Space bar' selects the entire column from the top to the bottom of the worksheet, regardless of the number of rows.
• Excel offers various other shortcuts for efficient navigation and data manipulation, enhancing user productivity.
• Remember to save your work frequently to prevent data loss while making extensive changes.

Additional Information

• Excel Shortcuts:
• Excel provides a wide range of keyboard shortcuts to enhance productivity, such as 'Ctrl + C' for copy and 'Ctrl + V' for paste.
• Learning and utilizing these shortcuts can significantly speed up your workflow.
• Column and Row Selection:
• In addition to 'Ctrl + Space bar', you can select entire rows using 'Shift + Space bar'.
• Combining these shortcuts with others like 'Ctrl + Shift + Arrow keys' can help navigate and select data efficiently.
• Data Management:
• Excel offers tools for sorting, filtering, and analyzing data, making it a powerful tool for data management.
• Familiarity with Excel's features and shortcuts can improve data handling and analysis capabilities.
• Formatting:
• Excel allows for extensive formatting options, including font styles, cell colors, and conditional formatting.
• Proper formatting can enhance the readability and presentation of your data.

The correct answer is Data -> Sort.

Key Points

• In Microsoft Excel 365, the 'Sort' feature under the 'Data' tab allows users to arrange data in ascending or descending order.
• The 'Sort' option can be applied to a single column or multiple columns to organize data efficiently.
• Sorting helps in analyzing data by arranging it in a meaningful order, making patterns and trends more visible.
• Users can customize the sort criteria, such as sorting alphabetically, numerically, or by date.
• The 'Sort' feature also includes options to handle headers, so they are not sorted with the data.

Additional Information

• Filter:
• The 'Filter' feature allows users to display only the rows that meet certain criteria, hiding the rest.
• Filters can be applied to one or multiple columns, providing a way to focus on specific data subsets.
• Conditional Formatting:
• Conditional formatting automatically changes the appearance of cells based on their values.
• It helps in highlighting important data trends and patterns by applying specific formatting rules.
• PivotTables:
• PivotTables are used to summarize, analyze, and present data in a flexible and interactive manner.
• They allow users to reorganize and group data to gain insights and make data-driven decisions.
• Data Validation:
• Data validation restricts the type of data that can be entered into a cell, ensuring data accuracy and consistency.
• Common data validation rules include restricting input to specific ranges, formats, or lists of values.

The correct answer is Center Alignment.

Key Points

• Pressing Ctrl + E in MS Word 365 centers the selected text or the current paragraph.
• It is a widely used shortcut for quick formatting of titles, headings, and any content that needs to be centered on the page.
• This shortcut is consistent across various versions of MS Word, ensuring uniformity in text alignment tasks.
• Center alignment is often used to improve the visual appeal of documents, especially in professional and formal settings.

Additional Information

• Text Alignment Options in MS Word:
• Left Alignment: Aligns text to the left margin. (Shortcut: Ctrl + L)
• Right Alignment: Aligns text to the right margin. (Shortcut: Ctrl + R)
• Justify: Aligns text to both the left and right margins, adding extra space between words as necessary. (Shortcut: Ctrl + J)
• Importance of Text Alignment: Proper text alignment enhances readability and gives a polished look to documents.
• Other Useful Shortcuts:
• Ctrl + B: Bold the selected text.
• Ctrl + I: Italicize the selected text.
• Ctrl + U: Underline the selected text.
• Customizing Toolbars: Users can customize their toolbars in MS Word to have easy access to frequently used commands, including text alignment options.

The correct answer is Italics.

Key Points

• Italics is a text formatting option in MS-Word that slants the selected text to the right.
• This style is often used for emphasizing specific parts of the text, such as quotes or important terms.
• It is also commonly used to differentiate titles, book names, or other significant items from the main text.
• The Italics option can be activated via the toolbar button represented by an "I" or by using the keyboard shortcut Ctrl+I.
• It helps in making the text stand out for better readability and emphasis.

Additional Information

• Text Formatting in MS-Word:
• Text formatting includes changing the appearance of the text to enhance readability and presentation.
• Common formatting options include Bold, Italics, Underline, Text Color, and Font Size.
• These options can be accessed from the Home tab in MS-Word.
• Formatting helps in structuring the document and highlighting key information.
• Other Formatting Options:
• Bold: Makes the text thicker and darker to emphasize importance (Ctrl+B).
• Underline: Adds a line below the text for emphasis (Ctrl+U).
• Text Color: Changes the color of the text to make it visually distinct.
• Font Size: Alters the size of the text to increase or decrease emphasis.
• Keyboard Shortcuts:
• Keyboard shortcuts are key combinations that perform specific formatting actions quickly.
• Common shortcuts include Ctrl+B for Bold, Ctrl+I for Italics, and Ctrl+U for Underline.
• These shortcuts save time and enhance productivity.
• They are especially useful for frequent text formatting tasks.

The correct answer is Organising emails based on various criteria for easy retrieval.

Key Points

• Sorting and searching emails help in organising emails based on various criteria such as date, sender, subject, or importance.
• This functionality allows users to quickly retrieve relevant emails without manually sifting through their inbox.
• Effective email organisation improves productivity and efficiency by ensuring important messages are easily accessible.
• Many email services offer advanced search features, including filters and labels, to streamline email management.
• Organising emails also helps in maintaining a clutter-free inbox, which can reduce stress and enhance user experience.

Additional Information

• Email Filters
• Email filters are automated rules that help in sorting incoming emails into different folders based on predefined criteria.
• They can be set up to organise emails by sender, keywords, subject line, or other attributes.
• Filters can also help in marking emails as read or assigning them specific labels for easy identification.
• Email Labels
• Labels are a way to categorise and tag emails for better organisation.
• Unlike folders, multiple labels can be applied to a single email, providing more flexibility in email management.
• Labels can be colour-coded to visually distinguish different categories of emails.
• Search Operators
• Search operators are special characters or commands used in the search bar to refine and narrow down search results.
• Common search operators include "from:", "to:", "subject:", and "has:attachment".
• These operators can significantly speed up the process of finding specific emails.
• Archiving
• Archiving emails removes them from the inbox without deleting them, making the inbox less cluttered while preserving important messages.
• Archived emails can be easily accessed and searched whenever needed.
• This feature is particularly useful for storing old but important emails that are not frequently accessed.

The correct answer is Red line.

Key Points

• In MS Word 365, spelling errors are highlighted with a red wavy line.
• This red underline indicates that the word is not found in the Word dictionary.
• Users can right-click on the underlined word to see spelling suggestions.
• The red wavy line serves as a visual cue to help users identify and correct spelling mistakes quickly.

Additional Information

• Grammar Errors:
• Grammar errors are indicated by a blue wavy line in MS Word 365.
• These lines help users identify grammatical mistakes such as incorrect verb tense, subject-verb agreement, etc.
• Contextual Errors:
• MS Word uses a double blue underline to highlight words that are correctly spelled but used in the wrong context.
• For example, using "there" instead of "their".
• Customization:
• Users can customize the proofing options in MS Word to change how spelling and grammar errors are indicated.
• These settings can be accessed via File > Options > Proofing.
• AutoCorrect:
• MS Word's AutoCorrect feature automatically corrects common spelling errors as you type.
• Users can add their own corrections to the AutoCorrect list for frequently mistyped words.

The correct answer is The size of the text characters.

Key Points

• The 'Font Size' in Microsoft Word 365 refers to the size of the text characters, which is measured in points (pt).
• A point is approximately 1/72 of an inch, hence a 12-point font size is 1/6 inch in height.
• Font size can significantly affect the readability and visual appearance of the document.
• Users can adjust the font size to enhance the importance of certain sections of the text or to fit more text on a page.
• Commonly used font sizes for body text in documents are between 10pt and 12pt.

Additional Information

• Font:
• A font is a set of text characters in a specific style and size. Examples include Arial, Times New Roman, and Calibri.
• Fonts can be categorized into various types such as serif, sans-serif, and script.
• Typography:
• Typography is the art and technique of arranging type to make written language legible, readable, and visually appealing.
• It involves font selection, point size, line length, line-spacing, and letter-spacing.
• Text Formatting:
• Text formatting involves adjusting the appearance of text, including font size, style, color, and alignment.
• Microsoft Word 365 provides various formatting options to customize the text appearance in documents.
• Accessibility:
• Adjusting font size can improve document accessibility for users with visual impairments.
• Microsoft Word 365 includes tools to ensure content is accessible to all users, including those with disabilities.

The correct answer is Portrait.

Key Points

• Portrait orientation means that the page is taller than it is wide, similar to a standard book or document.
• It is the default orientation in MS Word and most word processing applications.
• Portrait orientation is typically used for text-heavy documents, such as letters, reports, and essays.
• In MS Word 365, you can set the page orientation to Portrait by navigating to the Layout tab and selecting Orientation, then choosing Portrait.
• Changing the orientation affects the entire document unless you specify different sections for different orientations.

Additional Information

• Landscape Orientation
• This orientation means the page is wider than it is tall, resembling a landscape picture.
• It is often used for documents that require wide tables, charts, or diagrams.
• In MS Word 365, you can set the page orientation to Landscape by navigating to the Layout tab and selecting Orientation, then choosing Landscape.
• Page Setup
• This is a feature in MS Word that allows you to customize the layout of your document, including orientation, margins, and paper size.
• Accessed through the Layout tab, it provides comprehensive control over the document's appearance.
• Default Settings
• The default orientation setting in MS Word is Portrait.
• Default settings can be changed in the Page Setup dialog box under the Layout tab.

The correct answer is Bar chart.

Key Points

• Bar charts are particularly effective when dealing with long category names or when comparing data over some time.
• They are more readable than pie charts when the category labels are long, as they allow for clear spacing between bars.
• Bar charts in MS Excel 365 are used to represent comparisons between different categories, which is useful for showing trends over time.
• They work well when there are fewer data points but need to clearly show comparisons across multiple categories.

Additional Information

• Pie charts are best for showing proportional data, but not suitable for long category names or time-based comparisons.
• Line charts are ideal for trends over time, but bar charts may be more useful when comparing several categories.
• Column charts are a variant of bar charts and can also show comparisons over time, especially when categories are fewer or more evenly spaced.
• Bar charts are versatile and can be customized in Excel 365 to represent vertical or horizontal comparisons effectively.
• In Excel, the bar chart feature can be modified with various styles, such as clustered or stacked bars, to better represent time-based or categorical data.