Computer Knowledge PYQs

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

The given statements are true.

• A document file can have both, bulleted and numbered lists.
• Page margins in an MS Word document can be customized.

Additional Information

• Bulleted and numbered lists

• A bullet is usually a black circle, but it can be any other symbol used to highlight items in a list.

• The two types of lists are Bullet Library and Numbering Library.

• Bullets and numbered lists provide an excellent way to segregate, list, and organize information for a reader.

• Use bullets to list items that do not have to be in any particular order.

• Numbers or letters are used when information must be in a certain order.

• You can use the default bullets and numbering settings by clicking the appropriate button on the Formatting toolbar.

• You can control the appearance, or format, of a bulleted or numbered list.

• The bullet or numbering format you use last becomes the default format; that is, the next time you create a bulleted or numbered list, Word uses the same format you used the last time you created a bulleted or numbered list.

• To create a bulleted list:

• Click the Bullets button on the Formatting toolbar.

• Type the first item on your list, and press Enter.

• The next line will begin automatically with a new bullet.

• Type the next item on your list, and press Enter.

• When your list is complete, press the Enter key twice to stop the bulleted list.

• To create a numbered list:

• Click the Numbering button on the Formatting toolbar.

• Type the first item on your list, and press Enter.

• The next line will begin automatically with the next number.

• Type the next item on your list, and press Enter.

• When your list is complete, press the Enter key twice to stop the numbered list.

• Page Margins

• Margins are the blank spaces that line the top, bottom, and left and right sides of a document.

• They are important because they help make a document look neat and professional.

• Page margins in an MS Word document can be customized

• Select Page Layout → Margins  → Customize  Margins

• Microsoft Word or MS Word

• Microsoft Word or MS Word is a graphical word processing program that users can type with and t is developed by Microsoft.

• This program was initially named “Multi-Tool Word” but in 1983, was renamed MS Word by Microsoft.

• Its purpose is to allow users to type and save documents.

• The main functions of MS Word:

• Creating new text documents.

• Editing and Formatting the existing documents.

• Making a text document interactive with different features and tools.

• Graphical documents, comprising images.

• Used by Authors and Researchers.

• Detect grammatical errors in a text document.

• Microsoft Word's file extension formats are denoted either by a .doc or .docx.

Important Points

• MS Word is invented by Charles Simonyi and Richard Brodie.
• The founder of Microsoft - Bill Gates and Paul Allen.
• The CEO of Microsoft - Satya Nadella.

The correct answer is Normal.

• When you open a new file in the newer versions of MS Word, such as Word 2016, the default page margin is set as Normal.

Additional Information

• Page Margins

• Margins are the blank spaces that line the top, bottom, and left and right sides of a document.

• They are important because they help make a document look neat and professional.

• Page margins in an MS Word document can be customized

• Select Page Layout → Margins  → Customize  Margins

• Microsoft Word or MS Word

• Microsoft Word or MS Word is a graphical word processing program that users can type with and t is developed by Microsoft.

• This program was initially named “Multi-Tool Word” but in 1983, was renamed MS Word by Microsoft.

• Its purpose is to allow users to type and save documents.

• The main functions of MS Word:

• Creating new text documents.

• Editing and Formatting the existing documents.

• Making a text document interactive with different features and tools.

• Graphical documents, comprising images.

• Used by Authors and Researchers.

• Detect grammatical errors in a text document.

• Microsoft Word's file extension formats are denoted either by a .doc or .docx.

Additional Information

• MS Word is invented by Charles Simonyi and Richard Brodie.
• The founder of Microsoft - Bill Gates and Paul Allen.
• The CEO of Microsoft - Satya Nadella.

The correct answer is Vertical scroll bar.

• A vertical scroll bar appears at the extreme right position of a worksheet in MS Excel.

Key Points

• Scroll Bar
• A scroll bar in Excel is just like the one you have seen at many places while using a computer system.
• This is a thin bar mainly displayed in most computer applications to move the viewing area of computer applications, left, and right or up and down.
• Based on the direction of movement, the scrollbar is of two types Vertical scroll bar and Horizontal scroll bar.
• The vertical scroll bar is used to view the data in excel from top to bottom.

