Question

write two example for each type of function you have learn? show the way how they can be used in exel​

Answer 1

Answer:

Before providing the basic Excel formulas list, let's define the key terms just to make sure we are on the same page. So, what do we call an Excel formula and Excel function?

Formula is an expression that calculates values in a cell or in a range of cells.

For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 through A4.

Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

For example, instead of specifying each value to be summed like in the above formula, you can use the SUM function to add up a range of cells: =SUM(A2:A4)

You can find all available Excel functions in the Function Library on the Formulas tab:

Basic Excel functions

There exist 400+ functions in Excel, and the number is growing by version to version. Of course, it's next to impossible to memorize all of them, and you actually don't need to. The Function Wizard will help you find the function best suited for a particular task, while the Excel Formula Intellisense will prompt the function's syntax and arguments as soon as you type the function's name preceded by an equal sign in a cell:

Excel Formula Intellisense

Clicking the function's name will turn it into a blue hyperlink, which will open the Help topic for that function.

Explanation:

hope this is help you

Answer 2

Explanation:

hope this helps you

sorry

I have copied