Computer Science, asked by yohanbensahil, 9 months ago

What is the importany of formulas in any spread-sheet program

Answers

Answered by sibi61
2

Hi buddy

Here is your answer

Formulas can be copied and pasted to different cells and even to different worksheets. So users don't have to recreate the same formula if they want to perform the same operations over several sets of data. Formulas can be used for a set of two numbers or across a range of several cells of data.

Answered by AskewTronics
0

The importance of the formula in MS Excel are as follows:

Explanation:

  • The formula in MS-Excel will easiest the task of the user. The formula holds the function or any mathematical operation which will use to find the value.
  • Suppose there is a value 10 in cell A1 and the value 15 in Cell A2 and we have to write the sum of Cell A1 and Cell A2 in Cell B2, then the user can write in following two ways:
  • The user can write the value 25 in the cell B2 but when the value of cell A1 and A2 will be changed then there are needs to changed the value of B2 also.
  • But when the user uses the formula like "=sum(A1, A2)" for the cell B1, then the B1 holds the added value which will be changed according to the value of A1 and A2.

Learn More:

  • Ms-Excel : https://brainly.in/question/9086619
Similar questions