What is the name of the clicked on cell on Excel?

Answer 1

When you refer to a cell in an Excel formula, you can use any of three different types of reference: relative, absolute and mixed.

Relative cell references are the most commonly used. A relative cell reference in a formula is based on the position of the formula's cell relative to the cell to which it refers. That means if you move the formula cell, or copy it elsewhere, the reference changes. You denote a relative reference simply by using the cell's column letter followed by its row number: A1. A simple formula that uses relative cell references to add the numbers in cells B1 through B9 is:

=SUM(B1:B9)

If you place this formula in cell B10 and then copy it across from B10 to C10, Excel makes the sensible assumption that you want to total the values in the same relative positions in column C - that is, cells C1 to C9 - and so it automatically adjusts the formula to read:

=SUM(C1:C9)

An absolute reference refers to a cell in a fixed location. Such references come in handy when you want to refer consistently to the same cell, or range of cells, throughout a worksheet. For example, if you use a worksheet to estimate a mileage allowance for business travel, you could put the allowance rate per mile in cell D2 and then use an absolute reference to that cell anywhere you use a formula based on the mileage rate. To indicate an absolute reference use dollar signs, thus: $D$2.