Why are formulas used in spreadsheets?

Computers and Technology

1 answer:

cluponka [151]3 years ago

7 0

Answer:

The answer to this question is given below in the explanation section.

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.

You might be interested in

According to Holpp and Kelly's approaches to developing vision, the benchmarking approach is more internally focused, whereas th

professor190 [17]

Answer:

False

Explanation:

It is rather the other way round, the intuitive and analytical approach are more internally focused while the benchmark approach is more externally focused.

Hence the statement from the question is false.

6 0

3 years ago

Your traffic light changes to yellow as you approach an intersection. In most cases, what action should you take?

mamaluj [8]

Make every reasonable effort to stop.

6 0

3 years ago

Read 2 more answers

Write a function named times_ten. the function should accept an argument and display the product of its argument multiplied time

viva [34]

Since you did not specify a language i am assuming C

void x10(int n){
printf("%d \n",n*10);
return;
}

3 0

3 years ago

Importance of computer education

Stells [14]

Answer:

hope this helped

Explanation:

Computer technology has helped the world to grow and evolve quickly. By performing tasks quickly, computers make daily activities more convenient. They give people access to a wide array of information and can reach even the most remote locations on the planet.

6 0

3 years ago

How to reinstall windows 7 on my pc,without format,because i don't want to loose my data,and can u give me a windows 7 setup ple

Tems11 [23]

You could install it from a flash drive a disk.

5 0

3 years ago