Computer Knowledge PYQs

The correct answer is CTRL + H.

Key Points

• CTRL + H shortcut opens the FIND and REPLACE (or REPLACE) dialogue box in MS Word

Additional Information

Source:- https://support.microsoft.com/en-us/topic/keyboard-shortcuts-in-word-95ef89dd-7142-4b50-afb2-f762f663ceb2

The correct answer is the cursor (selection box) will move to the upper cell.

Key Points

• When you enter a value in an MS Excel cell and press SHIFT + ENTER keys the cursor (selection box) will move to the upper cell.

Additional Information

• When you enter a value in an Excel cell and press the ENTER key the cursor (selection box) will move to the lower cell.
• The cursor (selection box) will move to the upper cell when we press the up arrow.
• The cursor (selection box) will move to the lower cell when we press the down arrow or Enter.
• The cursor (selection box) will move to the right cell when we press the right arrow.
• The cursor (selection box) will move to the left cell when we press the left arrow.

The correct answer is Only ii.

Key Points

• In MS Word, a table can have one cell.
• In MS Word, the font size of a text can be as low as 1.
• Hence, **statement

(ii) is False**

Additional Information

• The minimum number of rows a table an MS-Word document can have is 1 row
• The minimum number of columns a table an MS-Word document can have is 1 column.
• The smallest font offered by MS Word in the home tab is 8 but it can be reduced to 1 by typing 1 in the font box.

The correct answer is the Functions library.

Key Points

• All the Excel functions are stored in the functions library under the Formulas tab.

Additional Information

• A function is a predefined formula that performs calculations using specific values in a particular order.
• AutoSum is a function that automatically enters a formula (that uses the SUM function) to sum the numbers.
• The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.

The correct answer is Broadband.

Key Points

• The broadband provides high-speed internet access.

Additional Information

• Broadband is the transmission of wide bandwidth data over a high-speed internet connection.
• A dial-up connection uses a standard phone line and analog modem to access the Internet. It is very slow.
• The Transmission Control Protocol (TCP) is a communications standard that allows programs and devices to exchange messages over a network.
• An Internet service provider (ISP) is a company that provides access to the Internet and other related services.

The correct answer is 1.

Key Points

• The result of the MS Excel formula =SUM(8/4/2, 1-2/2) is 1.

Additional Information

• 8/4/2 will be equal to 1 and 1-2/2 will be equal to 0.
• The sum function will add both 1 and 0 giving the result 1.
• A function is a predefined formula that performs calculations using specific values in a particular order.
• How to Write Formulas in Excel
• All Excel formulas start with an equal (=) sign.
• The answer to the formula is displayed in the cell into which the formula is entered.
• Cells are referenced in a formula by their column-row identifier.
• The symbols for addition, subtraction, multiplication, and division are: + - * /
• We do not have to enter capital letters in the formula, They will be capitalized automatically.

The correct answer is File Transfer Protocol.

Key Points

• File Transfer Protocol is the full form of FTP.

Additional Information

• A protocol is a set of rules or procedures for transmitting data between electronic devices, such as computers.
• The protocol that is used for transferring both text and binary files over the Internet is called File Transfer Protocol (FTP).

The correct answer is 1.

Key Points

• The minimum number of columns that a table in MS Word can have is 1.

Additional Information

• The minimum number of rows a table an MS-Word document can have is 1 row
• The minimum number of columns a table an MS-Word document can have is 1 column.

The correct answer is the Formula bar.

Key Points

• Formula bar displays the contents of the selected cell in an MS Excel worksheet.

Additional Information

• The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.
• The title bar displays the title of the window and It includes the close, minimize, and maximize buttons.
• A status bar is located at the bottom of Internet browser and application windows. It displays the current state of the web page or application.
• The name box in the worksheet displays the address of the selected cell.

The correct answer is Clipboard.

Key Points

• Clipboard stores the cut or copied texts in MS Word.

Additional Information

• The Office Clipboard stores text and graphics that you copy or cut from anywhere, and it lets you paste the stored items into any other Office file.
• A header is the top margin of each page.
• A footer is the bottom margin of each page.

Source:- https://support.microsoft.com/en-us/office/use-the-office-clipboard-028903c7-66ea-4eb0-b0a1-bacdb952e3a1#:~:text=The%20Office%20Clipboard%20stores%20text,into%20any%20other%20Office%20file.

