Explanation

The VLOOKUP function in Excel is used to search for a value in the first column of a range

And return a value in the same row from a specified column.

It is commonly used for looking up data in a table or range.

Explanation

Explanation

Freezing rows and columns in Excel is done within the View tab on the Excel ribbon, under the Freeze Panes command.

After selecting the desired cells, click the View tab, choose Freeze Panes, and then select the option to Freeze Top Row, Freeze First Column, or Freeze Panes for simultaneous freezing.  

Explanation

List of Microsoft Excel filename extensions

Explanation

In MS Excel, if a numeric value starts with = (Equal Sign)

It is treated as a formula rather than a table.

Tables in Excel are typically created by formatting a range of cells as a table using Ctrl + T or the "Format as Table" option.