Page 62 - iPlus_Ver_2.0_class_7
P. 62

Formula

                  A formula is an expression which helps to perform arithmetic calculation and also executes non-
                  arithmetic tasks. It consists of the operands and the operators which operate upon the data.
                  Formula has to be expressed with prefix ‘=’ before the operator/data.

                   i +   CREATING A NEW WORKBOOK

                  To create a new workbook in Excel 2016, follow the given steps:


                                          2  Click on the New option.






                    1  Click on the File tab.




                                                                                                    3  Click on the
                                                                                                   Blank workbook.







                  A new workbook will be created.

                   i +   ENTERING DATA IN THE WORKSHEET

                  To work in Excel, data has to be entered. To begin entering the data, click on the cell. While
                  typing, the data can also be seen on the Formula bar.

                  After typing the data, press Enter key or move the cursor to another cell using arrow keys on the
                  keyboard or click the mouse on another cell. You can type data directly into the cell, or you can
                  enter data using the Formula bar. To enter data, follow the given steps:


















                              1  Click on the cell where you want       2  To move down one cell,
                              to enter the data and start typing.      press the Enter key.

                  Repeat Steps 1 and 2 until you finish entering all your data.






                    60
                         iPlus (Ver. 2.0)-VII
   57   58   59   60   61   62   63   64   65   66   67