You can edit data in cells this in several ways:
There are several operators that could be used in formulas.
If you need to enter lots of numbers with a fixed number of decimal places, Excel has a useful tool:
Applying a number format to a cell doesn't change the value, but only how the value appears in the worksheet. Formatting can play a joke with you, e.g., sum of values seems incorrect because Excel displays a limited number of decimal places and their sum is not equal to the real sum.
Excel automatically moves the cell pointer to the next cell down when you press the Enter key after entering data into a cell, but you can change this behaviour to move it up, down, left, right and even stay on.
If you simply need to perform a calculation, you can use the Formula bar as a calculator.
Formulas can refer to cells in other worksheets-and the worksheets don't even have to be in the same workbook. Excel uses a special type of notation to handle these types of references.
You can enter nonrelative references (absolute or mixed) manually by inserting dollar signs in the appropriate positions, or you can use a handy shortcut - F4 key.
Expressiveness of business graphics sometimes determines the success or failure of the presentation and you can achieve better perception of the audience by using in charts intuitively obvious representation of data by arrows.