On the ribbon of MS Excel, the formula tab contains categorised function libraries. Which of the following is not a function in the formula tab?

Presentation function

The correct answer is option 2- Presentation function.

Presentation function is not a function in the formula tab.

In business applications the input of data usually contains dates (date of invoice preparation, date of payment, payment received date, or due date etc.), rate of interest, tax percentage and output information may require age calculation, duration, delays in payment, accumulated interest, depreciation, future value, net present value, etc. The MS Excel provides library of such functions in which input data can be worked as arguments and result available from the function will be output information. On the ribbon of MS Excel, the formula tab contains categorised function libraries- 

• a. Date and Time Function.
• b. Mathematical Function.
• c. Text Manipulation function.
• d. Logical Function (other than IF).
• e. Lookup and Reference Function.
• f. Financial Function.

The complete details of each function from a range of above categories including examples are available through Help (?) on the Ribbon. The quickest way to get help on a function whose name (e.g. SUMIF) when we entered on formula bar followed by equal to sign then double-click the function’s name that appears in the strip.