What Excel functions are you aware of?

Question

Accepted Answer

I am aware of various Excel functions such as SUM, AVERAGE, COUNT, IF, VLOOKUP, INDEX, MATCH, CONCATENATE, LEFT, RIGHT, MID, ROUND, MAX, MIN, etc.

Basic functions like SUM, AVERAGE, COUNT
Conditional functions like IF
Lookup functions like VLOOKUP, INDEX, MATCH
Text functions like CONCATENATE, LEFT, RIGHT, MID
Math functions like ROUND, MAX, MIN
And many more
Examples: SUM(A1:A10), IF(B1>10, "Yes", "No"), VLOOKUP(A1, B1:C10, 2, FALSE), CONCATENATE(A1, " ", B1), ROUND(A1, 2)

Accepted Answer

I am aware of the formulas used in Excel.

I am familiar with basic formulas such as SUM, AVERAGE, MAX, MIN, etc.

I also know how to use more complex formulas such as VLOOKUP, IF statements, and nested functions.