​

• The horizontal scroll bar is used to view the data in excel from left to right.

• Status bar

• The status bar is a name for the lower edge of the worksheet window, which displays various information about an Excel worksheet.

• The status bar can be configured to display things like sum, count, and the average of the currently selected cells.

• It also displays information about the current status of the worksheet, whether scroll lock or end mode are enabled, etc.

• Menu bar

• The Menu bar is directly below the Title bar and displays the menu.

• The menu begins with the word File and continues with the following: Edit, View, Insert, Format, Tools, Data, Window, and Help.

• Microsoft Excel

• Microsoft Excel is part of the Microsoft Office suite of programs and developed by Microsoft in 1987.

• Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data.

• Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc.

• An Excel spreadsheet can be understood as a collection of columns and rows that form a table.

• Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows.

• The point where a column and a row meet is called a cell.

• The address of a cell is given by the letter representing the column and the number representing a row.

Additional Information

• The founder of Microsoft - Bill Gates and Paul Allen.
• The CEO of Microsoft - Satya Nadella.

The correct answer is = $D$3 + $C$5.

Key Points

• Ctrl + C is used to copy the selected content to the clipboard.
• Ctrl + V is used to paste the selected content to the clipboard.

Additional Information

• Microsoft Excel
• Microsoft Excel is part of the Microsoft Office suite of programs and developed by Microsoft in 1987.
• Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data.
• Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc.
• An Excel spreadsheet can be understood as a collection of columns and rows that form a table.
• Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows.
• The point where a column and a row meet is called a cell.
• The address of a cell is given by the letter representing the column and the number representing a row.

Important Points

• The founder of Microsoft - Bill Gates and Paul Allen.
• The CEO of Microsoft - Satya Nadella.

The correct answer is Ctrl + Shift + N.

• Ctrl + Shift + N keyboard shortcuts are used to open a new window in an incognito (private) mode in a Chrome browser.

Key Points

• Google Chrome
• Google Chrome is a cross-platform web browser developed by Google.
• The Chrome browser was initially released on 2^nd September 2008 for Windows XP and was later ported to Linux, macOS, iOS, and Android.
• Ctrl + N: is a shortcut used to open a new tab.
• Ctrl + P: is a shortcut used to print the current page.

Additional Information

• Web browser
• A web browser is a type of software that allows you to find and view websites on the Internet.
• The most important web browsers are Mozilla Firefox, Google Chrome, Microsoft Edge (formerly Internet Explorer), Safar, Opera.
• Internet Explorer was introduced by Microsoft in 1995.
• Mozilla Firefox is a free and open-source web browser developed by the Mozilla Foundation and its subsidiary, the Mozilla Corporation in 2002.
• Safari is a graphical web browser developed by Apple in 2003.

Important Points

• First Web browser - Nexus (developed by Tim Berners Lee).
• First Web browser developed by India - Epic.
• Fastest Web browser - Safari.
• The founder of Google - Larry Page and Sergey Brin.
• The CEO of Google - Sundar Pichai.
• Full form of GOOGLE- Global Organization of Oriented Group Language of Earth.

The correct answer is Change case.

• Change case does NOT appear as a part of the 'Paragraph' command group within the Home menu in recent versions of MS Word, such as Word 2016.

• Bullets

• A bullet is usually a black circle, but it can be any other symbol used to highlight items in a list.

• The two types of lists are Bullet Library and Numbering Library.

• Bullets and numbered lists provide an excellent way to segregate, list, and organize information for a reader.

• Use bullets to list items that do not have to be in any particular order.

• Numbers or letters are used when information must be in a certain order.

• You can use the default bullets and numbering settings by clicking the appropriate button on the Formatting toolbar.

• You can control the appearance, or format, of a bulleted or numbered list.

• The bullet or numbering format you use last becomes the default format; that is, the next time you create a bulleted or numbered list, Word uses the same format you used the last time you created a bulleted or numbered list.

• To create a bulleted list:

• Click the Bullets button on the Formatting toolbar.

• Type the first item on your list, and press Enter.

• The next line will begin automatically with a new bullet.

