Question

In: Computer Science

What is a formula?

What is a formula? Explain with the help of an example.

Solutions

Expert Solution

Formulas are used to perform calculation in volving addition, subtraction, divison, and multiplication etc. A formula establishes a relationship between two or more cells. It is an expression that can include cell addresses, numbers, arithemetic operation, and parenthessis.

A formula must begin with an equalto(=) symbol followed by cell refernces and operators. It may contain a few or all of the below mentioned elements :-

1. References

2. Operators

3. Constants

4. Function

For example =B2+C2+D2


Formulas are used to perform calculations in volving addition, subtraction, divison and multiplication.

Related Solutions

1)What is Sturges’ formula, and what is it used for? 2)What is the formula for class...
1)What is Sturges’ formula, and what is it used for? 2)What is the formula for class width? 3)Consider a data set with 137 observations, with the smallest observation equal to 101.5 and the largest equal to 1564.7. How many class intervals will you use to create a frequency distribution for this data set? What class width will you use?
What is the formula of CAPM?  ​ Explain the meaning of the formula. give an example
What is the formula of CAPM?  ​ Explain the meaning of the formula. give an example
what is the difference between the Exponential Growth formula and the Exponential Decay formula?
what is the difference between the Exponential Growth formula and the Exponential Decay formula?
a. The emperical formula of sulfur chloride SCl. What is the molecular formula of the compounds...
a. The emperical formula of sulfur chloride SCl. What is the molecular formula of the compounds if the molecular mass is 135 g mol. (recall that one mole of a substance contains 6.02x10^23 molecules of the substance)? b. how many atoms of sulfur are in one mole of the compound? c. how many atoms of chlorine are in one mole of the compound? d. how many molecules comprise one mole of the compound?
What is a reasonable price formula?
What is a reasonable price formula?
what is the empirical formula and the empirical formula mass (g/mol) of a compound composed of...
what is the empirical formula and the empirical formula mass (g/mol) of a compound composed of 31.0% oxygen, 8.06% hydrogen, and 60.1% carbon by mass.
The Lessard APV formula What is Dt in the APV formula? Select one: a. 2 of...
The Lessard APV formula What is Dt in the APV formula? Select one: a. 2 of these b. The market value of the debt used to finance the project each year. c. The face value of the debt used to finance the project in each year. d. The interest expense associated with the project for each year.
What is the general formula of a carboxylic acid?
What is the general formula of a carboxylic acid? Give details about carboxylic acid.
What are Rosette analysis and Flexure formula?
  What are Rosette analysis and Flexure formula? Comment on the comparison between experimental values obtained through Rosette analysis with those values obtained through Flexure formula.
What is the discount rate formula in Finance?
What is the discount rate formula in Finance?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT