Computer Knowledge PYQs

The correct answer is SMTP.

Key Points

• SMTP stands for Simple Mail Transfer Protocol.
• The Simple Mail Transfer Protocol (SMTP) is an internet standard communication protocol for electronic mail transmission.
• Mail servers and other message transfer agents use SMTP to send and receive mail messages.
• The Internet Message Access Protocol (IMAP) is a mail protocol used for accessing email on a remote web server from a local client.
• IMAP and POP3 are the two most commonly used Internet mail protocols for retrieving emails.
• Both protocols are supported by all modern email clients and web servers.

Additional Information

• HTTP is the HyperText Transfer Protocol it is an application-layer protocol for transmitting hypermedia documents, such as HTML.
• Address Resolution Protocol (ARP) is a procedure for mapping a dynamic Internet Protocol address (IP address) to a permanent physical machine address in a local area network (LAN).
• The ICMP stands for Internet Control Message Protocol.
• It is a network layer protocol. It is used for error handling in the network layer, and it is primarily used on network devices such as routers.

The correct answer is Review, Proofing.

Key Points

• To run a spelling and grammar check:
• Go to the Review tab.
• Within the Proofing Group, click on the Spelling & Grammar command.
• The Spelling and Grammar dialog box will open.
• For each error in your document, Word will try to offer one or more suggestions.

Additional Information

• To spell-check your entire document, click Review > Proofing > Spelling & Grammar.
• If the program finds spelling mistakes, a dialog box or task pane appears with the first misspelled word found by the spelling checker.

The correct answer is Today().

Key Points

• The TODAY() function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
• You can also use F9 to force the worksheet to recalculate and update the value.
• If you need the current date and time, use the NOW() function.

Additional Information

• The DATE() Function in Excel is categorized under Excel Date/Time Functions.
• It is the main function used to calculate dates in Excel.
• TIME() function is a built-in function that allows you to create a time with individual hour, minute, and second components.

The correct answer is Ctrl + Alt + V.

Key Points

• It is one of the most useful variants in Microsoft Office is Ctrl-Alt-V, which is a “smart paste” command.
• This pops up a box that lets you choose how you want to paste in the contents of the clipboard.
• The options can include unformatted text, or text in RTF, HTML, or Unicode formats.

Additional Information

Important Shortcut keys used in MS Word:

• Cut the selected content to the Clipboard - Ctrl+X
• Copy the selected content to the Clipboard - Ctrl+C
• Paste the contents of the Clipboard -Ctrl+V
• Increase the font size by 1 point.- Ctrl+]
• Center the text - Ctrl+E
• Align the text to the left - Ctrl+L

The correct answer is World Wide Web.

Key Points

• The World Wide Web (WWW), commonly known as the Web, is an information system where documents and other web resources are identified by Uniform Resource Locators which may be interlinked by hyperlinks and are accessible over the Internet.
• The resources of the Web are transferred via the Hypertext Transfer Protocol (HTTP), may be accessed by users by a software application called a web browser, and are published by a software application called a web server.

Additional Information

• A web server is server software or a system of one or more computers dedicated to running this software, that can satisfy client HTTP requests on the public World Wide Web or also on private LANs and WANs.
• A Uniform Resource Locator (URL), colloquially termed a web address.

The correct answer is Transmission Control Protocol and Internet Protocol.

Key Points

• TCP/IP stands for Transmission Control Protocol and Internet Protocol.
• The Internet protocol suite is the conceptual model and set of communications protocols used in the Internet and similar computer networks.
• It is commonly known as TCP/IP because the foundational protocols in the suite are the Transmission Control Protocol (TCP) and the Internet Protocol (IP).

Additional Information

• Hypertext Transfer Protocol (HTTP) is an application-layer protocol for transmitting hypermedia documents, such as HTML.
• SMTP stands for Simple Mail Transfer Protocol.
• The File Transfer Protocol (FTP) is a standard communication protocol used for the transfer of computer files from a server to a client on a computer network.

The correct answer is Three.

Key Points

• When you open an Excel workbook, there are three worksheets by default.
• The default names on the worksheet tabs are Sheet1, Sheet2, and Sheet3.
• To organize your workbook and make it easier to navigate, you can rename and even color code the worksheet tabs.

Additional Information

