Question Discussion & Solution

The correct answer is Spreadsheet.

Important Points

• MS Excel, a worksheet, also known as a Spreadsheet, is a table into which you enter data and data label.
• Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data.
• Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
• Typically, a workbook contains several worksheets with related content and only one of the worksheets is active at a time.

Key Points

• The main characteristics of worksheets:
  • Cells: Each worksheet has a significant number of cells that can be assigned values and various formatting options.
  • Rows and Columns: Cells in a worksheet are organized into rows and columns. The API of a worksheet allows you to insert, manipulate and delete rows and columns.
  • Names (Named Ranges): The Worksheet class exposes a Names property of type NameCollection that allows you to create, update and manage names.
  • Collection of Hyperlinks: Each worksheet can contain numerous hyperlinks to web pages, particular cells in the workbook, or email addresses.
  • Find and Replace: You can easily find and replace text and numbers in the content of a worksheet.
  • Protection: You can restrict the user from modifying the content and structure of the worksheet.

Additional Information

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 most common image file formats, the most important for cameras, printing, scanning, and internet use, are JPG, TIF, PNG, and GIF. JPG is the most used image file format.

Full Form

JPG = Joint Photographic Experts Group

TIF / TIFF = Tagged Image File Format

PNG = Portable Network Graphics

GIF = Graphics Interchange Format

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 

The correct answer is Ctrl + B.

Key Points

• Ctrl + B is the shortcut key to make the selected letters bold or unbold.
• 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