Explanation

Explanation

The VLOOKUP (Vertical Lookup) function in MS Excel searches for a value in the leftmost column of a table and returns a value in the same row from a specified column. 

For example 

This is one of the most commonly used functions for finding and retrieving data in structured tables.

Explanation

Explanation

A T-graph, commonly known as a T-chart, is a graphic organizer used to compare two aspects of a topic, such as pros and cons or facts and opinions.

Common types of charts include Bar charts, Line charts, Pie charts, Area charts, Scatter plots, and Histograms, but T-graph is not among them.

Explanation

Explanation

In an Excel worksheet, the first cell is labeled as A1 due to the following reasons:

1. Grid System: Excel uses a grid to organize cells, with rows and columns.
2. Rows Labeled by Numbers: Rows are labeled using numbers (1, 2, 3, etc.).
3. Columns Labeled by Letters: Columns are labeled using letters (A, B, C, etc.).
4. First Cell Location: The first cell is located at the intersection of row 1 and column A, hence labeled A1.

Explanation

• The actual working area of the Computer's Microsoft Excel is a worksheet.
• The title bar in MS Excel displays the name of the workbook.
• The main window in a computer spreadsheet is called a workbook.
  

Explanation

To move to the previous cell in a table, press Shift + Tab.

This allows you to navigate backward within the table.

To move to the next cell, press The Tab Key.

This advances the cursor to the following cell in the table.

Explanation

In MS Excel, cell comments are displayed when you hover over the cell containing the comment.

The comment appears in a small box, providing additional information or context about the cell's contents.

Explanation

The PMT function in Excel calculates the payment for a loan based on constant interest rates and payments, categorizing it under financial functions.

It uses inputs like rate (C10/12), number of periods (CB), and loan amount (C9) to compute the payment.