Computer Knowledge PYQs

The correct answer is IP address.

Key Points

• IP address
• An Internet Protocol address (IP address) is a numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication.
• An IP address serves two main functions:
• Host or network interface identification and location addressing.
• Media Access Control (MAC) Address
• MAC Address is also known as the Physical Address of a network device.
• MAC Addresses are unique 48-bits hardware numbers of a computer, which is embedded into a network card (known as Network Interface Card) during the time of manufacturing.
• In IEEE 802 standard, Data Link Layer is divided into two sublayers :
• Logical Link Control(LLC) Sublayer
• Media Access Control(MAC) Sublayer
• Broadcast addressing
• Broadcasting addressing is another addressing method available in IPv4.
• It allows you to manage data to all destinations on a network with a single transmission operation.
• The IP address 255.255.255.255 is mostly used for network broadcast.
• Moreover, limited directed-broadcast uses the all-ones host address with the network prefix.

The correct answer is It is a word processor

• Sometimes called Winword, MS Word, or Word, Microsoft Word is a word processor published by Microsoft. It is one of the office productivity applications included in the Microsoft Office suite. Originally developed by Charles Simonyi and Richard Brodie, it was first released in 1983.
• Microsoft Word is available for Microsoft Windows, Apple macOS, Android, and Apple iOS. It can also run on the Linux operating system using WINE.
• Microsoft Word allows you to create professional-quality documents, reports, letters, and résumés. Unlike a plain text editor, Microsoft Word has features including spell check, grammar check, text and font formatting, HTML support, image support, advanced page layout, and more.
• Below is an overview of a Microsoft Word 2010 document.

The correct answer is 4.

Key Points

"256/8/4/2" in MS-Excel:-

              Evaluation                  Result

Step 1 :   256/8   =  32              32/4/2

Step 2 :   32/4    = 8                  8/2

Step 3 :   8/2    = 4                    4

The result on the evaluation of "256/8/4/2" in MS-Excel is 4.

An MS Excel worksheet contains rows 1,048,576 rows and 16,384 columns to store the text and numbers and merged into a single workbook knows as a File. ​Workbooks are the Excel files that one can open and share, while Excel worksheets are individual spreadsheets within them. Function Key Shortcuts:

• F2: Edit Cells
• F4: Anchor Cells
• F7: Spell Check
• F11: Generates a bar graph from the values entered
• F12: Save As
• SHIFT + F2: Insert a Comment
• SHIFT + F8: Add to Selection
• SHIFT + F10: Right Click
• SHIFT+F11:  Insert a new worksheet
• CTRL +F2: Switch to Print Preview
• CTRL + F3: Name a Cell
• CTRL**+F9** Minimize the workbook window
• CTRL +N :Create a new workbook
• CTRL +W :Close a workbook
• Windows Flag + D: Minimize Programs
• ALT+N: Open the Insert tab
• ALT+H: Go to the Home tab

The correct answer is one.

Key Points

• Worksheet:-
• An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns.
• A worksheet begins with row number one and column A.
• Each cell can contain a number, text, or formula.
• A cell can also reference another cell in the same worksheet, the same workbook, or a different workbook.
• In Excel 2010, the maximum size of a worksheet is 1,048,576 rows by 16,384 columns.

Additional Information

• Workbook:-
• Each of the workbook's worksheets is in separate tabs in the bottom of the Excel window.
• A workbook must contain at least a visible worksheet.
• By default, a new Excel workbook will contain one worksheets.
• You can switch between worksheets by clicking on the worksheet's tab at the bottom of the Excel window.
• In Excel 2010 the number of worksheets in a workbook is limited only by your computer's available memory.

The correct answer is Blank Space.

Email Address:

• Generally, compelling valid email address characters consist of an email prefix and valid email domains, both in acceptable formats.
• The prefix appears to the left of the @ symbol, and the domain appears to the right of the @ symbol. Without this, email domains are not valid.
• For example, in the address, "support@nik.com", "support" is the email prefix, and "@nik.com" is the domain.
• Similarly, in the address "Nik.james555@gmail.com", Nik.james555" is the email prefix, and "@gmail.com" is the domain.

​

 

"Www.Nikjames.com" and "Www.Nikjames.yahoo.com" are an example of a URL.

"Nik james555@gmail.com" is an invalid e-mail id because there is a space between Nik and james.

Hence, Nik.james555@gmail.com is a valid email address.

In the above example we can add Dot(.), numeric digits(555) and capital letter(N) as email address are not case sensitive. So we can add all options except blank space.

The correct answer is Neither i nor ii

Key Points

• MS Word is a applcation software is a term that is used for software created for a specific purpose.
• It is generally a program or collection of programs used by end-users.
• It can be called an application or simply an app.
• MS Word is an example of word processing software.

The shortcut key for underlining a word in MS Word is

• Ctrl + A: Select all text.
• Ctrl + B : to bold selected text
• Ctrl+ I: to italicize the selected text
• Ctrl + U : underlining the selected text
• Ctrl + X: Cut selected item.
• Ctrl + V: Paste.
• Ctrl + End: Go to the end of the document.
• Ctrl + Y: Redo the last action performed.
• Ctrl + Z: Undo the last action.
• Alt + F: File menu options in the current program.
• Alt + E: Edit options in the current program.

 MS Word supports font size between 1 and 1638.

