Computer Knowledge PYQs

The correct answer is Print Preview.

Key Points

• The Print Preview command in MS Word 365 allows users to preview the document before printing it.
• This feature helps in ensuring that the document appears as expected and allows the user to make necessary adjustments before the final print.
• To access Print Preview, users can go to the File menu and select Print, or use the shortcut Ctrl + P.
• In the Print Preview screen, users can see how the document will look when printed and can also change printer settings, page orientation, and other print options.
• This feature is useful for checking the overall layout, margins, and spacing of the document to avoid wasting paper on incorrect prints.

 Additional Information

• Print
• The Print command is used to send the document directly to the printer without a preview.
• This command is useful when the user is already sure of the document's layout and content.
• View
• The View tab in MS Word 365 contains options to change the document's view mode, such as Read Mode, Print Layout, Web Layout, Outline, and Draft.
• It does not provide a print preview option.
• Layout Print Layout
• Print Layout view allows users to see how the document looks on the printed page, including headers, footers, and margins.
• However, it is not the same as Print Preview which shows the exact print output.

The correct answer is A, B, and C.

Key Points

• The Spelling and Grammar tool in MS Word 365 is a comprehensive feature that helps users to ensure their documents are free from spelling and grammatical errors.
• It can indicate grammatical errors, helping users identify sentences that may be incorrect or awkward.
• It can correct spelling errors as you type, providing real-time corrections to common spelling mistakes.
• It can also identify words with capitalization problems, ensuring proper noun capitalization and the beginning of sentences are correctly formatted.

 Additional Information

• Grammatical errors
• MS Word 365 uses advanced algorithms to detect and suggest corrections for grammatical errors, including subject-verb agreement, punctuation, and sentence structure.
• It helps users to improve the readability and professionalism of their documents.
• Spelling errors as you type
• This feature highlights misspelled words with a red underline, allowing users to correct them immediately.
• It also offers suggestions for the correct spelling, which can be selected with a right-click.
• Capitalization problems
• The tool identifies instances where proper nouns are not capitalized or where unnecessary capitalization occurs.
• It ensures that the document adheres to standard writing conventions and improves overall presentation.

The correct answer is Ctrl + X.

Key Points

• Ctrl + X is the standard shortcut key used to cut text or other elements in MS Word 365 as well as other Microsoft Office applications.
• When you use the cut command, the selected text or element is removed from its original location and placed in the clipboard, allowing you to paste it elsewhere.
• This shortcut is a part of the common set of keyboard shortcuts known as Ctrl commands, which are used for various operations like copying, pasting, and undoing actions.
• Using keyboard shortcuts like Ctrl + X can significantly increase productivity by saving time and reducing the need to navigate through menus.

 Additional Information

• Shift + X
• This combination is not assigned to any default function in MS Word 365.
• Ctrl + C
• Ctrl + C is the shortcut key for copying text or other elements, which duplicates the selected text or element without removing it from its original location.
• Ctrl + Shift + X
• This combination does not perform any specific function in MS Word 365 by default and may be available for customization by the user.

The Correct answer is MIN.

Key Points

• The MIN function in MS Excel 365 is used to find the smallest value in a range of cells.
• The syntax of the MIN function is =MIN(number1, [number2], ...).
• It can take multiple arguments, which can be numbers, cell references, or ranges.
• The MIN function ignores empty cells, text, and logical values like TRUE or FALSE.
• It is useful for identifying the minimum value in a dataset, such as the lowest score in a test or the minimum sales figure.
• The MIN function is part of the statistical functions in Excel and is frequently used in data analysis.

 Additional Information

• AVERAGE
• The AVERAGE function calculates the arithmetic mean of a group of numbers.
• The syntax is =AVERAGE(number1, [number2], ...).
• It adds up all the numbers and then divides by the count of numbers.
• SUM
• The SUM function adds all the numbers in a range of cells.
• The syntax is =SUM(number1, [number2], ...).
• It is commonly used to calculate the total of a column or row of numbers.
• COUNT
• The COUNT function counts the number of cells that contain numbers.
• The syntax is =COUNT(value1, [value2], ...).
• It is often used to count the number of entries in a number field that is in a range or array of numbers.

The Correct answer is Select the desired folder in the 'Save in' field of the 'Save As' dialog box and click on the 'Save' button.

