Question Discussion & Solution

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 the Boot sector.

Important Points

• The portion of a disk that contains the master boot record is the Boot sector.
• The MBR contains a partition table, which stores information on which primary partitions have been created on the hard disk so that it can then use this information to start the machine.
• The MBR is stored on the first sector of the hard disk and is created along with the first partition on the drive.
• It is loaded into memory as one of the first actions during system start-up.

Key Points

• The MBR is comprised of a small section of operating system independent code, a disk signature, the partition table, and an MBR signature.
• The disk signature is a unique four-byte identifier for the hard drive.
• It is used for purposes such as identifying the boot volume and associating partitions and volumes with a specific drive.
• The partition table informs of the start position and length of each partition on the hard disk.

Additional Information

The correct answer is Network of networks.

Key Points

• The Internet is a global wide area network that connects computer systems across the world.
• It includes several high-bandwidth data lines that comprise the Internet "backbone".
• These lines are connected to major Internet hubs that distribute data to other locations, such as web servers and ISPs. 
• Therefore, it is called the 'Network of networks'.

Additional Information

• Vint Cerf is widely known as the father of the Internet.
• Vint is the co-designer with Robert Kahn of TCP/IP protocols and basic architecture of the Internet. 
• Bob Kahn and Vint Cerf were the two who first invented the internet.
• The first web page went live on August 6, 1991.

The correct answer is cell.

Key Points

• The basic unit of an Excel spreadsheet where we enter data is known as a cell.
• Every worksheet is composed up of thousands of rectangles, which are called cells.
• A cell is the intersection of a row and a column.

Additional Information

• Columns are recognized by letters (A, B, C), while rows are identified by numbers (1, 2, 3).
• Each cell has its own name or cell address rooted on its column and row.
• The cell address will also embark in the Name box.

The correct answer is Virtual memory.

Key Points

• Most modern operating systems employ a method of extending RAM capacity, known as "virtual memory".
• A portion of the computer's hard drive is set aside for a paging file or a scratch partition, and the combination of physical RAM and the paging file form the system's total memory. 
• When the system runs low on physical memory, it can "swap" portions of RAM to the paging file to make room for new data, as well as to read previously swapped information back into RAM.
• Excessive use of this mechanism results in thrashing and generally hampers overall system performance, mainly because hard drives are far slower than RAM.

Additional Information

• RAM - Random-access memory is a form of computer memory that can be read and changed in any order, typically used to store working data and machine code. 
• ROM - Read-only memory is a type of non-volatile memory used in computers and other electronic devices.
• Types of ROM:
  • MROM (Masked ROM) 
  • PROM (Programmable Read-Only Memory) 
  • EPROM (Erasable and Programmable Read-Only Memory) 
  • EEPROM (Electrically Erasable and Programmable Read-Only Memory)