Excel's "does not equal" operator is simple: a pair of brackets pointing away from each other, like so: "<>". Whenever Excel sees this symbol in your formulas, it will assess whether the two statements on opposite sides of these brackets are equal to one another.

What does colon mean in Excel?

The colon tells Excel to include all cells between the two endpoint cell references. If I just wanted to input the B column into a function, the reference would be B1:B7.

How do I use the symbol function in Excel?

$ Symbol in excel is used to lock a specific cell or rows or columns in a worksheet, the shortcut to lock down a reference in excel is by pressing ALT + F4, this feature is used while working in formulas when we do not want the reference to be changed when we copy or drag down the formula to other cell references, this ...