A_______________ is a mathematical expression to perform calculations on data
Answers
Answer:
After you add your data to a worksheet and define ranges to simplify data references, you can create a formula, which is an expression that performs calculations on your data. For example, you can calculate the total cost of a customer’s shipments, figure the average number of packages for all Wednesdays in the month of January, or find the highest and lowest daily package volumes for a week, month, or year.
To enter an Excel formula into a cell, you start with an equal (=) sign. Excel then knows that the expression that follows should be interpreted as a calculation, not text. After the equal sign, you enter the formula. For example, you can find the sum of the numbers in cells C2 and C3 by using the formula =C2+C3. After you have entered a formula into a cell, you can revise it by clicking the cell and then editing the formula in the formula bar. For example, you can change the preceding formula to =C3-C2, which calculates the difference between the contents of cells C2 and C3.
important.jpg IMPORTANT
A Formula
- After we add our data to the worksheet & define the ranges to simplify data the references, we can create the formula, Expression which perform the calculation on our data.
- To enter the Excel formula in- to the cell, we start with the equal "=" sign. Excel knows that this expression follows will be interpreted with the calculation, not as text.
- After that equal sign, we enter formula.
- For example, we can find sum of number in the cells C2 & C3 by using formulae = C2 + C3.
- After we have entered the formula in-to cell, we can revise it with clicking cell & then editing formula in a formula bar.
Thus the Answer is a Formula .
#SPJ3