Computer Knowledge PYQs

The correct answer is Ok.

Key Points

• There is a total of THREE buttons in the Clipboard pane in MS Word 2010.
• Clear All and Paste All, these two buttons are present at the top.
• While Options button is present at the bottom which contains 5 various options.
• The 'Ok' button is not present in the Clipboard pane.

Additional Information

• To open the Office clipboard and access the items you copied or cut, make sure the Home tab is active and then click the “Clipboard” button in the lower-right corner of the Clipboard section.
• By default, the Clipboard pane is anchored to the left side of the Office program window.

The correct answer is Sender maid ID.

Key Points

• Sender maid ID is mandatory to send an email.
• The body is the part of mail that contains the actual mail data, it can be empty.
• 'Attachment' is the file that we want to share through the mail.
• 'Subject' is the main headline of the mail.

Additional Information

• The first email was sent by Ray Tomlinson to himself in 1971.
• The internet got its start in the United States more than 50 years ago as a government weapon in the Cold War.
• Bob Kahn and Vint Cerf invented the Internet.

The correct answer is 1 - C, 2 - B, 3 - A.

Key Points 

• The Hypertext Transfer Protocol (HTTP) is an application layer protocol for distributed, collaborative, hypermedia information systems.
• The File Transfer Protocol (FTP) is a standard communication protocol used for the transfer of computer files from a server to a client on a computer network.
• Telnet is an application protocol used on the Internet or local area network to provide a bidirectional interactive text-oriented communication facility using a virtual terminal connection.

Additional Information

• INTERNET stands for Interconnected Network that is a network system that connects millions of web servers.
• GOOGLE stands for Global Organization of Oriented Group Language of Earth.
• USB stands for Universal Serial Bus.
• CCTV stands for closed-circuit television.

The correct answer is Sheet.

Key Points

• The Format Cells dialog box has the following options for formatting cells:
• The number tab – allows you to specify the numerical data type. For example, currency, date, percentage.
• Fill – allows you to add shading and background colors to a cell.
• Protection – allows you to lock or hide a cell.
• Border – allows you to select a border style for your cell from a variety of different options.
• Font tab – allows you to change the attributes of cell font, including font face, size, style, and color.
• Alignment tab – allows you to change the position and alignment of the data within a cell.

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

Key Points

• Select the View tab in the toolbar at the top of the screen.
• Then check the Ruler option in the Show group.
• Now the horizontal and vertical rulers should appear.

Additional Information

• Word displays a horizontal ruler at the top of your document in most views.
• However, a ruler is only available in the Print Layout view.

The correct answer is Web pages.

Key Points

• A web page (or webpage) is a specific collection of content provided by a website and displayed to a user in a web browser.
• A website typically consists of many web pages linked together in a coherent fashion.
• The name "web page" is a metaphor for paper pages bound together into a book.
• The primary difference between a webpage and a website is that a webpage is a single document on the Internet under a unique URL.
• In contrast, a website is a collection of multiple web pages in which information on a related topic or other subject is linked together under a domain address.

Additional Information

• Tim Berners Lee invented the World Wide Web.
• Berners-Lee proposed an information management system on 12 March 1989, then implemented the first successful communication between a Hypertext Transfer Protocol (HTTP) client and server via the Internet in mid-November.
• Charles Babbage is known as the Father of the Computer.
• Ada Lovelace is known as the Mother of the Computer.

The correct answer is 1,048,576.

Key Points

• Excel has a physical limit of about 1 million rows (1,048,576 rows).
• 1,048,576 is simply 2 to the 20^th power, and thus this number is the largest that can be represented in twenty bits.
• Old versions of Excel allowed 65536 rows (2 to the 16^th power).
• This was increased to 1048576 to address complaints that 65536 rows were too few.

Additional Information

Worksheet and workbook specifications and limits:

• The 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 Margin.

Key Points

• The distance between the written text and the edge of a paper is called margin.
• Margins are the blank spaces that line the top, bottom, and left and right sides of a document.
• Word lists a number of pre-formatted options, but you can also make your own margins by selecting “Custom Margins,” found at the bottom of the Margins list.

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+]
• Centre the text - Ctrl+E.
• Align the text to the left - Ctrl+L.

The correct answer is 4.4.

Key Points

• The formula to calculate the average of given numbers is equal to the sum of all the values divided by the total number of values.
• In MS-Excel the format of using the Average formula is
• ​= Average(number1, number 2, number 3, .....).
• Here, the sum of numbers is 22 and this should be divided by 5.
• Hence the result is 4.4

Additional Information

• SUM(): This function is used to adds all the values within a cell range.
• ROUND(): The round function is used to round a number to a specified number of digits.
• RAND(): This function is used to returns a random number greater than or equal to 0 and less than 1.
• MOD(): This function is used to find the remainder after dividing a number by another number.

