For example, if you activate cell A1, the first empty cell, and put in a value, this is what happens in the entry bar. To enter a number. If you need to work with numbers in a special way, such as specific decimal places or not decimals, date, time, dollar signs, and so forth, you need to format the cells. The primary benefit of the spreadsheet is the ability to perform calculations. To do this, formulas are used.
Formulas are mathematical statements used to calculate values.
Working With Cells Of course, the real value of a spreadsheet is not the ability to use it as a calculator, rather it is to use the power of the cells on the worksheets to automatically handle whatever data you enter. A formula can incorporate cell references . Thus, the formula manipulates any values in these cells. Using a function . A function is a built-in calculation that produces a new value from other values, called arguments.