Key Points

• In MS Excel 365, the 'Save As' dialog box allows you to save a duplicate of the workbook in a different location.
• You can navigate to the desired folder using the 'Save in' field.
• After selecting the folder, you can save the file with the same name by clicking on the 'Save' button.
• This method ensures that you do not overwrite the original workbook.
• It is a useful way to keep a backup or to organize files in different directories.

 Additional Information

• Press Ctrl + V
• Ctrl + V is a keyboard shortcut used for pasting content from the clipboard.
• This is not related to saving a file in a different folder in MS Excel.
• Press 'Ctrl + D'
• The Ctrl + D shortcut is generally used to fill down in Excel, which copies the contents and format of the top cell to the cells below.
• This shortcut does not help in saving a file.
• Click on the 'Insert' menu and select 'Save'
• There is no 'Save' option in the 'Insert' menu in MS Excel.
• The 'Insert' menu is used for inserting objects like charts, tables, and images into the workbook.

The correct answer is Ctrl + S.

Key Points

• In MS Excel 365, the keyboard shortcut Ctrl + S is used to save the current workbook.
• Using keyboard shortcuts improves efficiency and speed when working with software applications.
• The Ctrl + S shortcut is widely used across many applications for the save function, making it a standard keyboard shortcut.
• It helps in quickly saving the progress of your work without navigating through menus.
• Regularly saving your work can prevent data loss in case of unexpected software crashes or power failures.

 Additional Information

• Shift + S
• The Shift + S shortcut is not assigned to any specific function in MS Excel 365.
• Users can customize their shortcuts, but by default, Shift + S does not save a workbook.
• Shift + C
• Similarly, Shift + C is not a default keyboard shortcut for saving workbooks in MS Excel 365.
• Shift + C may be used in combination with other keys for customized shortcuts or specific functions.
• Ctrl + V
• The Ctrl + V shortcut is used to paste the copied content in MS Excel 365 and other applications.
• This is a standard shortcut for pasting content across various software applications.

The correct answer is ROR.

Key Points

• ROR does not refer to any type of network.
• In the context of networks, common types include LAN, MAN, and WAN.
• A network typically refers to a group of computers and other devices connected together to share resources.
• LAN (Local Area Network), MAN (Metropolitan Area Network), and WAN (Wide Area Network) are well-known network types based on their geographical spread.

 Additional Information

• LAN
• LAN (Local Area Network) typically covers a small geographic area like a home, office, or building.
• LANs are known for their high data transfer rates and limited geographic range.
• Examples include a network within a school or a small office network.
• MAN
• MAN (Metropolitan Area Network) spans a larger area than a LAN, such as a city or a large campus.
• It is designed to extend over several kilometers and often used to connect multiple LANs within a city.
• MANs are often used by organizations with multiple buildings within a city.
• WAN
• WAN (Wide Area Network) covers a broad area, potentially spanning countries or even continents.
• WANs are used to connect multiple LANs over large distances, using various communication channels like leased lines, satellites, or the internet.
• The Internet is the most well-known example of a WAN.

The correct answer is Save.

Key Points

• Save is used to update changes made in an existing document in Microsoft Word 365.
• It ensures that the latest modifications are stored in the same file without creating a new copy.
• Other options like Save Changes, Save All, Save With do not exist in MS Word menus.
• Save As is a different option, which is used to create a new copy of the document with a different name or location.

 Additional Information

• Save
• Overwrites the current document with the latest changes.
• Shortcut key: Ctrl + S.
• Used frequently during editing to avoid data loss.
• Save As
• Creates a new copy of the document under a new name or in a new location.
• Shortcut key: F12 (opens Save As dialog directly).
• Useful when you want to preserve the original file while making another version.

The correct answer is Subject line.

Key Points

• The subject line of an email is a brief summary of the email's content.
• It helps the recipient understand the purpose of the email before opening it.
• A well-crafted subject line can improve the chances of the email being opened and read.
• It is typically found at the top of the email, right after the sender's and recipient's information.
• The subject line can also affect whether the email is marked as spam by email filters.

 Additional Information

• Body text
• The body text is the main content of the email where the detailed message is written.
• It can include multiple paragraphs and can be formatted with bullet points, images, and links.
• Salutation
• The salutation is the greeting at the beginning of an email, such as "Dear" or "Hello".
• It helps to set the tone of the email and is followed by the recipient's name.
• Signature
• The signature is the block of text at the end of the email that provides the sender's contact information and other relevant details.
• It often includes the sender's name, title, company, and phone number.

