Computer Knowledge PYQs

The correct answer is ​‘Reply’ sends the response only to the original sender, while ‘Reply all’ sends the response to all recipients of the original email.

 Key Points

• Using the TO Field: Under email etiquette, the TO field should contain the email's primary recipient(s). This field needs to contain the recipients who must respond to the email in order for it to be more accurate.
• Add the recipients to the "To" field. Moreover, you can add recipients: in both the "Cc" and "Bcc" fields. When writing a message, including the contact's name in the text field along with the "+" or "@mention" symbol.
• The "To" field is the recipient field that is the easiest to understand. It's intended for your email's primary recipients. These recipients should be the primary focus of your message.

 Additional Information

• The Bcc (blind carbon copy) box in an email message allows you to send a duplicate of the message to a specific recipient while hiding their name from other recipients.
• The Bcc box will show up whenever you create a message from the time you turn it on until you turn it off.
• A copy of the email you are sending will also be sent to the email address you enter in the "carbon copy" or "CC" field.
• The first line of text recipients sees when they open your email is the subject line.

The correct answer is Format painter.

Key Points

• Format painter
• Format Painter is a tool that allows users to copy formatting from one part of a document and apply it to another part. This can include text formatting (like font style, size, and color) as well as paragraph formatting (like alignment and line spacing).
• It is commonly used in various Microsoft Office applications such as Word, Excel, and PowerPoint.
• Using Format Painter can save time and ensure consistency in document formatting.

 Additional Information

• Paragraph alignment
• The alignment buttons in the Home tab in the Paragraph section allows us to change the alignment.
• Left
• Right
• Centre
• Justified
• It also provides the alignment for other objects such as picture, symbol, shapes etc.

SmartArt:- The variety of visuals available in Word that you may use to make diagrams, including flow charts, process charts, organizational charts, and similar graphics, is referred to as "SmartArt."

The correct answer is Ctrl + S.

Key Points

• Ctrl + S: Saves the currently open workbook.
• Ctrl + Alt + S: Opens the Save As dialog box, allowing you to save the workbook with a new name or to a different location.
• Shift + S: No specific function in Excel.
• Ctrl + Shift + S: Saves the workbook and closes it simultaneously.

The correct answer is Preview.

Key Points

• Preview: Displays a simulated printed version of your document, allowing you to check for layout issues, page breaks, and overall appearance before actually printing.

Additional Information

• General: Refers to the main settings and options for a document, such as font, font size, line spacing, and paragraph alignment.
• Textbox Options: Controls the appearance and behavior of text boxes within your document, including their size, color, border, and shading.
• Indentation: Adjusts the spacing of text from the left or right margins, creating visual structure and hierarchy within your document.
• Indentation: Can be applied to paragraphs, lists, and individual lines of text, using options like first line indent, hanging indent, and left/right indent.

The correct answer is Filter by selected cell height.

Key Points

• AutoFilter is an Excel feature that lets you filter out rows from a data table.
• The Filter tool in MS excel gives the user the ability to filter a row or column in a table to isolate the essential components that the user needs.
• Data filter in MS excel refers to displaying only the rows that meet the required conditions and other rows will be hidden.​

 Additional Information

• Microsoft Excel is a spreadsheet developed by Microsoft in 1987 which helps us in graphing tools, pivot tables, calculations, etc.
• The Microsoft Word or MS Word is a word processor or a graphical word processing program that allows users to type and save documents.
• The current CEO of Microsoft Corporation is Mr.Satya Nadella. Satya Nadella is the CEO of Microsoft since 2014.

The correct answer is Office button.

Key Points

• Office Button: The primary access point for file management tasks like opening, saving, printing, and closing workbooks. It replaced the traditional File menu in Excel 2007.

Additional Information

