Computer Knowledge PYQs

The correct answer is Mozilla Firefox .

Key Points

• Mozilla Firefox
• Mozilla Firefox is a free and open-source web browser developed by the Mozilla Foundation.
• It's used to access and browse the internet, allowing users to view websites, interact with web pages, and download files.
• Known for its strong emphasis on user privacy, customization options (extensions), and support for web standards.
• Established: 1998
• Headquarters: San Francisco, California, United States
• Founder: Netscape Communications Corporation (initially)

Additional Information

• Outlook 365
• Outlook 365 is a personal information manager and email client developed by Microsoft as part of the Microsoft 365 suite.
• Primarily used for email management, including sending, receiving, organizing, and storing emails. It also includes features like calendar scheduling, contact management, and task management.
• Established: 1996 (as part of Microsoft Office)
• Headquarters: Redmond, Washington, United States
• Founder: Bill Gates and Paul Allen (Microsoft founders)
• Yahoo Mail
• Yahoo Mail is a free web-based email service provided by Yahoo!
• Allows users to send, receive, and manage emails, often integrated with other Yahoo! services.
• Features like spam filtering, storage space, and mobile app availability.
• Established: 1997
• Headquarters: Sunnyvale, California, United States
• Founder: Jerry Yang and David Filo (Yahoo! founders)
• Google Search
• Google Search is a web search engine developed by Google.
• It's the most widely used search engine, enabling users to find information on the internet by entering keywords or phrases.
• Established: 1998
• Headquarters: Mountain View, California, United States
• Founder: Larry Page and Sergey Brin

The correct answer is It identifies and provides suggestions to correct grammatical errors in the text. 

Key Points

• The 'Review' tab in Microsoft Word contains tools related to reviewing and checking your document for errors.
• The Spelling & Grammar feature helps you identify and correct spelling and grammatical errors in your document.
• Using this feature, you can ensure that your document is free from common writing mistakes, which can improve the overall quality and professionalism of your work.
• The feature also offers suggestions for corrections, making it easier for you to edit your content efficiently.

 Additional Information

• Microsoft Word
• Microsoft Word is a word processing software developed by Microsoft, and it is part of the Microsoft Office suite.
• It is used for creating, editing, formatting, and sharing text documents.
• Word offers a range of features including spell check, grammar check, text formatting, and the ability to insert images, tables, and other elements.
• It is widely used for creating professional documents such as reports, letters, and resumes.
• Spelling & Grammar Check Feature
• This feature scans your document for spelling errors (such as typos) and grammatical issues.
• It provides suggestions for corrections, allowing you to choose whether to accept or ignore each suggestion.
• Using this feature regularly can help improve the quality of your writing and ensure clarity and correctness.
• It is especially useful for professional and academic documents where precision in language is essential.
• Review Tab in MS Word
• The Review tab contains tools for proofing, tracking changes, and collaborating with others on a document.
• In addition to Spelling & Grammar, it includes features like 'Track Changes', 'Comments', 'Compare', and 'Thesaurus'.
• These tools help users manage document review processes, ensuring that all changes and feedback are tracked and addressed.
• The Review tab is essential for collaborative work and for finalizing documents before publication or submission.

The correct answer is 16,384 columns.

Key Points

• The maximum number of columns existing in MS-Excel 2010 is 16,384.
• Excel's Grid Structure: Excel utilizes a grid system to organize data. This grid consists of rows and columns, forming a table-like structure.
• Column Designations: Columns are typically labeled with letters (A, B, C, etc.). However, as the number of columns increases, Excel uses a combination of letters for designation (e.g., AA, AB, AC, ..., AZ, BA, BB, and so on).
• Increased Capacity: Earlier versions of Excel had limitations on the number of columns. However, with advancements in technology and software development, newer versions like Excel 2010 significantly increased the column limit to accommodate larger datasets and more complex spreadsheets.
• Practical Implications: This substantial column capacity allows users to work with extensive datasets, perform complex calculations, and create sophisticated spreadsheets for various purposes, such as financial modeling, data analysis, and project management.

Additional Information

• The 16,384 columns provide ample space for most practical spreadsheet needs.
• This limit ensures that users can comfortably work with large amounts of data without encountering limitations in column availability.
• Excel's continuous evolution aims to provide users with the flexibility and capacity to handle increasingly complex data management tasks.

The correct answer is Data.

Key Points

