Question

write down the difference between formula and function​

Answer 1

The difference between a formula and function is that a formula is defined as the statement used for the calculation.

Please mark me as brainlist

Answer 2

$\huge{\fcolorbox{yellow}{red}{\large{\fcolorbox{blue}{pink}{\tiny{\fcolorbox{orange}{aqua}{Answer}}}}}}$

A function is a predefined formula already available in Excel. Functions streamline the process of creating a calculation. To date, Excel has more than 500 functions and on Microsoft 365, more functions are added all the time, such as XLOOKUP, IFS, LET and LAMBDA to name a few. Functions can do complex calculations that would be very time-consuming to build manually. For example, if you wanted to add up a range of cells without using a function, you’d need to write something like: =A1+A2+A3+A4+A5 instead of =SUM(A1:A5). Now, for five cells, writing it manually isn’t such a big deal. But what if you’re adding a range of hundreds of cells? Or thousands? As you can see, functions make things a lot easier and are basically the whole point of using Excel