Page 49 - Plus_V2.2_C6_Flipbook
P. 49

Step 2:  Press the Enter key from the keyboard.                                     Factopedia










                                           Using TODAY function

                 When you press the Enter key, the current date appears in the cell.
                 We  can also  give  the  reference of a  cell containing the  date  to  the
                 MONTH() function.  Similarly,  we can  use  the  YEAR() and  DAY()            Examples of some
                                                                                               other spreadsheet
                 functions to get the year and day from a date, respectively.
                                                                                                 programs are
                                                                                             Google Sheets, iWork
                         Let’s CatCh uP
                                                                                             Numbers, LibreOffice
                   Write the output of the following:                                            Calc and Lotus

                   1.  =MIN (5,7,8)             _____________                                     Symphony.
                   2.  =Left("Computer", 4)      _____________
                   3.  =AVERAGE(12,3,6)         _____________
                   4.  =TODAY()                 _____________
                   5.  =LEN("Touch")            _____________
                   6.  =COUNT(4,8,12)           _____________



                                                                                                One of the most
                                         Tech Hint                                           famous bug in Excel is

                       To use the common functions like Sum,                                 that it considers 1900
                      Average, Max and Min: click on the                                         as a leap year.
                      down-arrow of the AutoSum command.

                       To use other  functions: click  on  More
                      Functions option.




                            Let’s BaCk-uP


                       Excel allows users to  create  custom  formulas to  perform            Microsoft considered
                      calculations on their data.                                             other names for the
                        A group of selected cells is called a range.                           program including
                        A cell reference is a cell address that can be used in a formula       "Mr. Spreadsheet"
                      to denote a specific cell.                                               and "Master Plan"
                        The equal  sign  tells Excel  that  the  succeeding characters         before deciding on
                      constitute a formula.
                        Excel also contains  built-in  formulas called  functions  that             "Excel".
                      make it easy to perform common calculations on data.



                                                                               Formulas and Functions in Excel 2016  47
   44   45   46   47   48   49   50   51   52   53   54