• Home: Contains the most frequently used commands for working with cells, including formatting (fonts, styles, alignment), editing (cut, copy, paste, clear), and cell operations (insert, delete, merge).
• Insert: Allows you to add various elements to your worksheet, such as charts, pictures, shapes, tables, and pivot tables.
• Format: Provides tools to customize the appearance of cells, ranges, and charts, including cell styles, conditional formatting, and data bars.

The correct answer is Strikethrough.

Key Points

• Strikethrough: Applies a diagonal line through the text, visually indicating that the text is no longer relevant or accurate.
• Line: Refers to the horizontal lines that separate rows and columns in a table within Word. You can adjust line styles (solid, dashed, dotted), weight, and color.
• Dash: A type of line style that creates a broken line with gaps between the segments. It can be used for various purposes, such as creating borders, separators, or visual effects.
• Underline: Adds a line beneath the text, emphasizing or highlighting it. You can choose from different underline styles, such as single, double, wavy, and dotted.
• Underline: Can also be applied to specific words or phrases within a sentence for added emphasis.

The correct answer is Network layer.

Key Points

• Network Layer: Responsible for logical addressing (IP addresses) and routing data packets between different networks.

Additional Information

• Transport Layer: Ensures reliable data delivery between applications, managing end-to-end communication (e.g., TCP, UDP).
• Data Link Layer: Handles the physical transmission of data frames over a single network segment, including error detection and correction.
• Application Layer: Provides services for user applications, such as email (SMTP), web browsing (HTTP), and file transfer (FTP).

The correct answer is ‘Save’ is used to save the document for the first time, while ‘Save As’ is used to save the document with a new name or different file format.

Key Points

• Save:
• This command updates the existing file with the current changes. It overwrites the previous version of the file, effectively replacing it with the latest modifications. This is typically used for ongoing work on a document, where you want to preserve the most recent changes to the same file.
• Save As:
• This command creates a new copy of the file, allowing you to save it under a different name or in a different location. This preserves the original file intact while creating a separate version of the document. This is useful when you want to:
• Create a backup: Save a copy of the file for safekeeping.
• Save different versions: Maintain multiple versions of the document with different modifications.
• Change the file format: Save the document in a different format (e.g., PDF, RTF, or DOCX).
• Save the file in a different location: Move the file to a different folder or drive.
• In essence:
• Save: Updates the existing file.
• Save As: Creates a new copy of the file.

The correct answer is Indenting.

Key Points

• Indenting: Adjusts the spacing of text from the left or right margins, creating visual structure and hierarchy within your document.

Additional Information

• Page Breaks: Force a new page to begin at a specific location in your document, ensuring content starts at the top of a new page.
• Border: A line or decorative element that outlines or frames text, paragraphs, or tables, enhancing visual presentation.
• Line Spacing: Controls the amount of vertical space between lines of text, affecting readability and visual appearance.
• Line Spacing: Options include single, double, multiple, and at least, allowing for customized spacing based on your document's needs.

The correct answer is DNS Server.

Key Points

• DNS Server (Domain Name System Server):
• Translates human-readable website addresses (like [invalid URL removed]) into machine-readable IP addresses (like 172.217.160.142).
• Enables users to access websites by their names instead of memorizing complex IP addresses.
• Plays a crucial role in how the internet functions.

Additional Information

• Firewall:
• Acts as a security barrier between your computer and the internet.
• Monitors incoming and outgoing network traffic, blocking malicious attempts to access your computer or network.
• Helps prevent unauthorized access, viruses, and other cyber threats.
• Modem:
• Modulates and demodulates data signals.
• Converts digital data from your computer into analog signals for transmission over communication lines (like phone lines or cable lines).
• Enables your computer to connect to the internet through your internet service provider (ISP).
• Router:
• Directs network traffic between different devices on a network.
• Connects multiple devices (like computers, smartphones, and smart home devices) to a single internet connection.
• Allows devices to communicate with each other within the network and with the internet

The correct answer is Press F1.

Key Points

• F1:
• Typically opens the Help menu or displays help information within an application.
• This is a common shortcut across many programs.