• Data
• In Excel 365: This refers to the raw information you input into the spreadsheet. It can be numbers, text, dates, times, or even images.
• Key Aspects:
• Data Entry: You input data directly into cells, import it from other sources (like text files or databases), or connect to live data feeds.
• Data Types: Excel recognizes various data types, which influences how it's displayed, calculated, and analyzed.
• Data Organization: Effective data organization (using rows and columns, tables, and worksheets) is crucial for efficient analysis and management.

Additional Information

• Review
• In Excel 365: This refers to a set of tools designed to help you check for errors, ensure accuracy, and improve the quality of your data.
• Key Features:
• Spelling and Grammar Check: Helps identify and correct errors in text within cells.
• Comments: Allows you to add notes or questions to specific cells for collaboration or future reference.
• Track Changes: Enables you to see and manage changes made to the spreadsheet by different users.
• Edit
• In Excel 365: This encompasses all the actions you take to modify the data within your spreadsheet.
• Key Actions:
• Cell Editing: Entering, changing, or deleting data within individual cells.
• Formula Editing: Modifying existing formulas or creating new ones to perform calculations.
• Formatting: Applying formatting (e.g., fonts, colors, cell styles) to improve readability and presentation.
• Cutting, Copying, and Pasting: Moving or duplicating data within or between worksheets.
• Formula
• In Excel 365: A formula is an expression that performs calculations on the data in your spreadsheet.
• Key Concepts:
• Syntax: Formulas follow specific rules (syntax) using operators (like +, -, *, /) and functions (like SUM, AVERAGE, IF).
• Cell References: Formulas can refer to data in other cells, allowing for dynamic calculations.
• Built-in Functions: Excel provides a wide range of built-in functions for various calculations, from simple arithmetic to complex statistical and financial analyses.

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

Key Points

• Simple Mail Transfer Protocol (SMTP)
• Function: Primarily used for sending emails from one server to another.
• Delivery Focused: It's specifically designed to handle the transmission of emails between mail servers.
• Push Protocol: Emails are "pushed" from the sender's server to the recipient's server using SMTP.

Additional Information

• Internet Message Access Protocol (IMAP)
• Function: Allows users to access and manage emails remotely on a mail server.
• Synchronization: Enables email synchronization across multiple devices (e.g., computer, phone, tablet).
• Server-Side Operations: Many operations (like deleting, moving, and flagging emails) are performed directly on the server.
• Flexibility: Offers more advanced features like searching and filtering emails directly on the server.
• Hypertext Transfer Protocol (HTTP)
• Function: The foundation of data communication on the World Wide Web. It's used to transfer web pages, images, and other resources between web servers and web browsers.
• Client-Server Model: Based on a request-response model where the client (browser) requests a resource, and the server responds with the requested data.
• Stateless: Each request and response is independent of previous interactions.
• Post Office Protocol (POP3)
• Function: Primarily used for retrieving emails from a mail server to a local device.
• Download and Deletion: Typically, emails are downloaded to the local device and deleted from the server.
• Limited Synchronization: Less suitable for synchronizing emails across multiple devices.

The correct answer is File.

Key Points

• File
• In Excel: This tab houses commands related to managing your workbook.
• New: Creating a new, blank workbook.
• Open: Opening an existing Excel file.
• Save: Saving the current workbook.
• Save As: Saving the workbook with a new name or in a different format.
• Print: Printing the selected worksheets or the entire workbook.

Additional Information

• Home
• In Excel: This is the default tab, providing access to the most frequently used commands.
• Formatting: Applying styles, fonts, colors, and number formats to cells.
• Alignment: Aligning cell contents (left, right, center, etc.).
• Editing: Cutting, copying, pasting, and deleting cells.
• Summing: Quickly calculating sums of selected cells.
• Edit
• In Excel: This tab contains commands for manipulating and modifying data within the spreadsheet.
• Find & Select: Finding and selecting specific cells, data, or formats.
• Clear: Clearing cell contents, formats, or both.
• Insert: Inserting rows, columns, or cells.
• Delete: Deleting rows, columns, or cells.
• Insert
• In Excel: This tab allows you to add various elements to your worksheet.
• Tables: Inserting and formatting tables.
• Charts: Creating different types of charts (bar, line, pie, etc.).
• Illustrations: Inserting images, shapes, and icons.
• Links: Inserting hyperlinks to other cells, worksheets, or external websites.

The correct answer is Ctrl + O.

Key Points

• Ctrl + O
• Function: This shortcut key is used to open an existing document in Microsoft Word.
• Press and hold the Ctrl key.
• While holding Ctrl, press the O key.
• This will open the "Open" dialog box, allowing you to browse and select the document you want to open.

Additional Information

• Ctrl + I
• Function: This shortcut key is used to apply italics to the selected text.
• Select the text you want to format.
• Press and hold the Ctrl key.
• While holding Ctrl, press the I key.
• The selected text will be formatted in italics.
• To remove italics, simply press Ctrl + I again.
• Ctrl + U
• Function: This shortcut key is used to underline the selected text.
• Select the text you want to format.
• Press and hold the Ctrl key.
• While holding Ctrl, press the U key.
• The selected text will be underlined.
• To remove the underline, press Ctrl + U again.
• Ctrl + B
• Function: This shortcut key is used to apply bold formatting to the selected text.
• Select the text you want to format.
• Press and hold the Ctrl key.
• While holding Ctrl, press the B key.
• The selected text will be formatted in bold.
• To remove bold formatting, press Ctrl + B again.

The correct answer is Page layout .

Key Points

• Page Layout
• Definition: This refers to the overall visual arrangement and organization of elements on a page within your Word document.
• Margins: Control the space around the edges of your document (top, bottom, left, right).
• Orientation: Choose between Portrait (vertical) or Landscape (horizontal) page orientation.
• Columns: Divide your page into multiple columns for better readability or presentation.
• Breaks: Insert page breaks, section breaks, and column breaks to control how content flows across pages.
• Indents and Spacing: Adjust paragraph indentation, line spacing, and spacing before/after paragraphs.

Additional Information

• Document Content and Editing Options
• Content: This encompasses all the text, images, tables, charts, and other elements that make up your document.
• Editing Options: Word 365 provides a wide range of tools for editing your content, including:
• Typing and Formatting: Entering text, applying fonts, styles, and colors.
• Editing and Proofreading: Finding and replacing text, spell check, grammar check, and thesaurus.
• Collaboration: Sharing documents with others, tracking changes, and collaborating in real-time.
• Printer Connectivity and Network Settings
• Printer Connectivity: Word 365 allows you to connect to various printers, including local printers and network printers.
• Network Settings: You can configure printer settings, such as paper size, orientation, and number of copies, within Word 365.
• Print Preview: Before printing, you can preview your document to see how it will look on the printed page.
• Font Styles and Sizes
• Font Styles: Word 365 offers a vast library of fonts, including serif, sans-serif, and script fonts, allowing you to choose the best font for your document's style and purpose.
• Font Sizes: You can easily adjust the size of your text to suit your needs, from small font sizes for footnotes to larger sizes for headings.
• Font Formatting: You can apply various formatting options to your text, such as bold, italics, underline, and color.

The correct answer is Makes the text smaller and above the baseline.

Key Points

• The "Superscript" feature in Microsoft Word 365 is a text formatting tool that allows you to raise the selected characters slightly above the baseline of the normal text.
• Its function and common uses:
• Appearance: Superscripted text appears smaller than the surrounding text and is positioned higher, giving it a distinct visual appearance.
• Common Uses:
• Mathematical Expressions:
• Exponents: For example, "x²" (where the "2" is superscripted to indicate "x squared").
• Chemical Formulas: Representing chemical compounds with superscripts for charges or isotopes.
• Footnotes and Endnotes:
• Displaying small, raised numbers or symbols to indicate references or additional information.
• Ordinal Numbers:
• Representing ordinal numbers like "1^st," "2^nd," "3^rd," where the "st," "nd," and "rd" are superscripted.
• Trademarks and Symbols:
• Displaying symbols like ® (registered trademark), ™ (trademark), and © (copyright) as superscripts.
• Units of Measurement:
• Representing units like degrees Celsius (°C) or Fahrenheit (°F) with the degree symbol as a superscript.
• How to Use the Superscript Feature in Word 365:
• Using the Ribbon:
• Select the text you want to format as superscript.
• Go to the "Home" tab in the Ribbon.
• In the "Font" group, click the "Superscript" button.
• Using the Keyboard Shortcut:
• Select the text you want to format as superscript.
• Press and hold the Ctrl key, Shift key, and the "+" key simultaneously.

The correct answer is Blank page with a default name “Document1”.

Key Points

