Explain few useful functions in Excel.
Following are the functions available in Excel for manipulating the data:
- Math and Financial Functions – SQRT, DEGREE, RAND(), GCD
- Logical Functions – IF, AND, FALSE, TRUE
- Date and Time functions – NOW(), DATEVALUE(), WEEKDAY(NOW())
- Index Match – VLOOKUP and INDEX MATCH
- Pivot tables