Additional Information

• F6:
• Often moves the cursor to the address bar in web browsers.
• This allows for quick navigation between pages.
• F10:
• Activates the menu bar of the currently active application.
• This enables you to access menus and commands without using the mouse.
• F7:
• Usually initiates spell check and grammar check within applications like word processors.
• This helps ensure the accuracy of your written content.

The correct answer is Pagination.

Key Points

• Pagination:
• The process of numbering pages in a document.
• In Microsoft Word 2019, you can easily insert page numbers into headers or footers.
• You can customize the numbering style (e.g., 1, 2, 3 or i, ii, iii) and choose where the numbers appear on the page.

Additional Information

• General:
• Refers to the default font and paragraph settings in Microsoft Word 2019.
• These settings can be customized to your preferences.
• The General tab in the Font and Paragraph dialog boxes allows you to adjust font size, style, color, spacing, alignment, and more.
• Indentation:
• The amount of space by which a line or paragraph is set in from the margin.
• In Word 2019, you can easily adjust indentation using the rulers or the Paragraph dialog box.
• Indentation is commonly used for creating lists, quotations, and creating visual structure within your document.
• Spacing:
• Refers to the amount of space between lines and paragraphs in a document.
• In Word 2019, you can adjust line spacing (e.g., single, double, or multiple) and paragraph spacing (before and after paragraphs) using the Paragraph dialog box.
• Proper spacing enhances readability and the overall appearance of your document.

The correct answer is Undo.

Key Points

• Undo:
• This command reverses the last action you performed in the Excel worksheet.
• For example, if you accidentally deleted a cell, you can use Undo to restore
• it. It's a crucial tool for quickly correcting mistakes.
• Shortcut Key: Ctrl+Z

Additional Information

• Paste:
• This command inserts the content that was previously copied or cut.
• You can paste data, formulas, formatting, or even entire cell ranges.
• Excel offers various paste options, such as pasting values only, formulas only, or formatting only.
• Shortcut Key: Ctrl+V
• Save:
• This command stores the current state of your Excel worksheet in a file.
• Saving your work regularly is essential to prevent data loss.
• In Excel 365, your work is automatically saved to the cloud, but manual saving provides an extra layer of security.
• Shortcut Key: Ctrl+S
• Copy:
• This command creates a duplicate of the selected cells.
• The copied content can then be pasted elsewhere in the same worksheet or into a different worksheet or document.
• This is a fundamental tool for efficiently moving and duplicating data within Excel.
• Shortcut Key: Ctrl+C

The correct answer is Ctrl + A.

Key Points

• Ctrl + A:
• This powerful shortcut selects all cells within the current worksheet.
• It's incredibly useful for tasks like formatting, copying, pasting, or deleting the entire contents of a sheet.

Additional Information

• Ctrl + X:
• This shortcut cuts the selected cells.
• The cut cells are temporarily stored in the clipboard, allowing you to paste them elsewhere in the worksheet or in another document.
• Unlike copying, cutting removes the cells from their original location.
• Ctrl + C
• This command creates a duplicate of the selected cells.
• The copied content can then be pasted elsewhere in the same worksheet or into a different worksheet or document.
• This is a fundamental tool for efficiently moving and duplicating data within Excel.
• Ctrl + Z
• This command reverses the last action you performed in the Excel worksheet.
• For example, if you accidentally deleted a cell, you can use Undo to restore
• it. It's a crucial tool for quickly correcting mistakes.

The correct answer is F2.

Key Points

• F2:
• Edits the active cell: This key places the cursor within the active cell, allowing you to directly modify its contents (text, numbers, formulas).

Additional Information