**Hence,**Neither i nor ii option is correct.

The correct answer is CTRL + A

MS Word is a application software is a term that is used for software created for a specific purpose.

It is generally a program or collection of programs used by end-users.

It can be called an application or simply an app.

MS Word is an example of word processing software.

The shortcut key for underlining a word in MS Word is

• Ctrl + A: Select all text.
• Ctrl + B : to bold selected text
• Ctrl + C : to copy the selected text
• Ctrl+ I: to italicize the selected text
• Ctrl + U : underlining the selected text
• Ctrl + X: Cut selected item.
• Ctrl + V: Paste.
• Ctrl + End: Go to the end of the document.
• Ctrl + Y: Redo the last action performed.
• Ctrl + Z: Undo the last action.
• Alt + F: File menu options in the current program.
• Alt + E: Edit options in the current program.

The correct answer is Top

The default alignment for the paragraph in MS-Word is Left.

• 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.

Additional Information

Font Formatting:

• Ctrl+D opens the Font dialogue box for character formatting to format font type, style, size, colour etc.
• Ctrl+Shift+F moves directly to the Font type field in this dialogue box.
• Ctrl+Shift+P moves directly to the Font size field in this dialogue box.
• The keyboard commands for font styles are also the same as in previous Office versions:
• Ctrl+B Bold style
• Ctrl+I Italic style
• Ctrl+U Underline
• Ctrl+1 Single line spacing
• Ctrl+2 Double line spacing
• Ctrl+5 1.5 line spacing

The correct answer is Hypertext Transfer Protocol Secure (HTTPS) 

 

Hypertext Transfer Protocol (HTTP)

• HTTP stands for Hypertext Transfer Protocol. Hypertext Transfer Protocol is an application protocol used for data communication. It is the base of data communication in the World Wide Web. It provides a standard for web browsers that facilitates users to exchange information over the internet.
• HTTP is used by most websites to access any file or page. HTTP is a request-response protocol in the client-server computing model. It is an application layer protocol designed within the framework of the Internet Protocol Suite.
• Hypertext - A text containing a link within it, is known as hypertext. If you click on a word on a webpage and it redirects you to a new page, it means you have clicked on a hypertext.​

Hypertext Transfer Protocol Secure (HTTPS) 

• It is the protocol where encrypted HTTP data is transferred over a secure connection. It ensures data security over the network - mainly public networks like Wi-Fi.
• By virtue, HTTPS encryption is done bi-directionally, which means that the data is encrypted at both the client and server sides.

Only the client can decode the information that comes from the server. So, HTTPS does the encryption of data between a client and a server, which protects against eavesdropping, forging of information, and tampering of data.

Important Points

• HTTPS is HTTP with encryption.
• The only difference between the two protocols is that HTTPS uses TLS (SSL) to encrypt normal HTTP requests and responses. As a result, HTTPS is far more secure than HTTP.
• A website that uses HTTP has http:// in its URL, while a website that uses HTTPS has https://.

The correct answer is the Title bar.

Key Points

• Microsoft Excel consists of basic components like an Active cell, title bar Column headings, a Formula bar, a Name box, a mouse pointer, Row headings, Sheet tabs, a Taskbar, Tab scrolling buttons, and Toolbars.
• The title bar displays both the name of the application and the name of the spreadsheet.​

Additional Information

• A toolbar is just a collection of icons that provides a shortcut to using a drop-down menu.
• A quick access toolbar shows the options that are frequently used.
• The user can add favorite options by adding new options to the quick access toolbar.
• The Menu Bar at the top of the screen gives access to different commands that are used for tasks such as opening and closing files, printing documents, formatting data, and other operations.

​

The correct answer is Select the cell and press the F5 function key on the keyboard to edit the content of the cell.

• Select the cell and press the F5 function key on the keyboard to edit the content of the cell as FALSE with reference to cell editing in MS-Excel.
• F5 key displays the "Go-To" dialogue box.
• The Go-To box will list down the valid "named range" available in the opened excel workbook.
• Along with this, you can enter the reference of the cell where you want to go in the "Reference" text box.

Key Points

• Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.
• It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).

The correct answer is the Table properties.

• Table properties can be used to change the width of the columns in a table in MS- Word.

Key Points

• The width of the columns can be adjusted by using the mouse.

• By clicking on the column dividing line and drag it one way or the other.

• Select the column whose width needs to be changed.

• Word displays two additional tabs on the ribbon: Table Design and Layout.

• Display the Layout tab of the ribbon.

• Click the Properties option in the Table group.

• Word displays the Table Properties dialogue box.

• The following Column tab is displayed:

• Using the Preferred Width control, set the column width as wanted.

The correct answer is a Carbon copy.

• The full form of 'CC', a field of E-mail header is a Carbon copy.

Key Points