The Correct answer is Margins.

Key Points

• Margins refer to the space between the edge of the paper and the text in MS Word 365.
• This space ensures that the text does not run into the edges of the paper, making the document look neat and professional.
• Margins can be customized in MS Word 365 to fit the user's requirements.
• Common margin settings in MS Word include Normal, Narrow, Moderate, and Wide.
• Proper margin settings are crucial for printing documents correctly and for binding purposes.

 Additional Information

• Orientation
• Orientation refers to the direction in which a document is displayed or printed.
• In MS Word 365, there are two types of orientations: Portrait and Landscape.
• Portrait orientation is taller than it is wide, while Landscape orientation is wider than it is tall.
• Columns
• Columns are used to divide the text into vertical sections.
• This feature is often used in newspapers, magazines, and other documents that require a multi-column layout.
• Columns help in organizing the content and making it easier to read.
• Size
• Size in MS Word refers to the paper size used for the document.
• Common paper sizes include A4, Letter, Legal, etc.
• Choosing the correct paper size is important for ensuring the document prints correctly and fits the intended purpose.

The correct answer is Define New Bullet.

Key Points

• Define New Bullet option allows users to create customized bullet styles in Microsoft Excel.
• This feature enables the insertion of different symbols, pictures, or customized bullet characters for lists.
• Custom bullets enhance the readability and visual appeal of the data presented in Excel sheets.
• It is particularly useful for creating professional and well-organized documents, making the information more engaging.

Additional Information

• Custom Bullet Styles
• Custom bullet styles can include symbols like dots, arrows, or any other special characters.
• Users can also use images or icons as bullet points for a more personalized touch.
• This feature is available in Microsoft Word and PowerPoint, in addition to Excel.
• Customized bullets can be saved and reused across different documents for consistency.
• Formatting Lists in Excel
• Excel allows for a variety of list formatting options including numbered lists and multilevel lists.
• Users can apply different styles and colors to bullets to match the document's theme.
• Excel also supports the use of conditional formatting to highlight specific items in a list.
• Additional Text Formatting Tools
• Excel provides various text formatting tools such as font changes, text color, and alignment options.
• These tools help in organizing and presenting data in a clear and professional manner.
• Users can also merge cells, wrap text, and use text boxes for better data presentation.

The correct answer is Ctrl + V.

Key Points

• Ctrl + V is the keyboard shortcut used to paste text or other data that has been cut or copied.
• This shortcut is commonly used in various software applications, including word processors, text editors, and web browsers.
• Using Ctrl + V helps improve efficiency and productivity by allowing quick pasting of information without using a mouse.
• The Ctrl + V command is supported in most operating systems, including Windows, Linux, and macOS.

Additional Information

• Ctrl + X
• This shortcut is used to cut selected text or data, removing it from the original location and placing it in the clipboard.
• It allows users to move content easily without duplicating it.
• Ctrl + C
• This shortcut is used to copy selected text or data, leaving the original content intact while placing a copy in the clipboard.
• It is useful for duplicating content across different parts of a document or between applications.
• Ctrl + P
• This shortcut is commonly used to open the print dialog in various applications, allowing users to print documents quickly.
• It helps streamline the printing process by providing quick access to printing options.

The correct answer is Uniform Resource Locator.

Key Points

• URL stands for Uniform Resource Locator.
• It is a reference to a web resource that specifies its location on a computer network and a mechanism for retrieving it.
• A URL is commonly known as a web address.
• URLs are used to access web pages, images, videos, and other resources on the internet.

Additional Information

• Components of a URL
• Scheme: The protocol used to access the resource (e.g., HTTP, HTTPS, FTP).
• Host: The domain name or IP address of the server hosting the resource.
• Path: The specific location of the resource in the directory structure of the server.
• Query: Optional parameters used to specify details about the resource.
• Fragment: An optional part that usually identifies a specific section of the resource.
• Importance of URLs
• URLs are essential for navigating the web and accessing information efficiently.
• They provide a means for users and search engines to locate and retrieve resources.
• URLs can be shared easily, making content accessible to a wide audience.
• HTTP vs. HTTPS
• HTTP (Hypertext Transfer Protocol) is the foundation of data communication on the web.
• HTTPS (Hypertext Transfer Protocol Secure) is an extension of HTTP that provides secure communication over a computer network.
• HTTPS is commonly used to protect sensitive data, such as online transactions and user information.
• URL Shorteners
• URL shorteners are services that create a short, unique URL that redirects to the original, longer URL.
• They are often used for easier sharing of links, especially on social media.
• Examples include bit.ly, tinyurl.com, and goo.gl.

