Computer Knowledge PYQs

The correct answer is Ctrl + X.

Key Points

• Ctrl + X is the keyboard shortcut for cutting text in MS Word, as well as in most other text-editing applications.
• When you use Ctrl + X, the selected text is removed from its original location and stored in the clipboard.
• You can then use Ctrl + V to paste the text from the clipboard to a new location.
• This feature is useful for moving text around within a document without having to rewrite it.

Additional Information

• Ctrl + Z
• This shortcut is used for undoing the last action performed in MS Word.
• It is helpful when you need to revert changes that were made by mistake.
• Ctrl + V
• This shortcut is used to paste text or other content from the clipboard to the current location in the document.
• It works in conjunction with the cut (Ctrl + X) and copy (Ctrl + C) commands.
• Ctrl + C
• This shortcut is used to copy the selected text or content to the clipboard without removing it from its original location.
• It is useful for duplicating text or content in different parts of a document.

The correct answer is It is convenient and fast communication with individuals or groups globally..

Key Points

• Convenience: Electronic mail is extremely convenient as it allows users to send and receive messages at any time and from anywhere in the world.
• Speed: Emails are delivered almost instantly, making communication swift and efficient. This is particularly beneficial for business communications and urgent matters.
• Global Reach: Emails can be sent to recipients across the globe without any geographical constraints, facilitating international communication and collaboration.
• Group Communication: Emails allow for the easy dissemination of information to multiple recipients at once, making it ideal for group communications, announcements, and team collaborations.

Additional Information

• Information Overload
• While email is convenient, it can lead to an overwhelming number of messages, which may result in information overload and difficulty in managing important communications.
• Spam and Phishing Threats
• Email systems are vulnerable to spam and phishing attacks, where malicious actors attempt to deceive users into providing sensitive information or clicking on harmful links.
• Decreased Face-to-Face Communication
• The reliance on email for communication can sometimes lead to a reduction in face-to-face interactions, potentially diminishing personal connections and rapport among individuals.

The correct answer is It reverses the last action performed..

Key Points

• The 'Undo' command in Microsoft Excel is used to reverse the last action performed by the user.
• This feature is extremely helpful in correcting mistakes without the need to manually change the data back to its previous state.
• The 'Undo' command can be accessed through the keyboard shortcut Ctrl+Z on Windows or Command+Z on Mac.
• Multiple actions can be undone in sequence, depending on the number of actions that Excel is set to remember.

Additional Information

• Save Command:
• The 'Save' command is used to store the current state of the workbook to a file.
• It can be accessed using the keyboard shortcut Ctrl+S on Windows or Command+S on Mac.
• This command ensures that all the changes made to the workbook are stored.
• Insert Worksheet Command:
• The 'Insert Worksheet' command is used to add a new worksheet to the current workbook.
• This command can be accessed by clicking the '+' icon near the sheet tabs.
• It helps in organizing data into separate sheets within the same workbook.
• Copy Command:
• The 'Copy' command is used to duplicate the selected cells' content to the clipboard.
• It can be accessed using the keyboard shortcut Ctrl+C on Windows or Command+C on Mac.
• The copied data can then be pasted to a different location using the 'Paste' command.
• Redo Command:
• The 'Redo' command is used to reverse the action of the 'Undo' command.
• It can be accessed using the keyboard shortcut Ctrl+Y on Windows or Command+Shift+Z on Mac.
• This command is useful if you have undone an action and then decide you want to redo it.

The correct answer is Cut and Paste.

Key Points

• Cut and Paste is a feature used in word processing software like Microsoft Word 365 to move text from one location to another.
• When you use the Cut command, the selected text is removed from its original location and copied to the clipboard.
• Using the Paste command, the text from the clipboard is inserted into the new location where the cursor is placed.
• This method is efficient for reorganizing documents without having to retype the text.

Additional Information

• Clipboard
• The clipboard is a temporary storage area provided by the operating system for data that the user wants to copy from one place to another.
• When you cut or copy text, it is stored in the clipboard until it is replaced by new data or the system is shut down.
• The clipboard can hold various types of data including text, images, and files.
• Cut Command
• In Microsoft Word 365, the Cut command can be accessed by right-clicking the selected text and choosing "Cut" from the context menu or by using the shortcut Ctrl + X.
• This command removes the text from its current position and places it on the clipboard.
• Paste Command
• The Paste command is used to insert the text from the clipboard into the new location.
• In Microsoft Word 365, you can paste the text by right-clicking where you want to insert the text and selecting "Paste" or by using the shortcut Ctrl + V.
• Copy and Paste
• While similar to Cut and Paste, the Copy command duplicates the selected text and places the copy on the clipboard without removing it from its original location.
• The Paste command is then used to insert the copied text into the desired location.
• The shortcut for Copy is Ctrl + C in Microsoft Word 365.

