Computer Knowledge PYQs

The correct answer is Ctrl + Page up.

Key Points

• Ctrl + Page up shortcut is used to activate a browser tab to the left of the current tab in a Chrome browser.

Additional Information

Source:-https://support.google.com/chrome/answer/157179?co=GENIE.Platform%3DDesktop&hl=en#zippy=%2Ctab-and-window-shortcuts

The correct answer is 13.

Key Points

• The answer of the formula = EVEN(3) + ODD(8) in excel is 13.

Additional Information

• The EVEN function rounds a positive number up to the nearest even integer i.e. 3 will become 4.
• The ODD function rounds a positive number up to the nearest odd integer i.e. 8 will become 9.
• Hence, 9+4= 13.
• 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 = E5 + 4.

Key Points

• If a formula = B2 + 4 is in cell A1 then cell A1 is copied into D4, then the formula in D4 will be = E5 + 4.

​

Additional Information

• 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 the Status bar.

Key Points

• In MS Excel, the 'Zoom' option appears in the Status bar.

Additional Information

• The minus and plus symbols are there in the status bar. which are used to quickly zoom the document.
• The Status Bar is the area at the bottom in Excel where various information about the current mode or any special keys that are engaged can be seen.
• 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. It displays the contents of the cell.
• The title bar displays the title of the window and It includes the close, minimize, and maximize buttons.

The correct answer is Bullets.

Key Points

• "Bullets" appears as a part of the 'Paragraph' command group within the Home menu in recent versions of MS Word, such as Word 2016.

Additional Information

• A bullet is an asterisk, black dot, circle, or another mark found before the text.
• They are utilized to identify key items or denote significance.
• Paragraph group
• Add bullets
• Add numbers
• Apply indents
• Sort paragraphs
• Show the paragraph mark
• Align paragraphs
• Adjust line spacing
• Change the background color
• Add borders.

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

Key Points

• In Landscape orientation, the width of a page is larger than its height.
• In Portrait orientation, the height of a page is larger than its width.
• Hence, both the above statements are False.

The correct answer is Ctrl + K.

Key Points

• Ctrl + K is used to insert a hyperlink in an MS Word document.

Additional Information

• A hyperlink is a word, phrase, or image that you can click on to jump to a new document or a new section within the current document.

Source:- [https://support.microsoft.com/en-us/windows/keyboard-shortcuts-in-apps-139014e7-177b-d1f3-eb2e-7298b2599a34#bkmk_wor

d](https://support.microsoft.com/en-us/windows/keyboard-shortcuts-in-apps-139014e7-177b-d1f3-eb2e-7298b2599a34#bkmk_word)

The correct answer is Dotted-decimal notation.

Key Points

• An IP address is often represented in the dotted-decimal format.

Additional Information

• An IP address (internet protocol address) is a numerical representation and is a unique identification of a specific interface on the network.
• There are two versions of IP.
• IPv4 addresses are 32-bits long. They are expressed in the dotted-decimal format.
• IPv6 addresses are 128-bits. They are expressed in the dotted-hexadecimal format

The correct answer is One.

Key Points

• While printing an MS Word document, we can set the number of copies to be printed.
• By default, we will have one copy of the document.

The correct answer is POP.

Key Points

• The post office protocol (POP) is a commonly used message request protocol for transferring messages from an e-mail server to an e-mail client.

Additional Information

• A protocol is a set of rules or procedures for transmitting data between electronic devices, such as computers. 
• Hypertext Transfer Protocol (HTTP) is a protocol for transmitting hypermedia documents, such as HTML.
• Simple Mail Transfer Protocol (SMTP) is a method to transfer mail from one user to another. SMTP is a push protocol and is used to send mail.
• POP or IMAP (internet message access protocol) is used to retrieve those emails at the receiver’s side.

The correct answer is a Mini toolbar.

Key Points

• in MS-Word 2007 document area, as soon as a block of text is selected for formatting a mini toolbar appears.

Additional Information

• The mini toolbar provides a quick-access version of the fonts, alignment, text color, indenting, and bullets.

The correct answer is the Website.

Key Points

• A website is a set of related web pages located under a single domain name.

​

Additional Information 

• A Web host allocates space on a web server for a website to store its files.
• A Web Browser is a software application used to access information on the World Wide Web.
• A search engine is a program that searches and identifies items, as specified by the user, in databases on the world wide web.

The correct answer is COUNT IF.

Key Points

• COUNT IF function in MS-Excel counts the number of cells within a range that meet the given condition.

Additional Information

• A function is a predefined formula that performs calculations using specific values in a particular order.
• The COUNTIF function in Excel counts the number of cells in a range that match one supplied condition.
• Criteria can include logical operators (>,<,<>,=) and wildcards (*,?).
• COUNTIF requires a cell range.
• COUNTIF only supports a single condition
• COUNTIFS function is used to support multiple criteria.
• COUNTA function is used to count only the cells that have data.
• The COUNT function is used to get the number of entries in a number field that is in a range or array of numbers.

The correct answer is Toolbar.

Key Points

• The icons or pictures associated with some commands in menus will appear on the toolbar of MS-Excel.

Additional Information

• A toolbar is just a collection of icons that provides a shortcut to the menu.
• 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.
• The Menu bar gives access to different commands that are used in Excel.

The correct answer is the Domain name.

Key Points

• The second part of an e-mail address is the domain name.

​

Additional Information

• An email address is a unique identifier for an email account.
• It is used to send and receive an e-mail over the Internet
• An e-mail address has two main parts:
• First is username
• Second is the domain name
• Structure of an e-mail address:- username@domain name

The correct answer is Home.

Key Points

• The formatting tasks such as bolding, italicizing, changing the font, and size of text found in MS-Word 2007 are in the Home tab.

Additional Information

• The Page Layout Tab allows us to arrange your document pages.
• The References Tab allows us to create a table of contents, footnotes, citations, cross-references, etc.
• The Insert tab allows us to insert things like pictures, clip art images, shapes, SmartArt graphics, charts, and a host of other items.

The correct answer is Ctrl + W.

Key Points

• Ctrl + W is a shortcut key to close a document 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 Remove Header.

Key Points

• Remove Header is not an option in the table menu of the Insert tab.

Additional Information

• The table menu is concerned with tables only.
• Header and footer are dealt with in the Header and Footer menu of the Insert tab.
• The Insert tab allows us to insert things like pictures, clip art images, shapes, SmartArt graphics, charts, and a host of other items.

The correct answer is Ctrl+→

Key Points

• Ctrl+→ short cut is used to move the cursor one word right while editing data in a cell in MS-Excel.

Additional Information

• Press CTRL+an arrow key to scroll to the start and end of each range in a column.

The correct answer is the Digital subscriber line.

Key Points

• A digital subscriber line is a method of accessing fixed internet for home or office.

Additional Information

• The digital subscriber line (DSL) uses the existing telephone cabling infrastructure.
• There are two methods of Internet access
• Direct- The device connects directly to the Internet using 3G/4G mobile networks or public Wi-Fi.
• Indirect- The device connects to a network using Ethernet or WiFi and the network connects to the Internet using DSL, cable, or fiber.