• Here's a breakdown of what happens:
• The Word 365 application loads into memory.
• This involves initializing the user interface, loading necessary libraries and resources, and establishing connections to system services.
• User Interface:
• The familiar Word interface appears, consisting of:
• Ribbon: A customizable toolbar with tabs for various commands (Home, Insert, Design, Layout, References, Mailings, Review, View).
• Quick Access Toolbar: A customizable toolbar for frequently used commands (Save, Undo, Redo).
• Backstage View: Accessed by clicking the "File" tab, it provides options for opening, saving, printing, and managing documents.
• Workspace: The main area where you'll type and edit your document.
• Default Settings:
• Word loads with default settings, such as font, font size, margins, and line spacing. These settings can be customized to your preferences.
• Ready for Input:
• Once loaded, Word is ready for you to start typing, pasting text, inserting images, and creating your document.
• Cloud Integration:
• If you're signed in to your Microsoft 365 account, Word will automatically sync with your OneDrive cloud storage, allowing you to access and save documents seamlessly across different devices.
• Collaboration Features:
• Word 365 facilitates real-time collaboration, enabling multiple users to work on the same document simultaneously and see each other's changes.
• Assistance Tools:
• Features like spell check, grammar check, and thesaurus are automatically activated to assist you in creating error-free and well-written documents.

The correct answer is Ctrl+N

Key Points

• The keyboard shortcut to open a new blank document in Microsoft Word 365 is Ctrl + N.
• Using the keyboard shortcut Ctrl + N allows users to quickly start a new document without navigating through the menu options.
• Keyboard shortcuts can significantly enhance productivity by reducing the time taken to perform common tasks.

Additional InformationHere are some other keyboard shortcuts for Microsoft Word: 

Ctrl + S: Saves a document

Ctrl + C: Copies selected text

Ctrl + V: Pastes copied text

Ctrl + Z: Undoes the last action

Ctrl + Home: Goes to the start of the document

Ctrl + Enter: Inserts a page break

Shift + Enter: Creates a new line in a paragraph

Ctrl + R: Aligns the line or selected text to the right of the screen

The correct answer is Justify

Key Points

• In Microsoft Word 365, the Justify alignment is used to format the text so that it extends to both the left and right margins, ensuring the text fills the entire width of the line.
• This alignment adjusts the spacing between words to make the text look uniform on both sides,
• It create straight edges on both the left and right sides of each paragraph.
• Example: "The quick brown fox jumps over the lazy dog."
• The words are spaced out so that the left and right edges are aligned, creating a clean, block-like appearance.

Additional Information

• Right alignment:
• This aligns the text to the right margin, leaving the left side ragged.
• It’s useful for right-to-left languages or when formatting elements like dates in certain documents.
• Example:The quick brown fox The text starts from the right and leaves the left side uneven.
• Center:
• ​This aligns the text to the center of the page, leaving both sides uneven.
• It’s often used for titles, headings, or decorative text.
• Left alignment:
• This aligns the text to the left margin, leaving the right side ragged.
• It’s the default alignment used for most documents in Word.

The correct answer is Upper and lower bounds for row heights are 409 and 0, respectively.

Key Points

• In MS Excel 2010, the row height refers to the vertical size of a row, which determines how much space each row occupies in the worksheet.
• The maximum row height in Excel 2010 is 409 points.
• A point is a unit of measurement used in Excel, where 1 point equals 1/72 of an inch.
• When you increase the row height to its maximum value, the height of the row is 409 points, which is quite large and suitable for displaying content that requires a lot of vertical space (like larger font sizes, multiple lines of text, etc.).
• The minimum row height is 0 points.
• A height of 0 means the row is completely collapsed and won't be visible.
• Essentially, a row with a height of 0 points won't take up any space in the worksheet.

The correct answer is Dial up

Key Points

• The type of internet connection that uses a telephone line for data transmission is Dial up.
• Dial-up internet directly utilizes the existing telephone line to connect to the internet, requiring you to "dial" a number to establish a connection.
• It is an older, slower internet connection that uses a standard phone line to connect
• Dial-up is prone to interruptions and slowdowns

Additional Information

• Satellite:
• A type of internet connection that uses orbiting satellites to transmit data,
• It is often used in remote areas where other options are unavailable; considered a form of broadband when delivering high speeds.
• Broadband:
• ​It is a general term for high-speed internet connections
• It includes options like cable, DSL, and fiber optic, offering significantly faster speeds than dial-up.
• Fibre optic:
• ​It is a type of broadband connection that transmits data using light signals through glass fibers, considered the fastest and most reliable wired internet option.

