Intermediate Level

What is the difference between a range and a named range?

A range in Excel refers to a selection of two or more cells. For example, “A1:A10” refers to a range of
cells from A1 to A10. Ranges are often used in formulas, functions, and references to identify specific
data in the worksheet.
A named range, on the other hand, is a user-defined name assigned to a range of cells. Instead of
using cell references like “A1:A10”, you can name this range as "SalesData" and refer to it in
formulas. Named ranges improve clarity and make it easier to manage and understand formulas.
Example:
- Range: “=SUM(A1:A10)” – Adds up all the values in cells A1 through A10.
- Named Range: If “A1:A10” is named "SalesData," then “=SUM(SalesData)” achieves the same result
but is more readable.

What is freeze pane in Excel?

Freeze Pane is a feature in Excel that allows you to keep specific rows or columns visible when
scrolling through the rest of the worksheet. It’s particularly useful when working with large datasets,
ensuring that headers or important labels remain in view.
Example:
To freeze the top row, you would:
1. Go to the View tab.
2. Select Freeze Panes.
3. Choose Freeze Top Row.
Now, as you scroll down, the top row remains visible.

How to prevent someone from adding, deleting, or inserting any data or cells in an Excel sheet?

You can prevent users from adding, deleting, or inserting data or cells by protecting the worksheet.
Steps:
1. Select the cells you want to allow editing (if any) and right-click to choose Format Cells. Go to the
Protection tab and uncheck Locked.
2. Go to the Review tab.
3. Click on Protect Sheet.
4. In the Protect Sheet dialog, check the options you want to allow (e.g., select cells, format cells).
5. Enter a password if you want to add one, and click OK.
Once protected, users won't be able to insert, delete, or modify cells that are locked.