Computer Knowledge PYQs

The correct answer is Ctrl + E.

• A Control key is a modifier key that, when pressed in conjunction with another key, performs a certain action.
• Ctrl + E is the short key to align selected text or line to the center In Microsoft Word and other word processors.

​

• Ctrl + R -is the short key to align selected text or line to the right.
• Ctrl + M is the short key to Indent the paragraph.
• Ctrl+A is the short key to select all text or other objects present.
• Ctrl+B is the short key to bold highlighted text.
• Ctrl+C is the short key to copy any selected text or another object.
• Ctrl+F is the short key to open the find window.
• Ctrl+G is the short key to open Find in a browser and word processors.
• Ctrl+N is the short key to create a new page or document.
• Ctrl+O is the short key to open a file in most programs.
• Ctrl+P is the short key to open a print window to print the page you're viewing.
• Ctrl+J is the short key to view downloads in browsers and set justify alignment in Microsoft Word.
• Alt+C is a keyboard shortcut most often used to view the favorite in Internet Explorer.

The correct answer is Left.

• Users can change the horizontal alignment of the cell of an MS Excel worksheet as per requirement.

• By default MS Excel aligns the text to the left of an MS Excel worksheet.

• It also aligns numbers to the right of an MS Excel worksheet.

• Users can change the horizontal alignment by Right-click on the cell and choose the format cell.

• There is an option called Alignment In format cells dialogue box.

 

• Horizontal Alignments:
• Left − Aligns the cell contents to the left side of the cell.
• Center − Centers the cell contents in the cell.
• Right − Aligns the cell contents to the right side of the cell.

The correct answer is 4096.

• MS Excel formula is an expression that operates on values in a range of cell addresses and operators.
• The operator "^ (caret)" raises a number to a power.

​

• Users can find all available Excel functions in the Function Library on the Formulas tab

• The Excel power(^) function returns a number to a given power.

• Select the "Math & Trig" option from the Formula tab.

• The power option present in the dialogue box will help the user to find the power of a given number.

Confusion Points 

Here, It is calculating 4 ^ 2^ 3 = (4^2)^3 = 16 * 16 * 16 = 4096. 

If 4^ 2^4 was given then the answer will be 65536.

The correct answer is From.

Key Points

• Email is a digital message from an author to one or more recipients.
• The email was first introduced by Ray Tomilson.
• When you send an email, you need to select the email address that will receive it.
• The To line of an email contains its primary recipient or recipients.
• All recipients in the To line are visible to all other recipients, possibly by default.
• When you send an email your email address contains in from the field.
• It must list the email address, and one can add a name as well.
• Users can also include a name to appear alongside their email address by updating the Personal Information settings.

Additional Information

• Bcc and Cc are two different ways of sending copies of an email to additional people.
• Cc stands for “carbon copy," 
• When you Cc people on an email, the Cc list is visible to all other recipients.
• Cc is useful when you want someone else to receive a copy of an email, but they aren’t one of the primary recipients.
• Bcc stands for “blind carbon copy.
• Only the sender can see the list of BCC recipients.
• Bcc is useful when you want someone else to receive an email, but you don’t want the primary recipients of the email to see you’ve sent this other person a copy

The correct answer is The cell will switch to editing mode so that its content can be modified.

• Function Keys in Excel are the faster way of doing certain tasks by using the keyboard instead of a mouse.

• The F2 key will edit the active cell and put the insertion point at the end of its contents.

• Using the "F2" Key users can edit the contents of a cell in excel.

• Turn off Allow editing directly in cells and pressing F2 will move the insertion point to the formula bar.

• If you press "F2" for an empty cell then it simply allows you to type in the empty cell.

• Pressing the “Alt + F2” keys together will open the “Save As” dialog box.

• Pressing CTRL + F2 keys will open Print options.

• Pressing Shift + F2 keys together will insert a comment in the active cell.

• Pressing "Alt + Shift + F2” will save the active workbook.

• Delete or Backspace key on the keyboard will delete the content in the cell.

• Alt+H+H is the keyboard shortcut to open the Fill Color menu on the ribbon.

The correct answer is Superscript

• Superscripts are characters set that type above the normal line of text.

• It is usually smaller than the rest of the text.

• Example for superscript: 5^th

• Superscript letters are used to form the trademark symbol.

• The signs for copyright © are also sometimes superscripted.

• Subscripts appear below the baseline.

• Example for superscript: NO₂.

• Subscripts appear at or below the baseline,

• Both Superscripts and subscripts are equally small numbers that stand for mathematical and chemical formulas.

• Strikethrough is a font effect that causes text to appear as though it is crossed out.

The correct answer is Transmission Control Protocol.

• TCP is the acronym of Transmission Control Protocol.
• TCP/IP is the most popular internet protocol.
• It is the communication protocol of the internet.
• IP stands for Internet Protocol.
• The Internet Protocol (IP) is the address system of the Internet.
• Internet Protocol helps for delivering packets of information from a source device to a target device.
• TCP/IP came into being in 1982.
• There are a total of 4 layers in a TCP/IP model.

1. Application Layer
2. Transport Layer
3. Internet Layer
4. Network Interface