The correct answer is Mailings

Key Points

• In Microsoft Office Professional Plus 2016, the Mail Merge feature is used to create personalized documents such as letters, labels, envelopes, and emails by merging a data source (like a spreadsheet) with a template document.
• It will find the "Start Mail Merge" option under the Mailings tab.
• This tab specifically contains all the options related to creating and managing mail merges.
• After clicking Start Mail Merge, you'll be prompted to select the document type you want to create (e.g., Letters, Envelopes, Labels, Email Messages).

Additional InformationTypes of Mail Merge:

• Letters: Personalized letters for each individual based on the data.
• Envelopes: Personalized address information for each recipient on different envelopes.
• Labels: Personalized labels, often used for bulk mailing.
• Email Messages: Used to send personalized emails to each recipient from your data source.
• Directory: A document listing personal details for multiple people, like a phonebook.

The correct answer is Line spacing

Key Points

• In MS Word 365, Paragraph Formatting refers to adjusting the settings that control the appearance and structure of paragraphs in your document.

• Line Spacing:

• This is a part of paragraph formatting.

• It controls the amount of space between lines in a paragraph.

• You can adjust it to set single, 1.5, double, or custom spacing.

• It's a key aspect of making text more readable.

Additional Information

The correct answer is The cell in the third column and the tenth row

Key Points

• In an electronic spreadsheet like Microsoft Excel or Google Sheets, each cell is identified by a unique address, which is a combination of a column letter and a row number.
• Columns are labeled with letters (A, B, C, D, etc.). After Z, the labels go to double letters (AA, AB, AC, etc.).
• Rows are numbered (1, 2, 3, 4, etc.)
• So, "C" refers to the third column, and "10" refers to the tenth row

Additional Information

• The CELL function returns information about the formatting, location, or contents of a cell.

MS-Excel Worksheets

• The term Worksheet used in Excel documents is a collection of cells organized in rows and columns.
• It is the working surface you interact with to enter data.
• Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

The correct answer is Ctrl + ]

Key Points

• To increase the font size of selected text in Microsoft Word, you can use the keyboard shortcut Ctrl + ] or Ctrl + Shift + >.
• This shortcut increases the font size of the selected text by one point each time you press it.
• For example, if the text is set to 12-point font, pressing Ctrl + ] will increase it to 13-point font.
• Each press of the shortcut increases the size by one increment.

Additional Information

The correct answer is Password

Key Points

• During the process of authentication, a system needs to verify that the person trying to access it is who they say they are.
• This verification typically involves checking the user's identity against information stored in the system.
• A "password" is the secret string of characters used to verify a user's identity during the authentication process.
• This is the secret code that only the user knows and is used to confirm their identity when logging into a system.
• The password helps ensure that even if someone knows the username, they cannot access the account without the password.

Additional Information

• Username:
• This is a unique identifier for the user, often used in combination with a password.
• Domain Name:
• This refers to the name of a website or online service, like "google.com."
• Website:
• This is the address or platform you visit online, like a social media platform or an email provider.

The correct answer is B3

Key Points

• In MS Excel, cell addresses are specified by a combination of column letters and row numbers:
• Columns are labeled alphabetically (A, B, C, D, etc.).
• The first column is "A," the second column is "B," and so on.
• Rows are numbered starting from 1, going downwards (1, 2, 3, 4, etc.).
• Second column: As mentioned, the second column is labeled B.
• Third row: The third row is labeled as 3.

Additional Information In Excel, you can use three types of cell references:

• Relative Reference (e.g., A1):
• The most common type of reference.
• When you copy a formula with a relative reference, the reference adjusts based on the position of the new cell.
• Example: If you copy a formula from cell B2 (where the formula is referencing cell A1), and paste it into B3, the reference will automatically adjust to A2.
• Absolute Reference (e.g., $A$1):
• An absolute reference locks the column and row in place, meaning that when you copy the formula, the reference will not change.
• Example: If you copy a formula from cell B2 with the reference $A$1, it will always reference cell A1, no matter where you paste the formula.
• Mixed Reference (e.g., $A1 or A$1):
• In a mixed reference, either the column (e.g., $A1) or the row (e.g., A$1) is fixed, while the other part is relative.
• Example: If you copy a formula from B2 with the reference $A1, the row (1) remains fixed, but the column (A) will change when copied across columns$.