• Type the next item on your list, and press Enter.

• When your list is complete, press the Enter key twice to stop the bulleted list.

• To create a numbered list:

• Click the Numbering button on the Formatting toolbar.

• Type the first item on your list, and press Enter.

• The next line will begin automatically with the next number.

• Type the next item on your list, and press Enter.

• When your list is complete, press the Enter key twice to stop the numbered list.

• Multilevel lists

• Multilevel lists can contain numbered lists and bulleted lists.

• Automatic lists are a handy feature because if you add a paragraph in the middle of a numbered list or rearrange the order of the items in a list.

• Word automatically renumbers the paragraphs so that they retain their sequence.

• Microsoft Word or MS Word

• Microsoft Word or MS Word is a graphical word processing program that users can type with and t is developed by Microsoft.

• This program was initially named “Multi-Tool Word” but in 1983, was renamed MS Word by Microsoft.

• Its purpose is to allow users to type and save documents.

• The main functions of MS Word:

• Creating new text documents.

• Editing and Formatting the existing documents.

• Making a text document interactive with different features and tools.

• Graphical documents, comprising images.

• Used by Authors and Researchers.

• Detect grammatical errors in a text document.

• Microsoft Word's file extension formats are denoted either by a .doc or .docx.

• MS Word is invented by Charles Simonyi and Richard Brodie.

• The founder of Microsoft - Bill Gates and Paul Allen.

• The CEO of Microsoft - Satya Nadella.

The correct answer is POP3.

• POP3(Post Office Protocol): is an application layer protocol and a standard mail protocol is used to receive emails.
• The numeric value '3' in POP3 represents the version of POP.

Key Points

• The application layer is the top most and seventh layer of the OSI model that interacts with an application program.
• The application layer is the only layer that directly interacts with data from the user end.
• The application layer interacts with software applications to implement a communicating component.
• The interpretation of data by the application program is always outside the scope of the OSI model.
• SMTP(Simple Mail Transfer Protocol): is an application layer protocol and used to send emails over the internet. SMTP is a state-full protocol.

Additional Information

• The Open Systems Interconnection (OSI) Model is a logical and conceptual model that defines network communication used by systems open to interconnection and communication with other systems.
• There are seven OSI layers.
• Application layer.
• Presentation layer.
• Session layer.
• Transport layer.
• Network layer.
• Data-link layer.
• Physical layer.

​

The correct answer is 1.

• = FACT(5-4) = FACT(1) = 1

Key Points

• The Excel Fact function returns the factorial of a given number.
• The FACT function is a built-in function in Excel that is categorized as a Math/Trig Function.
• It can be used as a worksheet function in Excel.
• As a worksheet function, the FACT function can be entered as part of a formula in a cell of a worksheet.
• The factorial of a number is equal to 123....number.
• The syntax of the function is FACT(number).
• FACT(3) returns the value 6 which is equivalent to 321.
• The nonnegative number for which you want the factorial. If the number is not an integer, it is truncated.
• The number cannot be negative or FACT will return the #NUM error.
• = FACT(-4) → factorial of a negative number returns an error value #NUM!.
• = FACT(1.9) → factorial of the integer 1.9 is equal to 1.

​

Additional Information

• Microsoft Excel
• Microsoft Excel is part of the Microsoft Office suite of programs and developed by Microsoft in 1987.
• Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data.
• Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc.
• An Excel spreadsheet can be understood as a collection of columns and rows that form a table.
• Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows.
• The point where a column and a row meet is called a cell.
• The address of a cell is given by the letter representing the column and the number representing a row.

Important Points

• The founder of Microsoft - Bill Gates and Paul Allen.
• The CEO of Microsoft - Satya Nadella.

The correct answer is Safari.

• Safari: is a graphical web browser developed by Apple.
• Safari is a default browser on Apple devices.

Key Points

• Search Engine
• A search engine is software that is designed to search information on the World Wide Web which is needed by the user.
• The other important search engines are Yahoo, MSN, Ask.com, Yandex.

Additional Information