• The TCP/IP relationship is similar to sending someone a message written on a puzzle through the mail.

The correct answer is Ctrl + X.

• Ctrl + X is the keyboard shortcut to cut selected text in MS Word.
• Ctrl + X short key is often used to cut a selected section of the text, image, or another object.
• To use the shortcut Ctrl+X, press and hold either Ctrl key on the keyboard and while continuing to hold, press the "X" key with either hand.
• Highlight the item you want to remove, and then use Ctrl-X to remove it and put it into memory so you can paste it somewhere else.
• Ctrl+X only works if the text is editable.
• Ctrl+Z  is the keyboard shortcut to undo the most recent action.
• If you mistakenly cut something, you can use the Ctrl+Z undo shortcut.
• Ctrl + C is the short key to copy a selected item.
• Ctrl + Alt + R is the short key to resize the lens with the mouse.
• Alt+X is the short key often used to display the Unicode character code of a character.

The correct answer is Ctrl + D.

• Ctrl + D is the short key used to add a bookmark of the page currently opened in a Chrome browser.
• it is used to add the current site to a bookmark or favorite.
• All major Internet browsers like Chrome, Edge, Firefox, Opera create a new bookmark for the current page while pressing Ctrl+D.
• Ctrl + D in Microsoft PowerPoint is using it to duplicate objects.
• In Microsoft, Excel Ctrl+D fills and overwrites a cell(s) with the contents of the cell above it in a column.
• In Microsoft, Word Ctrl+D is used to open the font preferences window.
• Ctrl + M is a keyboard shortcut used to Indent a paragraph from the left.
• Ctrl+B is a keyboard shortcut used to toggle bold text on and off.
• Alt+B is a keyboard shortcut used to open the bookmarks file menu option in Firefox.

The correct answer is Both (i) and (ii).

• Both the given statements are FALSE.
• There's no option that allows left and right an the same line.
• In MS Word the default action when pressing the Enter key is to create a new paragraph.
• In Microsoft Word, the keyboard shortcut Ctrl+Enter adds a page break at the cursor's current position.
• Ctrl+ L is the short key to align a paragraph to the left side of the page.

Ctrl+ E is the short key to align a paragraph to the center of the page.

Ctrl+ R is the short key to align a paragraph to the right side of the page.

The correct answer is Outline.

Key Points

• The outline option in MS Word shows the contents of a document as bulleted points.

• Outline in Word means seeing just the headings of a long document.

• Outline view makes viewing complex documents easier by breaking the headings and paragraphs into collapsible sections

• The outline option is present under the view tab.

• Outlines are composed of topics and subtopics.

• The Outline view breaks the document down so that each heading and paragraph is represented by a single line.

• It is used when you want to work with large portions of your document at the same time. I

• Outline View is an excellent way of getting to the section you want in a long document extremely quickly.

• To exit Outline view, click the View tab and choose another document view.

• The Draft view option allows you to generally see how your text will appear on paper.

​

• Web Layout view is designed to allow you to easily see how your documents will look if used in an online environment.

• Print Layout view is designed to allow you to easily see how your document will look like when you actually print it.

The correct answer is first.

Key Points

• The home page is the first page of a website.

• The home page is known as the initial page.

• It is also known as the start page.

• The term home page can also refer to one or more pages always shown in a web browser when the application starts up.

• A user navigating to a website from a search engine will see the home page first.

• When a web browser is launched, it may automatically open the home page by default.

• The home page is used to facilitate navigation to other pages on the particular website.

• A website is a collection of web pages that are grouped together and usually connected together in various ways.

The correct answer is Ctrl + Tab.

Key Points

• Ctrl+Tab is a keyboard shortcut most often used to switch between open tabs in a browser.
• Ctrl + Tab keyboard shortcut will help the user to move through each of the open tabs going to the right in a Chrome browser.
• To use Ctrl + Tab keyboard shortcut, press and hold either Ctrl key, and while continuing to hold, press the Tab key.
• If you had more than one open tabs in your browser you could press Ctrl+Tab to switch between each of those tabs going left to right without using your mouse.
• Ctrl+Shift+Tab keyboard shortcut will help to switch between the tabs in the opposite direction (right to left).

Additional Information

• In Microsoft PowerPoint, the Ctrl+Tab switches between all open presentations if you have more than one presentation open at once.
• If you only have one presentation open the Ctrl + Tab keyboard shortcut will do nothing.
• Alt+N is a keyboard shortcut used to open the Insert option in a file menu or the Ribbon.
• Ctrl + N is the keyboard shortcut most often used to create a new document, window, workbook, or other types of file.
• Alt+Tab is a keyboard shortcut used to switch between open programs in Microsoft Windows and other operating systems.

The correct answer is Post Office Protocol.

Key Points

• The Post Office Protocol (POP) is an Internet protocol used by e-mail clients.
• It is mainly used to retrieve e-mail from a mail server.
• Post Office Protocol version 3 (POP3) is the most common version of POP.
• Post Office Protocol provides easy and fast access to the emails as they are already stored on our PC.
• It is easy to configure and use.
• It is the primary protocol behind email communication.