The correct answer is Communication services.

• Email or electronic mail is used to transfer the documents from one place to another place in a fraction of a second.

Key Points

• On the internet, many free services for mail are available and can be sent through the computer as well as with the Smartphone.
• An email may contain news, photos, or files.
• E-Mail is the best to keep in touch with near and dear ones round the clock and can be used at any time as per requirement.

Additional Information

Differences between email and webmail:

• Today, the term email is often used to include both browser-based electronic mail, such as Gmail and AOL, and non-browser-based electronic mail, such as Outlook for Office 365.
• However, a distinction was previously made defining email as a non-browser program that required a dedicated email server and clients. The advantages to using non-browser email are integration with corporate software platforms, enhanced security, and lack of advertisements.

Uses of email:

• Email can be used in a variety of ways, either personally or within an organization, as well as one on one or among a large group of people.
• Most people find email to be a beneficial way to communicate with individuals or small groups of friends or colleagues. It enables users to easily send and receive documents, images, links, and other files. Furthermore, it provides users with the flexibility of communicating with others on their own schedule.

The correct answer is Print Preview.

• Print Preview option is used prior to the final printing of the required paper.

Key Points

• The following options are to be used to check the print preview.
• Step: #1 – Open the file.
• Step: #2 – Click on the Office Button.
• Step: #3 – Click on the Print button
• Step: #4 – Click on the Print Preview button
• Step: #5 – Print Preview will be displayed on the screen.
• Step: #6- Modify the setting in page set up or any other changes if required and again review the print preview.

The correct answer is NOW.

• If a current date and time are required, the NOW function is used.

Key Points

• The TODAY function takes no arguments and returns the current date, updated whenever a worksheet is changed or opened.
• One can also use F9 to force the worksheet to recalculate and update the value.
• In the Excel sheet, the Date and Time entry is very easy and can be updated as under.
• Select the cell where the date and time are to be inserted.
• For Date, Select Ctrl+; and press enter.
• For Time select Shift+Ctrl+; and press enter.

The correct answer is URL.

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

• The Italic option refers to the font style in MS Word.

Key Points

• The most common font styles in MS word are Regular, Italic, Bold and Bold Italic.
• By default in MS Word 2013, the font of each new document is set to Calibri normal.
• However, Word provides several other fonts that one can use to customize text and title.
• To change the font, first, select the text and change the font style accordingly.
• 216 fonts are available in Microsoft Office Professional & Professional Plus and 68 fonts in Microsoft Home.

The correct answer is short cut key for opening an existing word document is Ctrl+M.

Key Points

• Office Button- It allows opening, saving, and printing documents, and performing other document output functions.
• Ctrl + O – It brings up the Open window, allowing loading an existing document stored on the computer.
• Double-click - It opens the header or footer area to open it for editing.
• Ctrl+M- In Microsoft Word and other word processor programs, pressing Ctrl + M indents the paragraph. If this shortcut is pressed more than once, it continues to indent further.

The correct answer is Ctrl+X.

• To cut the data from a cell in an Excel sheet, Ctrl+X is to be used.

Key Points

• We can save our time by using text-editing keyboard shortcuts while writing anything anywhere.
• In computing**, Ctrl+x** is the key combination of the control key and a key usually labeled "x" (lower-case letter ex), typically used to cut selected text and save it to the clipboard ready to paste elsewhere.

The correct answer is Name box.

Key Points

• Name Box is a box in the input left in the left corner of the ribbon i.e. left to the formula bar.
• In each box, the name of the active sheet cell is shown and we can also search any cell by inserting the name of the cell in it.
• It can also be used to create a named range.

The correct answer is Shading.

• For the color background of the text in a document, select the text and choose a color as per requirement.

Key Points

• Colour may be selected from standard color or by clicking the option of more advanced color options.
• Highlighting the text with any color grabs the attention of the user.
• Also, it is easy for the user to find the important things in the document.

The correct answer is Blind carbon copy.

• Bcc means blind carbon copy which is the same as similar Cc.
• Bcc appears for specified recipients only.

Key Points

• Due to security as well as privacy reasons, it is best to use the Blind Carbon Copy (Bcc) feature when sending an email message to a large number of people.
• When you place email addresses in the BCC field of a message, those addresses are invisible to the recipients of the email mentioned.
• Earlier this concept was used in paper correspondence but now it is applied to emails.