The correct answer is File.

Key Points

• The 'Open' option in Microsoft Word 365 is located in the File tab.
• The File tab provides access to functions such as opening, saving, printing, and managing documents.
• When you click on the File tab, you enter the Backstage view, which includes the 'Open' option among other file management tasks.
• The 'Open' option allows users to navigate their file system to locate and open existing Word documents.

Additional Information

• Backstage View
• The Backstage view in Microsoft Office is a centralized space for managing your documents, including creating, saving, printing, and sharing files.
• It is accessed by clicking the File tab in the ribbon.
• This view is designed to help users efficiently manage their documents and settings.
• Ribbon Interface
• The Ribbon is a set of toolbars at the top of the window in Office programs, designed to help users quickly find the commands they need.
• It organizes commands into logical groups collected together under tabs.
• The Ribbon interface was introduced in Microsoft Office 2007 and has been a consistent feature in subsequent versions.
• Document Management
• Effective document management includes organizing, storing, and accessing files efficiently.
• Microsoft Word provides several tools for managing documents, such as version control, document properties, and metadata management.
• These tools help users maintain a structured and efficient workflow.
• File Formats
• Word documents can be saved in various formats, including .docx, .doc, .pdf, and .txt.
• The default format for Word documents is .docx, which is an Open XML format.
• Different formats serve different purposes, such as ensuring compatibility, reducing file size, or preserving formatting.

The correct answer is Help.

Key Points

• The 'Help' section in MS Word 365 includes various resources and support options for users.
• Users can access the 'Contact Us' feature to get in touch with Microsoft support for assistance.
• The 'Help' section often provides FAQs, troubleshooting guides, and contact details for further support.
• This section is designed to assist users in resolving issues and improving their experience with MS Word 365.

Additional Information

• Review Section:
• This section is used for proofreading and editing documents.
• It includes tools for spelling and grammar checks, thesaurus, and translation.
• There are also options for tracking changes and adding comments.
• Mailings Section:
• This section is mainly used for creating and managing mail merge operations.
• It allows users to create envelopes, labels, and mass-mail documents.
• It includes tools for selecting recipients and merging fields.
• References Section:
• This section helps in managing citations, bibliographies, and table of contents.
• It includes options to add footnotes, endnotes, and captions.
• Users can insert indexes and manage sources for academic writing.

The correct answer is Triple mouse click.

Key Points

• In MS Word 365, a triple mouse click is used to select an entire paragraph from the cursor's current position.
• When you triple-click a paragraph, it ensures that the entire paragraph is highlighted for editing or formatting purposes.
• This feature is particularly useful for quickly selecting and managing large blocks of text.
• Other common selection methods include double-clicking to select a word and single-clicking to place the cursor at a specific location.

Additional Information

• Single Mouse Click
• A single click places the cursor at the specific location within the text where the click occurs.
• This is the most basic and common mouse action for text selection and cursor placement.
• Double Mouse Click
• A double click selects an entire word where the cursor is placed.
• This action is helpful for quick word selection and editing.
• Text Selection Techniques
• Click and Drag: Click at the start of the text and drag the mouse to the end to select a custom text range.
• Shift + Arrow Keys: Use the keyboard to extend the selection one character, word, or line at a time.
• Ctrl + A: Selects all the text in the document.
• MS Word Editing Features
• Find and Replace: Quickly locate and replace specific text.
• Formatting Tools: Change font, size, color, and style of the selected text.
• Clipboard Functions: Cut, copy, and paste selected text.

The correct answer is +.

Key Points

• In MS Excel 365, the fill handle is a small square at the bottom-right corner of the selected cell or range of cells.
• Dragging the fill handle is used to copy cell contents or to complete a series (e.g., numbers, dates, or text).
• When dragging the fill handle, the + sign appears, indicating that the fill operation is active.
• The fill handle can be used to automatically continue a series, such as days of the week, months, or numerical sequences.
• It significantly enhances productivity by automating repetitive tasks in spreadsheets.