Additional Information

• The first version of the post office protocol was first introduced in 1984.
• POP is an application layer protocol in the OSI model
• SMTP is another type of internet protocol that helps to send emails.
• SMTP stands for Simple Mail Transfer Protocol.
• SMTP is used as a message transfer agent.

Show / Hide is NOT correct.

• Among the options, only Show / Hide does NOT appear as a part of the 'Clipboard' command group under the Home menu in recent versions of MS Word, such as Word 2016.

• The home tab in MS Word gives you access to the most commonly used commands and is displayed by default when you open an instance of Word.

• The clipboard group is present on the far left of the Home Tab.

• Users can quickly display the Clipboard task pane by clicking on the dialog launcher in the bottom right corner of this group.

• The icons appear as a part of the 'Clipboard' command group under the Home menu are:

• Paste

• Cut

• Copy

• Format Painter

Additional Information

• The paste icon is a drop-down menu of paste choices.
• It is the mouse equivalent of Ctrl+V.
• Cut icon cuts the current selection to the clipboard.
• It is the mouse equivalent of Ctrl+X.
• Copy icon copies the current selection to the clipboard.
• It is the mouse equivalent of Ctrl+C.
• Format Painter copies the formatting from one place in a document and lets you apply it somewhere else.

The correct answer is (i) True, (ii) False.

Key Points

• In MS Word, all paragraphs can have the right alignment is a TRUE statement.

• A paragraph's text in MS Word is right-aligned when it is aligned evenly along the right margin.

• Right-aligned paragraphs are flush with the right margin and ragged on the left.

• Click anywhere on the paragraph you want to align and click the Align Text Right button available on the Home tab.

• Ctrl+R is the keyboard shortcut for the right alignment.

• Users can change the alignment of any paragraph by using the appropriate tools on the Formatting toolbar.

• A paragraph's text is said to be justified when it is aligned evenly along both the left and the right margins

• A justified paragraph alignment aligns both the left and right sides.

• In MS Word, all paragraphs cannot have the same hanging position is a FALSE statement.

• Every line of the paragraph except the first one is indented.

The first and last cells of a table that can be merged is NOT correct.

Key Points

• Merging cells in a table combines two or more adjacent cells in a word table.

• They can be adjacent cells in a row or column.

• Combining cells can increase the size of the cell.

• The first and last cells of a table can not be merged.

• You can only merge two or more consecutive rows or two adjacent columns.

• Two or more consecutive cells of a column can be merged.

• Two or more consecutive cells of a row can be merged.

• Alternate cells of a row or column cannot be merged.

• For merging two cells first select the cells you want to merge.

• Right-click any of the selected cells, and then choose the “Merge Cells” command on the context menu.

• The merged cells will be looks like as follows

• You can also merge cells by choosing the Table Tools “Layout” tab and then click the “Merge Cells” button there.

The correct answer is the Formula bar.

Key Points

• Among the options, the formula bar appears at the top of a worksheet in MS Excel.

• It is located directly above the spreadsheet.

• Excel formula bar is a special toolbar at the top of the Excel worksheet window.

• You can use it to enter a new formula or copy an existing one.

• The formula bar displays information entered in the current or active cell.

• The contents of a cell can also be edited in the formula bar.

• The formula bar gets activated as soon as you type an equal sign in any cell or click anywhere within the bar.

• If the formula bar option hides it can be activated from the Excel Option’s Advanced tab.

• The status bar displays various information about an Excel worksheet.

• Status Bar in Excel is located at the down below the Sheet names in an Excel worksheet.

• The horizontal and vertical scroll bars are used to scroll through the data in its worksheets.

The correct answer is Shift.

Key Points

• Shift key is used to select a range of continuous cells in an MS Excel worksheet.

• To select a range of cells, use the shift key in combination with any of the movement keys.

• You can also click and hold the left mouse button and drag through the range you want to select.

• To select all the cells to the right of the active cell in the row, hold down Shift, Cntrl and press the Right Arrow Key.

• To select all the cells below the active cell in the worksheet, hold down Shift, Cntrl and press the Down Arrow key.

• To select a single cell simply left-click on it.

• Tab key is used to moves the cell cursor from one column to next from the left to right in the MS Excel worksheet.

• The control key is a modifier key that, when pressed in conjunction with another key, performs a special operation in the MS Excel worksheet.

The correct answer is 10.

Key Points

• The Excel Ceiling function rounds a given number up to the nearest specified multiple.

• It is categorized under math and trigonometry functions.

• It can be used as a worksheet function (WS) in Excel.

• The formula for the Excel Ceiling function is =CEILING (number, significance).

• Number: Value that we wish to round off.

• Significance: Multiple that we wish to round up to.

• If the formula reads =CEILING (7, 5) it will return the value of 10.

• The function will round off number 7 to the nearest multiple of 5(10).

• When the number is negative and significance is positive in the Ceiling function, the value will round up towards zero.

• It is very useful in financial analysis as it helps in setting the price after currency conversion, discounts, etc.

• If the number is already an exact multiple, no rounding occurs and the original number is returned.