Answer:
The answer to this question is given below in the explanation section.
Step-by-step explanation:
The correct answer to this question is B.
The formulas in the spreadsheet are used to do the automatic calculation when data is changed in the spreadsheet.
For example, if you add numbers in a column and then get average. you can use sum() and average() formula to calculate the sum and average of numbers in a column. If you will change any number in the column, the calculation for sum and average automatically done. So, the answer to this question is B. i.e.
so that calculations are automatically redone when data is changed.
While the other options are not correct because:
- To ensure data is entered correctly is done by validation not by using formula.
- To ensure data is properly formated is done in the formatting section.
- The error can be easily identified using validation features in excel.