Computer Knowledge PYQs

The correct answer is Format Painter.

• To apply the font colour and size of text of multiple pieces of text, Use the Format Painter on the Home tab to quickly apply the same formatting, such as font style, size, border, and colour of multiple pieces of text or graphics.

Key Points

1. Click on the text with the formatting you want to apply.
2. Press Ctrl+Shift+C to copy the formatting
3. Click in the text to which you want to apply the formatting.
4. Press Crtl+Shift+V.

The correct answer is At the rate (@).

• At the rate (@) is a compulsory part of email ID.
• For delivery of email, it must have a valid address that follows guidelines of syntax.

Key Points

• A valid email address has four parts:
• Recipient name (maximum of 64 characters)
• @ symbol
• The domain name (maybe a maximum of 253 characters)
• Top-level domain
• Email Username- Identifies a specific person or address in a domain.
• Email Domain Name- Certain number of top-level domains (.com, .org, .info, .de, etc.)

Note: The Dot(.) can also be the answer, hence Dot(.) or At the rate (@) can be the answer, as both are the mandatory part of the email id. But as per the given answer key, the correct answer is option 4 At the rate (@), hence it is chosen as an answer.

The correct answer is MS- Excel.

• A word processor is a software package with the help of which we can create, modify, print, and save a document faster than we can create by hand.
• Many documents can be merged together.

Key Points

• MS Excel - It is a spreadsheet and not a word processing software in which we have to maintain data in the form of rows and columns.
• MS Word- It works to open, create, edit, format, share and print the document, etc.
• WordPad – It is available in every version of Windows. Various types of formatting can be done in a document.
• Notepad- There is a simple but useful Text Editor Program that is included in every version of Microsoft Windows which helps notepad users to open, read and create plain text files.

The correct answer is 2.

• MOD function gives the remainder when a number is divided by a divisor.
• So when 11 is divided by 3 the Remainder is 2.
• Hence the correct answer is 2.

Key Points

• In mathematics, this operation is known as the modulo operation or modulus, Here it is known as MOD.
• The symbol is %.For example, MOD (10, 3) = 1.
• The result of MOD carries the same sign as it is categorized in maths.
• It can be used in an Excel sheet.
• As a worksheet function, the MOD function can also be entered as part of the formula in a cell of a worksheet.
• It is the absolute value (or modulus) |x| of a real number x namely, |x| = x for a positive x, |x| = − x for a negative x, and |0|.

The correct answer is website.

• Collections of many web pages are called websites.

Key Points

• It can also be said that a website or site is a location where a lot of web pages are kept.
• It is a place connected to the Internet where information about an organization is available.
• The World Wide Web (www) which is a part of the Internet consists of websites.
• A website is a book printed on the Internet, through which information can be given about something or some goods or services can be sold.

The correct answer is bottom - right.

• Zoom command is available at the bottom right corner.

Key Points

• Commands available in Zoom are used to view the sheet at different zoom levels.
• We can view the workbooks according to their size.
• One can also view selected cells through Zoom Selection.
• In general, all contents are being displayed on the screen at 100%.
• It can be changed from 10 % to 400% through zoom.
• Zoom can change the display size on-screen without affecting the font size as well as printed output.

The correct answer is Uniform Resource Locator.

• URL represents the name or address of a website from which it is known, identified, and used on the Internet.

Key Points

• It is also called Uniform Resource Locator.
• URL can be divided into three parts: Protocol Designation, Host Name or Address, and File or Resource Location.
• The first part Protocol Identifier tells which protocol is being used.
• The second part is Domain Name that tells which server is used to fetch data.
• The third part is the URL which states the path and name of the document.

The correct answer is Only (i).

(i) In MS-Word - Different letters of a word can be managed with different font colors with the help of the font color button. 

So, Statement

(i) is false.

(ii) In MS-Word - The Show/Hide command button can be used to display paragraph marks in a document. 

So, Statement

(ii) is true.

Key Points

• Show/Hide command button shows/hides characters like paragraph markers, spaces, or tab marks. Select the text you want to hide or the hidden text.
• Click the Home tab, and then click the Font Dialog Box Launcher.
• Click the Font tab.
• Select or clear the Hidden check box then click OK.

The correct answer is Double-click on the cell.

• The following steps are to be carried out to edit the content of the cell:

Key Points

1. Double-click the cell where the data is to be edited. Excel displays a cursor on the selected cell.
2. Edit data by using the Backspace key or Delete key, or by typing new data.
3. If you click a cell, Excel displays the contents of that cell in the Formula bar.

The correct answer is Ctrl + N.

Key Points

• Alt + N – Open the Insert tab to insert tables, pictures, and shapes, headers, or text boxes.
• Ctrl + O- Open an existing Word document
• Ctrl + N - To create a new document, window, workbook, or other types of file
• Ctrl + W- Close the active window.

The correct answer is 409 points.

