Lab no.4

Today we are learning about entering different types of data such as time, date, text, formulas.
We can display formulas in worksheet cells instead of the results of formulas by pressing Ctrl+’ or clicking the Show Formulas button on the Formulas tab

So in order to enter a formula we need to do the following steps

•  Click the cell where you want to enter the formula.  
•  Click in the Formula bar.
•  Enter the equals sign (=).
•  Enter the formula. 
•  Press Enter or click the Enter button (the check mark).

Speed Techniques for Entering Formulas
-Instead of typing a cell reference, you can click the cell you want to refer to in a formula. It works even for blocks of cells.

Excel gives you the opportunity to use data from different worksheets in a formula. This is called a 3D reference. It is almost like creating a regular formula.