The correct answer is Telepathy.

Key Points

• Telepathy refers to the supposed communication of thoughts or ideas by means other than the known senses.
• It is a concept found in science fiction and is not supported by scientific evidence.
• The other options (Chat, Video conferencing, and Email) are all established forms of communication on the internet.
• Telepathy has never been proven and remains a topic of pseudoscience and speculative fiction.

Additional Information

• Chat:
• Chat allows real-time text-based communication between users over the internet.
• Common platforms include messaging apps like WhatsApp, Facebook Messenger, and Slack.
• Video Conferencing:
• Video conferencing enables users to communicate face-to-face over the internet through video and audio.
• Popular tools include Zoom, Microsoft Teams, and Google Meet.
• It is widely used for business meetings, online education, and virtual gatherings.
• Email:
• Email is a method of exchanging digital messages over the internet.
• It is one of the earliest forms of internet communication and remains widely used today.
• Examples of email services include Gmail, Outlook, and Yahoo Mail.
• Emails can include text, attachments, and hyperlinks, making them versatile for personal and professional communication.

The correct answer is Click the 'Sort Z to A' button.

Key Points

• The 'Sort Z to A' button in MS Excel is used to arrange data in descending order based on the selected column(s).
• This option is typically found under the "Data" tab in the "Sort & Filter" group on the Excel ribbon.
• Sorting data in descending order means arranging it from highest to lowest, which is useful for numerical data, dates, or text data that needs to be sorted in reverse alphabetical order.
• Using the 'Sort Z to A' button ensures that the entire dataset is sorted based on the values in the selected column(s), maintaining the integrity of the data relationships.

Additional Information

• Sorting in Excel:
• Sorting is a feature in Excel that allows users to arrange data in a specific order, either ascending or descending.
• Ascending order arranges data from smallest to largest, or A to Z for text.
• Descending order arranges data from largest to smallest, or Z to A for text.
• Filter Button:
• The filter button in Excel is used to display a subset of data that meets certain criteria. It does not sort the data but allows you to view only the rows that match the filter conditions.
• Filters are useful for analyzing specific portions of data without rearranging the entire dataset.
• Find & Select:
• The 'Find & Select' option in Excel is used to locate specific data within a worksheet. It includes features like 'Find', 'Replace', 'Go To', and 'Select Objects'.
• This tool does not sort data but helps in navigating large datasets efficiently.

The correct answer is Document Template.

Key Points

• A Document Template in MS-Word 365 allows users to create new documents quickly without starting from scratch.
• These templates come with predefined layouts and formatting, which helps in maintaining consistency across documents.
• Templates can include elements such as styles, headers, footers, and text placeholders.
• Using templates is particularly useful for creating standard documents like resumes, business letters, and reports.

Additional Information

• Print Layout View:
• This view in MS-Word shows how the document will look when it is printed.
• It is useful for checking the layout and appearance of the document before printing.
• AutoSave:
• This feature automatically saves the document at regular intervals.
• It helps prevent data loss in case of unexpected shutdowns or crashes.
• Spelling and Grammar Check:
• This feature checks the document for spelling and grammatical errors.
• It provides suggestions for corrections and helps improve the overall quality of the document.

The correct answer is To copy or move text by dragging it to a new location.

Key Points

• The 'Drag-and-Drop' method allows users to easily copy or move text within a document.
• This feature enhances the efficiency of editing and formatting documents by simplifying the process of repositioning text.
• Drag-and-Drop can be used to rearrange paragraphs, sentences, or even individual words within a document.
• This method helps maintain the flow and coherence of the document by enabling quick adjustments without needing to use cut, copy, and paste commands.

Additional Information

• Formatting Text:
• Formatting text involves changing the font, size, color, and style (bold, italic, underline) to enhance the appearance and readability of the document.
• Microsoft Word provides a variety of formatting tools in the toolbar for quick access.
• Printing Text:
• Printing text refers to the process of sending a document to a printer to produce a hard copy.
• Users can access the print function from the 'File' menu or by using the shortcut Ctrl+P.
• Selecting Text:
• Selecting text is the action of highlighting a portion of text to apply formatting, copy, cut, or delete.
• This can be done by clicking and dragging the mouse over the desired text or using keyboard shortcuts like Shift+Arrow keys.

The correct answer is Home Tab.

Key Points

• The Home Tab is one of the primary tabs in the MS-Word 2010 ribbon interface.
• It contains the most frequently used commands in Word, including font formatting, paragraph settings, and styles.
• The Bullets and Numbering icons are located in the Paragraph group within the Home Tab.
• These icons allow users to create bulleted and numbered lists quickly and easily.

Additional Information