• Bing
• It is a web search engine developed and operated by Microsoft.
• Baidu
• It is formerly known as Baidu Spark Browser, the web-based program that runs on the Chromium platform.
• It is a free internet browser for devices running Windows 7 and above.
• Google
• Google is a web search engine developed and operated by Google LLC.
• It is the most used search engine on the World Wide Web across all platforms.

Important Points

• First search engine - Archie.
• The founder of Apple - Steve Jobs, Steve Woznaik, and Ronald Wayne.
• The CEO of Apple - Tim Cook.
• The founder of Google - Larry Page and Sergey Brin.
• The CEO of Google - Sundar Pichai.
• Full form of GOOGLE- Global Organization of Oriented Group Language of Earth.

The correct answer is Shift + F12.

Key Points

• Shift + F12 keyboard shortcuts are equivalent to CTRL + S to save an open file in MS Word.

Additional Information

• Microsoft Word or MS Word
• Microsoft Word or MS Word is a graphical word processing program that users can type with and t is developed by Microsoft.
• This program was initially named “Multi-Tool Word” but in 1983, was renamed MS Word by Microsoft.
• Its purpose is to allow users to type and save documents.
• The main functions of MS Word:
• Creating new text documents.
• Editing and Formatting the existing documents.
• Making a text document interactive with different features and tools.
• Graphical documents, comprising images.
• Used by Authors and Researchers.
• Detect grammatical errors in a text document.
• Microsoft Word's file extension formats are denoted either by a .doc or .docx.
• ​Shift + F5: is used to move the cursor to the location of the last revision made before the document was last closed.
• Ctrl + F5: is used to restores the size of the active document or window.

Important Points

• MS Word is invented by Charles Simonyi and Richard Brodie.
• The founder of Microsoft - Bill Gates and Paul Allen.
• The CEO of Microsoft - Satya Nadella.

Confusion Points

• Ctrl + F12: Shortcut is used to Open the already saved document in Microsoft Word.

The correct answer is CTRL + V.

Key Points

• CTRL + V is a direct shortcut to paste in MS-Word.

Additional Information

The correct answer is the Name box.

Key Points

• The name box in the worksheet displays the address of the selected cell.

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. It displays the content of the cell.
• 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 correct answer is Triple left clicks.

Key Points

• Three left clicks anywhere in the paragraph are used to select the whole paragraph.

Additional Information

• Other ways to select text
• To select a single word, quickly left double-click that word.
• To select a line of text, place your cursor at the start of the line, and press the Shift + down arrow.
• To select a paragraph, place your cursor at the start of the paragraph, and press Ctrl + Shift + down arrow.
• CTRL+ A to select all.

The correct answer is 1.

Key Points

• The smallest number of rows 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 FTP.

Key Points

• The protocol that is used for transferring both text and binary files over the Internet is File Transfer Protocol (FTP).

Additional Information

• A protocol is a set of rules or procedures for transmitting data between electronic devices, such as computers.
• The post office protocol (POP) is a commonly used message request protocol on the Internet for transferring messages from an e-mail server to an e-mail client.
• Hypertext Transfer Protocol (HTTP) is a protocol for transmitting hypermedia documents, such as HTML.
• Hypertext Transfer Protocol Secure (HTTPS) is a secure version of the HTTP protocol that uses encryption and authentication.

The correct answer is text, files, as well as images.

Key Points

• An email can contain text, files, as well as images.

Additional Information

• E-mail is defined as the transmission of messages on the Internet.
• An e-mail may contain text, files, images, or other attachments.

The correct answer is 0.

Key Points

• The answer of the formula = 8/4/2 - 2/2  in excel is 0.

​

Additional Information

• Simple rules of mathematics are followed.
• 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 32 bits.

Key Points

• An IP version 4 address is 32 bits long.

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 decimal.
• IPv6 addresses are 128-bits. They are expressed in hexadecimal

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

Key Points

• When you enter a value in an Excel cell and press the ENTER key the cursor (selection box) will move to the lower cell.

Additional Information

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

Key Points

• In MS-Word, a word can have both lower-case and upper-case letters. Hence statement first is correct.
• In MS Word, the first word of a paragraph can be made bold.
• Hence, the second statement is wrong.