Function Definition:               A function is a predefined formula that performs calculations using specific values in a particular order. Types of functions:               According to Microsoft support, worksheet functions…