Question

Excel is a giant calculator. That means it is much better at doing math than we are. Learning to use functions can be intimidating at first. What is the benefit of using functions as opposed to using the calculator on your phone or computer and typing the answer in the cell? Discuss the benefits and in your post give examples of using functions in a real life situation and why they make working with numbers so easy.

Answer 1

Answer)

Instead of using a calculator we can use the MS Excel to do the math, that is Excel is a giant calculator and it is much better and efficient and time saving in doing math than we are. Learning to use the functions at the first go, can be intimidating but we have got many benefits which can be really achieved by using the Excel instead of a manual calculator. The benefit of using functions as opposed to using the calculator on your phone or computer and typing the answer in the cell are:

a) It simplifies the formulas and calculation

b) Functions help us accomplish the tasks which would be impossible with the standard formulas

c) Functions save time to customize the working and formula, and save time by helping to automate the tasks in a far lesser time.

For example, in a real life scenario, we can have a requirement such as we have 1,000 records and we want to calculate the average of those numbers. Even if we add the numbers in the calculator and then calculate the average one time, but changing any of those numbers will change the average which will have to be recalculated manually. However, Excel takes care of this automatically, by automatically calculating the average using the function. Thus Excel makes working with the numbers so easy.