We use formulas instead of just using a calculator in Excel because it is possible to copy a formula and paste it into various cells or entire spreadsheets. Users can therefore conduct the same actions over various sets of data without having to develop the same formula from scratch. Formulas can be applied to a set of two integers or to a collection of data from various cells.
Why do we use formulas?
You may easily do calculations and obtain totals of numerous cells, rows, or columns in a spreadsheet by using formulae. An illustration of the Microsoft Excel formula =SUM(A$1:A$3), which adds the values of cells A1, A2, and A3, is shown below. SUM serves as the formula's function in this equation.
Users of Excel may carry out basic calculations including calculating totals for a row or column of numbers. In more complicated circumstances, such as figuring out how much a mortgage would cost, resolving mathematical or engineering issues, or developing financial models, formulas and functions can be helpful.
Learn more about Excel here:
https://brainly.com/question/3441128
#SPJ2