• Ctrl + E:
• Fills data with Flash Fill: This powerful shortcut analyzes patterns in adjacent cells and automatically fills the current column based on the detected pattern.
• For example, if you have a list of names in one column and start typing the first few letters of another name in the next column, Ctrl+E will often complete the rest of the name for you.
• Ctrl + C:
• Copies the selected cells: This shortcut creates a copy of the selected data, which can then be pasted elsewhere within the worksheet or in another document.
• F12:
• Saves the workbook as: This shortcut opens the "Save As" dialog box, allowing you to save the current workbook with a new name, in a different location, or in a different file format (e.g., .xlsx, .xlsb, .csv).

The correct answer is Ctrl + Shift + F.

Key Points

• Ctrl + Shift + F:
• This shortcut opens the Advanced Find and Replace dialog box.
• This provides more advanced search options than the basic Find and Replace, allowing you to search for specific formats, wildcards, and more.

Additional Information

• Ctrl + Alt + F:
• This shortcut opens the Find dialog box.
• This enables you to quickly search for specific words or phrases within your document.
• Ctrl + F:
• This is the most common shortcut for finding text.
• It opens the Find dialog box, allowing you to search for specific words or phrases within your document.
• Shift + F:
• This shortcut moves the cursor to the next occurrence of the word or phrase that was previously found using the Find function.

The correct answer is Application.

Key Points

• Application:
• This refers to the specific software program itself.
• For example, Microsoft Word is an application for word processing, Microsoft Excel is an application for spreadsheet creation, and Adobe Photoshop is an application for graphic manipulation.

Additional Information

• Structure:
• This refers to the underlying organization and design of the software.
• It encompasses how the different components of the application interact, such as the user interface, data storage, and processing logic.
• .A well-structured application is typically more efficient, reliable, and easier to maintain.
• Framework:
• This is a set of pre-built code libraries and tools that provide a foundation for developers to build applications more quickly and efficiently.
• Frameworks often include features like user interface components, data handling routines, and security measures.
• System:
• This refers to the entire software ecosystem, including the operating system, hardware, and other software components that the application interacts with.
• For example, a word processing application relies on the operating system to manage hardware resources, and it may interact with other applications like a printer driver.

The correct answer is Twitter.

Key Points

• Twitter:
• Founded: March 21, 2006
• Founders: Jack Dorsey, Noah Glass, Biz Stone, Evan Williams
• Focus: Short-form microblogging platform, known for real-time updates, news, and social commentary.

Additional Information

• Facebook:
• Founded: February 4, 2004
• Founder: Mark Zuckerberg
• Focus: Social networking platform for connecting with friends, family, and colleagues, sharing photos, videos, and updates.
• LinkedIn:
• Founded: December 28, 2002
• Founders: Reid Hoffman, Allen Blue, Konstantin Guericke, Jean-Luc Vaillant, Eric Ly
• Focus: Professional networking platform for building and maintaining professional relationships, finding jobs, and discovering career opportunities.
• Instagram:
• Founded: October 6, 2010
• Founders: Kevin Systrom, Mike Krieger
• Focus: Photo and video-sharing social media platform, popular for its visual content, filters, and stories.

The correct answer is To visually represent data.

Key Points

• In MS Excel 365, the main purpose of using a chart is to visually represent data in a way that is easier to understand and interpret than raw numbers.
• Charts transform numerical data into graphical formats like bar graphs, line graphs, pie charts, and more.

Additional Information

• This visual representation helps to:   
• Identify trends and patterns: Charts can quickly reveal trends, such as increases, decreases, or cyclical patterns within the data.
• This is crucial for making informed decisions based on observed trends.
• Compare data: Charts effectively compare different data points, sets, or categories. For example, a bar chart can easily show which product has the highest sales, or a line chart can illustrate how a particular metric has changed over time.
• Communicate data effectively: Charts are a powerful tool for communicating data to others. They make complex information more accessible and engaging, making it easier for audiences to grasp key insights.
• Gain deeper insights: By visualizing data, you can often uncover hidden relationships, anomalies, or outliers that might not be apparent from just looking at numbers. This can lead to valuable new insights and discoveries.