Key Points

• Rows can have a maximum height of 409 points.
• This number represents how many one-seventy seconds of an inch the row can hold.
• The default size of an Excel row is 15, which correlates to 20 pixels or about one-fifth of an inch.

Important Points

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 File Explorer.

Key Points

• Internet Explorer is the browser to surf the internet.
• Similarly, Safari and Mozilla are also the browsers to surf the internet.
• File Explorer is the application through which we can access the files which are already stored in our hard disk or memory.

Additional Information 

• Internet Explorer is the browser of Microsoft company.
• Safari is the browser of Apple company.
• Mozilla is the browser of Mozilla Corporation.

The correct answer is #####.

Key Points

• If Microsoft Excel displays ##### in a cell after you apply number formatting to it, the cell probably isn't wide enough to display the data.
• To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error.
• This automatically resizes the column to fit the number.

Additional Information

• If your spreadsheet displays asterisks or pounds signs in a cell instead of data, this is usually because the column is not wide enough to display the value you've entered.
• Lotus 1-2-3 displays asterisks ( *** ) when a column is too narrow.
• Excel displays pound signs ( ### ).

The correct answer is F7.

Key Points

• Open the document you want to check for spelling or grammar mistakes, and then press F7.
• You can also use the ribbon to start the check.
• Press Alt+R to open the Review tab, and then press C, 1 to select the Check Document option.

Additional Information

• F2 is the shortcut key to move text in MS word.
• F1 is the shortcut key to display the Word Help window.
• F9 is the shortcut key to update all the field codes in the current selection

The correct answer is 30.

Key Points

• The 'SUMSQ' is the formula to sum the squares of the given numbers.
• Here, sum of squares of (1, 2, 3, 4) is 1+4+9+16 = 30

Additional Information

• CONCATENATE is one of the easiest to learn but most powerful formulas when conducting data analysis.
• COUNTA identifies whether a cell is empty or not.
• DAYS is exactly what it implies. This function determines the number of calendar days between two dates.
• SUMIFS is one of the “must-know” formulas for a data analyst.

The correct answer is Ctrl + W.

Key Points

• To quickly close the current application, press Alt+F4.
• This works on the desktop and even in new Windows 8-style applications.
• To quickly close the current browser tab or document, press Ctrl+W.
• This will often close the current window if there are no other tabs open.

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 1 - A, 2 - C, 3 - D, 4 - B.

Key Points

• .gov: This domain is derived from the word "government" and is used by governmental organizations. It is restricted for governmental use, which means organizations must meet specific criteria to use this domain extension. It is often used by government agencies, departments, programs, cities, counties, towns, and native sovereign nations. The .gov domain lends a level of authority and legitimacy to websites, as it verifies that the site is indeed run by an official government organization.
• .org: This domain extension stands for "organization," and it is typically used by not-for-profit organizations. However, it is not restricted and can be registered by anyone. Originally, it was created for charities, non-profit organizations, trade groups, and community groups. Nowadays, there are many for-profit businesses using .org domains, especially if their desired .com domains are taken.
• .edu: This top-level domain is derived from the word "education" and is primarily used by institutions of higher learning like universities, colleges, and research institutes. In the United States, the use of this domain is limited to post-secondary institutions that are institutionally accredited, i.e., the accreditation comes directly from regional or national accrediting agencies recognized by the U.S. Department of Education.
• .net: This domain extension originates from the word "network." It was designed originally for organizations directly involved in the infrastructure of the Internet, such as Internet Service Providers or other types of networking companies. However, restrictions have been removed, and now anyone can register a .net domain name. Despite this, some companies involved in networking still use this domain extension, but its use has branched out widely among various types of entities.

The correct answer is Review.

Key Points

• The option of Spell Check can be selected from the review tab in MS Excel 2007.
• The easiest way to apply a Spelling check is to press the keyboard of F7.
• Press the F7 keyboard, then the Spelling and Grammar dialog box pops us to check your text.

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

Key Points

• In MS Word, Ctrl + R is used to align the text to the right of the screen.
• Ctrl + L - Align selected paragraph to the left.
• Ctrl + E - Align selected text or line to the centre.

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 Page Layout, Page Background.

Key Points  Watermark 

• It is an image or text that appears behind the main text of the document.
• It is usually a lighter shade than that of the text so the document can be read easily.
• It is used to show the purpose of the document.​
• Page Layout tab → Page Background group → Watermark
• It is a faded image or text, that sits across the contents of a document.
• Watermarks can be used to indicate what stage the document is in, draft, confidential, final copy, etc.

Additional Information Insert a watermark:

• On the Design tab, select Watermark.
• Choose a pre-configured watermark, like DRAFT, CONFIDENTIAL, or DO NOT COPY.
• For placing a logo or image, Select Watermark > Custom Watermark > Picture watermark > Select Picture.
• On the same menu, you can create a custom text watermark.