The correct answer is a - z, b - x, c - y.

Key Points

• The shortcut key used for italics is Ctrl + i.
• The shortcut key used for Decrease font size is Ctrl + [.
• The shortcut key used for Increase font size is Ctrl + ].

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 Font color.

Key Points

• You can change the colour of the text in your Word document.
• Select the text that you want to change.
• On the Home tab, in the Font group, choose the arrow next to Font Color, and then select a colour.
• You can also use the formatting options on the Mini toolbar to quickly format text.

Additional Information

• Shading is the colour or artistic design you use as a background for a paragraph.
• Borders and shading are formatting tools for enhancing text, paragraphs, table cells, or frames.
• A style is a set of formats that you can apply to selected items in your presentation to quickly change their appearance.

The correct answer is Ruler.

Key Points

• The ruler can be used to change the column width of a table in MS Word.
• A ruler can be defined as a tool or device used to measure the length and draw straight lines
• A ruler or measuring tape can be used to measure lengths in both metric and customary units.
• The marks or intervals on a ruler are called hash marks.

​

Additional Information

• Title bar, Microsoft Word displays the name of the document you are currently using.
• A Scroll bar is a bar that appears on the side or bottom of a window to control which part of a list or document is currently in the window's frame.

The correct answer is cell's column and row.

Key Points

• A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.
• For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
• It is basically a cell's column number and row number.

Additional Information

• In MS Excel, columns are defined with Alphabets like A, B, C....and so on.
• While rows are defined with numerical values like 1, 2, 3, 4,.......and so on.

The correct answer is Paper Clip icon.

Key Points

• A paper clip icon is the standard indicator for an attachment in an email client.
• An email attachment is a computer file sent along with an email message.
• One or more files can be attached to any email message, and be sent along with it to the recipient.

Additional Information

• The first email was sent by Ray Tomlinson to himself in 1971.
• On October 29^th, 1969, the first message was sent from computer to computer on ARPANET.
• The internet got its start in the United States more than 50 years ago as a government weapon in the Cold War.
• Bob Kahn and Vint Cerf invented the Internet.

The correct answer is Dial-up.

Key Points

• Dial-up Internet access is a form of Internet access that uses the facilities of the public switched telephone network (PSTN) to establish a connection to an Internet service provider (ISP) by dialling a telephone number on a conventional telephone line.
• Dial-up connections use modems to decode audio signals into data to send to a router or computer and to encode signals from the latter two devices to send to another modem.
• It is considered the slowest internet service among all.

Additional Information

• In 1979, Tom Truscott and Steve Bellovin, graduates of Duke University, created an early predecessor to dial-up Internet access called the USENET.
• 5G can be significantly faster than 4G, delivering up to 20 Gigabits-per-second (Gbps) peak data rates and 100+ Megabits-per-second (Mbps) average data rates.
• 5G is considered the fastest internet service till now.

The correct answer is Google Chrome.

Key Points

• The Omnibox is a URL box that combines the functions of both the address bar and search box.
• If a user enters the URL of a site previously searched from, Chrome allows pressing Tab to search the site again directly from the Omnibox.
• If a user types keywords into the Omnibox that don't match any previously visited websites and presses enter, Chrome will conduct the search using the default search engine.

Additional Information

• The first web browser - or browser-editor rather - was called WorldWideWeb.
• The first web browser, WorldWideWeb, was developed in 1990 by Tim Berners-Lee for the NeXT Computer.
• The first tool used for searching content (as opposed to users) on the Internet was Archie.

The correct answer is Home.

Key Points

• The Home key is used to move the active cell to the first column on the current row in spreadsheet applications like Microsoft Excel.
• This function is helpful for quickly navigating to the beginning of the row without using the mouse.

Additional Information

• Page Up:
• This key is used to move the active cell up by one screen.
• Ctrl + Home:
• This key combination moves the active cell to the beginning of the worksheet (cell A1).
• Page Down:
• This key is used to move the active cell down by one screen.

The correct answer is SUMADD.

Key Points

• The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.
• The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criterion.
• As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet.
• The SUM function adds values.
• You can add individual values, cell references or ranges, or a mix of all three.
• For example: =SUM(A2:A10) Adds the values in cells A2:10.

The correct answer is Ctrl + K.

Key Points

• To insert the hyperlink in MS Word 2007 document we can use Ctrl + K shortcut.
• Alt+K is a keyboard shortcut most often used to open the Transitions tab in the Ribbon.
• The Return key moves the cursor (or insertion point) to the beginning of the next line.

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

Key Points

• Presentation is the option present in MS PowerPoint.
• It is useful to present slides in different-different formats.
• The print option is used to print our document in Hard copy form.
• Save As option is used when we want to save our document with a new file name and format.
• The Save option is used when we make changes in our existing document and want to save in the existing file only.