Worksheet and workbook specifications and limits:

• Total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns
• Column width - 255 characters
• Page breaks - 1,026 horizontal and vertical
• Row height - 409 points

The correct answer is This shortcut switches the text between uppercase, lowercase, and title case.

​

Key Points 

• Shift +F3 shortcut switches the text between uppercase, lowercase, and title case.
• The Shift + F3 keyboard shortcut allows you to quickly change the text case of your text without having to use the button built into Microsoft Word.
• Select the text you'd like to change the case of or use Control + A on your keyboard to select all the text.

Additional Information

Important Shortcut keys used in MS Word:

• Increase the font size by 1 point.- Ctrl+]
• Center the text - Ctrl+E
• Align the text to the left - Ctrl+L
• Cut the selected content to the Clipboard - Ctrl+X
• Copy the selected content to the Clipboard - Ctrl+C
• Paste the contents of the Clipboard -Ctrl+V

The correct answer is Review, Compare.

Key Points

• To compare two versions of an MS Word 2007 document, one must go to the review tab and click on the compare option within the ‘Compare’ group.
• To compare documents in Word:
• Open the two documents to compare.
• Then select the “Compare” command from the drop-down menu to open the “Compare Documents” dialog box.
• Then click the “Compare” drop-down button in the “Compare” button group.
• Click the “Review” tab in the Ribbon.

Additional Information

• Microsoft Word or MS Word (often called Word) is a graphical word processing program that users can type with.
• It is made by the computer company Microsoft.
• Its purpose is to allow users to type and save documents.
• Similar to other word processors, it has helpful tools to make documents.

The correct answer is Ctrl + 5.

Key Points

• Ctrl + 5 is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel.
• Just select the cell where you want to apply the strikethrough format and press Control + 5.
• If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut.

Additional Information

Some important shortcuts used in MS Excel:

• Ctrl + N Create a new workbook.
• Ctrl + O Open an existing workbook.
• Ctrl + S Save the active workbook.
• F12 Save the active workbook under a new name, displays the Save as dialog box.
• Ctrl + W Close the active workbook.
• Ctrl + C Copy the contents of the selected cells to Clipboard.
• Ctrl + X Cut the contents of the selected cells to Clipboard.
• Ctrl + V Insert the contents of the Clipboard into the selected cell(s).

The correct answer is 1989.

Key Points

• Tim Berners-Lee, a British scientist, invented the World Wide Web (WWW) in 1989 while working at CERN.
• The Web was originally conceived and developed to meet the demand for automated information-sharing between scientists in universities and institutes around the world.

Additional Information

• The first web page address was http://info.cern.ch/hypertext/WWW/TheProject.html.
• ARPANET adopted TCP/IP on January 1, 1983.
• NCSA Mosaic ran on Windows computers was the first browser to surf the internet.

The correct answer is Internet.

Key Points

• The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite (TCP/IP) to link several billion devices worldwide.
• A computer network is mainly of four types:
• LAN(Local Area Network)
• PAN(Personal Area Network)
• MAN(Metropolitan Area Network)
• WAN(Wide Area Network)

Additional Information

• Tim Berners-Lee, a British scientist, invented the World Wide Web (WWW) in 1989 while working at CERN.
• There are five types of topology in computer networks:

1. Mesh Topology.
2. Star Topology.
3. Bus Topology.
4. Ring Topology.
5. Hybrid Topology.

The correct answer is Design.

Key Points

• In the Ribbon menu at the top of the program window, click the Design tab.
• In the Page Background section, click the Watermark option. In the drop-down window that appears.
• Find the watermark you want to add and click that watermark option.

Additional Information

• Microsoft Word or MS Word (often called Word) is a graphical word processing program that users can type with.
• It is made by the computer company Microsoft.
• Its purpose is to allow users to type and save documents.
• Similar to other word processors, it has helpful tools to make documents.

The correct answer is The name of a worksheet cannot be changed in MS Excel.

Key Points

• A workbook is made up of worksheets.
• Worksheets are labelled Sheet1, Sheet2 and Sheet3, and so on.
• The name of a worksheet can be changed in MS Excel.
• Each Microsoft Excel worksheet is made up of columns and rows.

Additional Information

Some important shortcuts used in MS Excel:

