Computer Awareness Questions

Explanation:

• An operating system is system software that manages computer hardware, software resources, and provides common services for computer programs.
• Some examples of operating systems include Apple macOS, Microsoft Windows, Google's Android OS, Linux Operating System, and Apple iOS.

Microsoft Office 

Microsoft Office is a set of computer applications mainly used for business or office purposes.

• Here’s a brief explanation of each of the different apps and what you can use them for:
  • Microsoft Word: is a word processor that lets users make and edit text documents, such as reports, letters, and résumés and run spell-checks on writing
  • Microsoft Excel: is an electronic spreadsheet program that helps you store, organize and manipulate data by creating simple to complex spreadsheets
  • Microsoft PowerPoint: allows you to visually display information, using anything from basic slideshows to professional multimedia presentations
  • Microsoft Outlook: is a personal information manager mainly used for emails but that can also be used to store calendars and contact information, manage tasks as well as organize meetings
  • Microsoft Publisher: is a graphic design app that gives users creating material for marketing or publications more options in the layout and design of their documents
  • Microsoft Access: is a database management system that allows you to link and use data from other sources, manipulate the data you’ve gathered in different ways, as well as create simple business applications
  • Microsoft OneNote: is a digital alternative to a paper notebook that allows you to create, organize and share your notes easily
•  

The correct answer is .HTM or .HTML.

Key Points

• Web pages use .HTM or .HTML file extensions.
  • A file extension or file name extension is the ending of a file that helps identify the type of file in operating systems.
  • In Microsoft Windows, the file name extension is a period that is often followed by three characters but may also be one, two, or four characters long.
  • A filename extension is often between one and three characters and is always at the end of the file name, starting with a period.

Additional Information

• A JPG file is an image saved in a compressed image format standardized by the Joint Photographic Experts Group (JPEG).
  • It is commonly used for storing digital photos and used by most digital cameras to save images.
  • JPG files are among the most common image files, along with .PNG, TIF, and .GIF.
• A DOC file is a word processing document created by Microsoft Word.
  • It may contain formatted text, images, tables, graphs, charts, page formatting, and print settings.
  • DOC files are created to save various documents, including letters, resumes, essays, and invitations.
• A JS file is a text file containing JavaScript code that is used to execute JavaScript instructions on web pages.
  • It may include functions that open and close windows, validate form fields, enable rollover images, or create dropdown menus.
  • JS files are referenced by web pages that incorporate JavaScript functions.

The correct answer is HTTPS.

• HTTPS(HyperText Transfer Protocol Secure): is an application layer protocol and used for secure communication over the internet.

Additional Information

• HTTP (HyperText Transfer Protocol): is an application layer protocol designed to transfer information between networked devices and runs on top of other layers of the network protocol stack. HTTP involves a client machine making a request to a server, which then sends a response message and communication between web browsers and web servers. HTTP is a stateless protocol.
• SMTP (Simple Mail Transfer Protocol): is an application layer protocol and used to send emails over the internet. SMTP is a state-full protocol.
• TCP/IP (Transmission Control Protocol/ Internet Protocol) is the communication protocol is used by the internet and used to interconnect network devices on the internet. Its routing function enables internetworking and essentially establishes the Internet.
• TCP is responsible for the data delivery of a packet and IP is responsible for the logical addressing. 
• FTP (File Transfer Protocol):  is an application layer protocol and used to exchange files on the internet and copy large files from a remote computer to the requesters' computer.

The correct answer is PayTm.

• Facebook is an American social media platform.
• Products owned by Facebook are. Instagram, Messenger, WhatsApp, Oculus VR.
• Facebook acquired Instagram in 2012.
• Instagram was founded by Kevin Systrom and Mike Krieger
• Twitter is an American social networking service provider.
  • Parent company: Odeo.​
  • Twitter was founded by Jack Dorsey, Noah Glass, Biz Stone, and Evan Williams
• Paytm is an Indian multinational technology company that specializes in digital payment systems.
  • Hence PayTm is the answer.

Key Points

​System software is software designed to provide a platform for other software. Examples of system software include operating systems like macOS, Linux, Android, and Microsoft Windows, computational science software, game engines, search engines, industrial automation, and software as a service application.

Hence the correct answer is system software.

Additional Information

• Microsoft Word or Excel is application software, as are common web browsers such as Firefox or Google Chrome. It also includes the category of mobile apps, including communication apps such as WhatsApp or games such as Candy Crush Saga.
• Firmware is permanent software programmed into a read-only memory. Typical examples of devices containing firmware are embedded systems, home, and personal-use appliances, computers, and computer peripherals.
• software that automatically displays or downloads advertising material such as banners or pop-ups when a user is online.

The correct answer is Cell address.

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.

Important Points

• 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 Machine Language.

Key Points

• Low-level languages are also known as Machine Language.
• A low-level programming language is a programming language that provides little or no abstraction from a computer's instruction set architecture commands or functions in the language map closely to processor instructions.
• Generally, this refers to either machine code or assembly language.

Additional Information

• Examples of low-level programming languages:
  • C and C++ are now considered low-level languages because they have no automatic memory management. 
• Low-level languages were developed first, and high-level languages came along later.
• High-level languages are more easily understood by humans mostly coding languages like Java.

The correct answer is Internet Protocol.

Key Points

• The Internet Protocol (IP) is the principal communications protocol in the Internet protocol suite for relaying datagrams across network boundaries.
• Its routing function enables internetworking and essentially establishes the Internet.

• IP has the task of delivering packets from the source host to the destination host solely based on the IP addresses in the packet headers.

Additional Information

• Common Internet protocols include:-
  • TCP/IP (Transmission Control Protocol/Internet Protocol)
  • UDP/IP (User Datagram Protocol/Internet Protocol)
  • HTTP (HyperText Transfer Protocol)
  • FTP (File Transfer Protocol). TCP/IP is a stream protocol.

The correct answer is Ctrl+N.

Key Points

• Ctrl+N is the shortcut key used to open a New Document in the MS office.
• In the new document new worksheet is opened in the same window. 

Additional Information

• Some important shortcuts used in MS Excel:
  • 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 range.

Key Points

• In Microsoft Excel, a range is a collection of cells.
• A range can be 2 or more cells and those cells don't necessarily have to be adjacent to each other.

​Additional Information  

• Worksheet and workbook specifications and limits:
  • 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