• View Tab
• The View Tab allows users to change the document views, such as Print Layout, Full-Screen Reading, Web Layout, Outline, and Draft.
• It also includes options for displaying rulers, gridlines, navigation pane, and zoom settings.
• Design Tab
• The Design Tab allows users to format the overall look and feel of the document.
• It includes options for themes, colors, fonts, and paragraph spacing.
• Insert Tab
• The Insert Tab is used to insert various elements into a document, such as tables, pictures, shapes, hyperlinks, headers, footers, and text boxes.
• It provides a wide range of tools to enhance the content of the document.

The correct answer is Ctrl + O.

Key Points

• Ctrl + O is a commonly used shortcut in many software applications, including MS Excel, for opening existing files.
• Using the Ctrl + O shortcut in MS Excel 365 will bring up the Open dialog box, allowing you to navigate to and select the file you wish to open.
• This shortcut improves productivity by reducing the time taken to access files, as opposed to navigating through menus.
• It is an integral part of the standard keyboard shortcuts for file management in Windows operating systems.

Additional Information

• MS Excel 365
• MS Excel 365 is a part of the Microsoft Office 365 suite, which is a subscription-based service offering the latest versions of Microsoft Office applications.
• Excel 365 includes advanced features such as real-time collaboration, enhanced data analysis tools, and integration with other Office 365 services.
• Keyboard Shortcuts
• Keyboard shortcuts are combinations of keys that provide quick access to a particular function within a software application.
• They are designed to improve efficiency by allowing users to execute commands without navigating through menus.
• Some common shortcuts in MS Excel include Ctrl + S (Save), Ctrl + C (Copy), Ctrl + V (Paste), and Ctrl + Z (Undo).
• File Management
• File management refers to the process of organizing and managing files and folders on a computer.
• Effective file management involves creating a logical structure for storing and retrieving files, as well as utilizing tools like search functions and shortcuts to access files quickly.
• MS Excel 365 provides several file management features, including the ability to open, save, and share files easily.

The Correct Answer is "0.5".

Key Points

• The font in MS word is selected through the Home tab on the ribbon.
• The smallest and largest font size in Word 2007, available in the front toolbox.
• The list contains font size in points 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48 and 72.
• If you need, you can have text with font sizes not listed in this tool by using the Font dialog box.
• It lets you set the font size as smaller 8 as well as larger than 72 points.

Important Points

• A point is a typographical term for a unit of measure.
• It is roughly equivalent to 1/72 of an inch.
• Word uses point sizes to specify the height of all the fonts it uses.
• when we use a 12-point type, we are using one that occupies a character box approximately 12/72 (or 1/6) of an inch high.
• Likewise, the 72-point type uses a character box that is about one inch tall.
• Example :
• If 1 point equal to 1/72.
• then 36 point equals 36/72 i.e 0.5.

The Correct Answer is "Web administration".

Important Points

• An Internet service provider (ISP), is a company that provides Internet connections and services to individuals and organizations.
• In addition to providing access to the Internet, ISPs may also provide software packages and a personal Web site or home page.
• ISPs can host Web sites for businesses and can also build the Web sites themselves.
• ISPs are all connected to each other through network access points and public network facilities on the Internet backbone.

Some of these services include:

• Email services
• Web hosting services
• Domain Registration
• Browser and software package.

Key Points

• An internet service provider (ISP) is a company that provides web access to both businesses and consumers.
• ISPs may also provide other services such as email services, domain registration, web hosting, and browser services.
• An ISP is considered to be an information service provider, storage service provider, internet network service provider (INSP), or a mix of all of them.
• Internet use has evolved from only those with university or government accounts having access to nearly everyone having access, whether it's paid or free.
• Access has gone from dial-up connections to high-speed broadband technology.

The Correct Answer is "COMBIN".

Important Points

• The Excel TEXT Function is used to convert numbers to text within a spreadsheet.
• Essentially, the function will convert a numeric value into a text string.
• TEXT is available in all versions of Excel.
• 'MID', 'LEFT', and 'RIGHT' are part of the Text function.

Formula :

=Text(Value, format_text)

Where:

• Value is the numerical value that we need to convert to text.
• Format_text is the format we want to apply.

Key PointsWe use the TEXT function in the following circumstances:

• When we want to display dates in a specified format.
• When we wish to display numbers in a specified format or in a more legible way.
• When we wish to combine numbers with text or characters.

Additional InformationExamples :

Basic example – Excel Text Function

With the following data, I need to convert the data to “d mmmm, yyyy” format. When we insert the text function, the result would look as follows:

                                                         

Using Excel TEXT with other functions :

• We use the old price and the discount given in cells A5 and B5.
• The quantity is given in C5. We wish to show some text along with the calculations.

We wish to display the information as follows:

