Which excel function/s you often see but you don't know its use?

There are times we see functions in the formula bar but we don't know what it is used for. State your answers or the formula and we'll try to explain in the best way that we can.