• Ctrl + N Create a new workbook.
• Ctrl + O Open an existing workbook.
• Ctrl + S Save the active workbook.
• F12 Save the active workbook under a new name, displays the Save as dialog box.
• Ctrl + W Close the active workbook.
• Ctrl + C Copy the contents of the selected cells to Clipboard.
• Ctrl + X Cut the contents of the selected cells to Clipboard.
• Ctrl + V Insert the contents of the Clipboard into the selected cell(s).

The correct answer is 31-08-2020.

Key Points

• The selected date format is 'xx-xx-xxxx' which means 'dd-mm-yyyy'.
• =DATE(2020.8.31) in this function day is 31, month is 8 and year is 2020.

Additional Information

• The DATE() Function in Excel is categorized under Excel Date/Time Functions.
• It is the main function used to calculate dates in Excel.
• The TODAY() function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
• TIME() function is a built-in function that allows you to create a time with individual hour, minute, and second components.

The correct answer is Text.

Key Points

• The Editing Group actually appears on the far right end of the Home Tab.
• The Editing Group has three choices, two of which are drop-down.
• The select option is used to select the required text on which we have to do editing.
• Replace option is used when some text or phrase is completely replaced with another one.
• Find option is used to search some text or phrase in our document.

Additional Information

• Ctrl + H is a shortcut key used for Replace option.
• Ctrl + A is used to select the whole document.

The correct answer is The row heading of the selected cell will not be highlighted.

Key Points

• The row heading of the selected cell can be highlighted.
• A border will appear around the selected cell.
• A cell will remain selected until another cell is clicked in the Worksheet.
• The column heading of the selected cell will be highlighted.

Additional Information

Some important shortcuts used in MS Excel:

• Ctrl + N Create a new workbook.
• Ctrl + O Open an existing workbook.
• Ctrl + S Save the active workbook.
• F12 Save the active workbook under a new name, displays the Save as dialog box.
• Ctrl + W Close the active workbook.
• Ctrl + C Copy the contents of the selected cells to Clipboard.
• Ctrl + X Cut the contents of the selected cells to Clipboard.
• Ctrl + V Insert the contents of the Clipboard into the selected cell(s).

The correct answer is Satellite.

Key Points

• Satellite Internet access is Internet access provided through communication satellites.
• Modern consumer-grade satellite Internet service is typically provided to individual users through geostationary satellites that can offer relatively high data speeds.
• Integrated Services Digital Network is a set of communication standards for simultaneous digital transmission of voice, video, data, and other network services over the digitalized circuits of the public switched telephone network.
• A digital subscriber line(DSL) is a family of technologies that are used to transmit digital data over telephone lines.
• Dial-up Internet access is a form of Internet access that uses the facilities of the public switched telephone network to establish a connection to an Internet service provider by dialing a telephone number on a conventional telephone line.

Additional Information

• The first web page address was http://info.cern.ch/hypertext/WWW/TheProject.html.
• ARPANET adopted TCP/IP on January 1, 1983.
• NCSA Mosaic ran on Windows computers was the first browser to surf the internet.

The correct answer is Print Layout.

Key Points

• By default, an MS Word 2007 document opens in the print layout view.
• When you open any documents in Microsoft Word 2010, it is displayed in the Print Layout view, which is the default view.
• If you find that you are having to change the view every time you open a document, you can save time by modifying the default open view in Word.

Additional Information

• In the Print Layout view, you get to see the entire page, just as it prints.
• Graphical images, columns, and all sorts of other fancy items show up on the page fully visible.

The correct answer is F12.

Key Points

• Save the current document: Press Ctrl + S to save the current document immediately.
• Open the Save As window: Press F12 to open the Save As dialog box to save the document with a specific filename or in a new folder.
• F8 - Toggles whether to extend a selection with the arrow keys.
• F9 - Updates all the field codes in the current selection.
• F10 - Toggles the display of the ribbon shortcut keys otherwise known as Access Keys.

Additional Information

Important Shortcut keys used in MS Word:

• Cut the selected content to the Clipboard - Ctrl+X.
• Copy the selected content to the Clipboard - Ctrl+C.
• Paste the contents of the Clipboard -Ctrl+V.
• Increase the font size by 1 point.- Ctrl+].
• Center the text - Ctrl+E.
• Align the text to the left - Ctrl+L .