• The final price is $xxx
• Where xxx would be the price in $ terms.
• For this, we can use the formula:
• =”The final price is “&TEXT(A5B5C5, “$###,###.00”)$

The Correct Answer is "3".

Important Points

• When we open an Excel workbook, there are three sheets by default, and the default name on the tabs are Sheet1, Sheet2, and Sheet3.
• These are not very informative names.
• Excel 2007 allows us to create a meaningful name for each worksheet in a workbook so we can quickly locate information.

 

                                                                                    

Additional Information

To name a worksheet:

• Right-click the sheet tab to select it.
• Choose Rename from the menu that appears.
• The text is highlighted by a black box.

 

                                                                                    

To insert a new worksheet:

• Left-click the Insert Worksheet icon.

• A new sheet will appear.

• It will be named Sheet4, Sheet5, or whatever the next sequential sheet number may be in the workbook.

• OR Press the Shift and the F11 keys on your keyboard.

The Correct Answer is "Align across".

Important Points

• Alignment refers to where and how the text lines up.
• Default settings in Microsoft Word will left-align your text, but there are many other ways to format a document’s alignment.

Steps :

• Select the cells, columns, or rows, with text that you want to align (or select your entire table).
• Go to the (Table Tools) Layout tab.
• Click an Align button (you may have to click the Alignment button first, depending on the size of your screen).
• The following figure shows where the Align buttons are on the (Table Tools) Layout tab and how these options align text in a table.

​ 

 

Additional Information

• Vertical alignment
• ​Top Align 

 - aligns the contents to the top of the cell.

• Middle Align 

 - centers the contents between the top and bottom of the cell.

• Bottom Align 

 - aligns the contents to the bottom of the cell (the default one).

• Horizontal alignment
• Align Left 

 - aligns the contents along the left edge of the cell.

• Center 

 - puts the contents in the middle of the cell.

• Align Right 

 - aligns the contents along the right edge of the cell.

• We can arrange the cell contents in different ways, for example:

The Correct Answer is "Internet".

Important Points

• Menus, Home, Insert, Page Layout, References, Mailings, Review, View, options are available see figure:

The Correct Answer is "______@domain.com".

Important Points

A valid email address has four parts:

• Recipient name
• @ symbol
• Domain name
• Top-level domain

Recipient name :

The recipient name represents an email mailbox that belongs to:

• A specific person
• A mailing list
• A department
• A role within a company (such as sales or customer service)

The recipient name may be a maximum of 64 characters long and consist of:

• Uppercase and lowercase letters in English (A-Z, a-z)
• Digits from 0 to 9
• Special characters such as ! # $ % & ' * + - / = ? ^ _ ` { |

 

Domain name :

The domain name is a string of letters and digits that defines a space on the Internet owned and controlled by a specific mailbox provider or organization.

Domain names may be a maximum of 253 characters and consist of:

• Uppercase and lowercase letters in English (A-Z, a-z)
• Digits from 0 to 9
• A hyphen (-)
• A period (.) (used to identify a sub-domain; for example, email.domainsample)

 

Examples :

Examples of valid email addresses include:

• johndoe@domainsample.com
• john.doe@domainsample.net
• john.doe43@domainsample.co.uk

 

Additional Information

• An email address is a unique identifier for an email account.
• It is used to both send and receive email messages over the Internet.
• Similar to physical mail, an email message requires an address for both the sender and recipient in order to be sent successfully$.

The Correct Answer is "(i) - b, (ii) - d, (iii) - a, (iv) - c".

Important Points

The Correct Answer is "Borders".

Important Points

• We can format tables with borders and shading any way we want, calling attention to specific cells or headings.
• By default, Word inserts tables with a .5-point border around each cell.
• We can adjust or remove these borders, or specify which cells are bordered and which ones are not.
• To work with the borders of a table, select the table by clicking the Select Table icon at the upper-left corner of the table, or by clicking inside the table and typing Alt+NumPad5 on your keyboard.
• We can also select specific cells for which you want to change bordering.
• Then choose Format, Borders and Shading, and choose the Borders tab.

The Correct Answer is "(i) - (b), (ii) - (c), (iii) - (a)".

Important Points

Internet Explorer :

• Internet Explorer is a series of graphical web browsers developed by Microsoft and are included in the Microsoft Windows line of operating systems, starting in 1995.
• It was first released as part of the add-on package Plus for Windows 95 that year.

 

Safari :

• Safari is a graphical web browser developed by Apple, based on the WebKit engine.
• First released on the desktop in 2003 with Mac OS X Panther, a mobile version has been bundled with iOS devices since the iPhone's introduction in 2007.
• Safari is the default browser on Apple devices.

 

SeaMonkey :

• Developed by Mozilla Foundation.
• SeaMonkey is a free and open-source Internet suite.
• It is the continuation of the former Mozilla Application Suite, based on the same source code, which itself grew out of Netscape Communicator and formed the base of Netscape 6 and Netscape 7.