Question:

Explain few useful functions in Excel.

Answer:

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

Keywords:

© 2017 QuizBucket.org