Additional Information

• AutoFill Feature
• AutoFill in Excel allows users to fill cells with repetitive or sequential data automatically.
• It can be used for text, numbers, dates, and formulas.
• Users can customize series by specifying the type of fill operation in the AutoFill options.
• Series Completion
• Excel can recognize patterns and automatically complete series based on the initial selection.
• Commonly used series include numeric sequences, dates, and weekdays.
• Custom Lists
• Users can create custom lists in Excel to use with the fill handle for personalized series.
• These lists can include any repetitive data, like department names or project codes.
• Fill Handle Shortcuts
• Double-clicking the fill handle copies the content down the column until it reaches an empty cell.
• Holding the Ctrl key while dragging the fill handle forces a copy instead of a series completion.

The correct answer is Outbox.

Key Points

• The Outbox is a folder in an email client where outgoing messages are temporarily stored.
• Emails remain in the Outbox until they are successfully sent to the recipient's email server.
• If there is an issue with sending the email (e.g., server problems, connectivity issues), the email will remain in the Outbox until the issue is resolved.
• Once the email is successfully sent, it typically moves from the Outbox to the Sent folder.

Additional Information

• Inbox
• The Inbox is where incoming emails are received and stored.
• It is typically the default folder that users check for new messages.
• Trash
• The Trash (or Deleted Items) folder stores emails that have been deleted by the user.
• Emails in the Trash can be permanently deleted or restored back to the Inbox or other folders.
• Sent Mail
• The Sent Mail folder contains copies of emails that have been successfully sent.
• It allows users to review their sent messages and track their communication history.

The correct answer is Sorts the selected column in an ascending order.

Key Points

• In MS-Excel 365, the "Sort A to Z" option sorts the data in the selected column in ascending order.
• Ascending order means sorting the data from smallest to largest or from A to Z for text entries.
• This sorting feature is commonly used to organize alphabetical lists and numerical data in a more readable and systematic manner.
• Sorting in ascending order helps in identifying patterns and making data analysis more efficient.
• MS-Excel 365 also provides the option to sort data in descending order from Z to A or largest to smallest.

Additional Information

• Sort Options in Excel
• In addition to sorting A to Z, Excel offers other sorting options such as Sort Z to A (descending order).
• Users can sort data by multiple columns to organize data in a more complex hierarchy.
• Filtering Data
• Excel provides filtering options which allow users to display only the rows that meet certain criteria.
• Filters can be applied to text, numbers, and dates to manage large datasets more effectively.
• Conditional Formatting
• Conditional formatting in Excel helps in highlighting cells that meet specific conditions.
• Users can apply color scales, data bars, and icon sets to make data visualization more intuitive.
• PivotTables
• PivotTables are a powerful feature in Excel for summarizing, analyzing, exploring, and presenting data.
• They allow users to transform large datasets into meaningful summaries with customizable layouts.

The correct answer is To keep a record of edits made to a document by different authors..

Key Points

• Track Changes allows multiple authors to collaborate on a document by marking changes such as insertions, deletions, and formatting adjustments.
• This feature is essential for reviewing and editing documents in a collaborative environment, ensuring transparency and accountability.
• Each author's changes are highlighted in different colors, making it easy to identify who made specific edits.
• Track Changes also provides the option to accept or reject edits, facilitating a smooth review process.
• It is widely used in professional settings such as legal, academic, and corporate environments to maintain the integrity of the original document while enabling efficient collaboration.

Additional Information

• Markup:
• Markups indicate where changes have been made in the document, including additions, deletions, and comments.
• Different types of markups include simple markup, all markup, no markup, and original.
• Comments:
• Comments allow collaborators to add notes or explanations regarding specific parts of the document.
• Comments are displayed in the margin and can be replied to, creating a thread of discussion.
• Compare Documents:
• This feature allows users to compare two versions of a document to see what changes have been made between them.
• It is useful for identifying differences and ensuring that all changes have been reviewed and approved.
• Review Pane:
• The Review Pane provides a summary of all changes and comments in the document, making it easier to navigate through them.
• It can be displayed vertically or horizontally, depending on user preference.