• The meaning of Cc is that whose address appears after the Cc: header would receive a copy of the message and the Cc header would also appear inside the header of the received message.
• Cc is used for emailing individual or multiple contacts.
• In this header, the email addresses viewable by all.
• Bcc stands for blind carbon copy.
• Bcc is similar to that of Cc besides that the Email address of the recipients specified in the Bcc field does not appear in the received message header and the recipients in the To or Cc fields will not know that a copy sent to these address.
• It is also used for emailing individual or multiple contacts.
• The email addresses viewable only by the sender.
• BCC should be used when sending out marketing emails, newsletters, or other unsolicited emails.

The correct answer is Ctrl + click on a sentence to select it.

• Triple-click (Ctrl + click) on a sentence to select it is used to select a sentence in a paragraph in MS Word.

Mistake Points

• Double click can only select a single word but Ctrl+Click on a statement can select complete statement. Hence option 3 is correct and 4 is incorrect.

Key PointsShortcut in MS word for selection:

• To select the current word, double-click on it.
• To select the current paragraph, triple-click on the paragraph.
• To select a sentence and not just a line, hold down [Ctrl] and click once in any place within the sentence.
• To select a vertical block of text, click at the start of the block. Later, hold down the [Shift] key and click a second time at the opposite end of the block. This trick is used when only want to copy one column of a tabular list

Approach (to find the difference in the shortcut)

These can be easily understood if you do it practically on MS word as it has very minute differences which you need to see while performing and reading each point.

The correct answer is High cost.

• The high cost is NOT a feature of the internet.

Key Points

• Internet:
• Computers in an office are networked using LAN (Local Area Network).
• Computers in different locations are connected by WAN (Wide Area Network).
• Both these network systems are not for public use and have limited usage.
• The Internet is a network of thousands of networks.
• Millions of computer networks are connected to the Internet network and are available to the public.
• Internet was invented by the American Department of Defence in 1969.
• Internet today offers various features such as flexibility of communication, ease of accessibility, Ease of use and is also available at cheap and affordable rates (in terms of cyber cafe ,mobile packs ,wifi packs).

The correct answer is Text.

• The 'LEN' function in MS-Excel belongs to text.

Key Points

• LEN function in excel is taken from the length and is used to count the number of characters is there in a cell.
• It considers special characters, spaces and alphabets and counts all these values if there is a selected cell.
• LEN function only counts the character length for only one cell.
• Example to use LEN function:

​

   

Additional Information

• Financial functions in EXCEL are FV Function, IPMT, XIRR in Excel, PMT Function, IRR Excel Function, RATE Function, NPV Function, etc.
• Logical functions in EXCEL are AND Function, NOT, OR Excel Function, TRUE Function, IFERROR Excel Function, Excel XOR Function and Excel Lo
• Math functions in EXCEL are EVEN Excel Function, SUM Function, POWER Function, SUMIF and LOG Excel Function.

The correct answer is Page Layout.

• Page Setup options are usually available in Page Layout in MS- Word 2007.

Key Points

• The page setup is the parameters defined by the user that help determine how a printed page appears.
• These parameters can include everything from the size, margins, page orientation, and quality of the print.
• It's a tool that allows users to change and customize the size and layout of a single page or an entire document.

 

Additional Information

• Insert option is used to insert the picture, charts, filter, hyperlink etc.
• The Excel Home Tab is used to perform commands such as bold, underline, copy, and paste.
• It is also used to apply formats to cells in a worksheet.
• The review tab contains the editing feature, comments, track changes and workbook protection options.

The correct answer is Safari.

• Safari is not a search engine.

Key Points

• Safari is a browser for IOS. WebKit is the search engine used as a default search engine for Safari.
• IOS is used only in Apple phones.
• Search Engines:
• These are websites available on the Internet that provide information on any topic that you want.
• Search engines contain a programme that collects information from other websites.
• This information is then stored according to the category it belongs to, e.g., websites about music will be stored in a category named Fine Arts. Examples of popular search engines are Yahoo, Alta Vista and Google.

Additional Information

• Yahoo was founded by Jerry Yang, David Filo.
• Ask was founded by David Warthen, Garrett Gruener.
• Bing is a search engine operated under Microsoft.

The correct answer is Alignment.

• Alignment is NOT a character formatting option in Ms-Word. Microsoft Word provides for aligning text in paragraphs in four different ways – left alignment, right alignment, centre alignment and justified.

1. Ctrl + E Aligns the line or selected text to the center of the screen.
2. Ctrl + L - Aligns the line or selected text to the left of the screen.
3. Ctrl + R - Aligns the line or selected text to the right of the screen.
4. Ctrl + J - Aligns the selected text or line to justify the screen.

Key Points

• The alignment feature comes under paragraph formatting.
• It is used for aligning the paragraph in left, right, centre or justifies positions.
• Character formatting is defined as the one where changes apply to an individual or group of characters.
• The features involved in character formatting are:
• font, font style, size, font colour, underline, and effects like superscript and subscript.
• Font style: It is used to define the style of the characters both alphabets and numbers.
• Font-size: It is used to specify the size of the font.
• Font colour: It is used to specify the colour of the font.
• Underline: Underline is used to underline the important characters.