Page 47 - TP_Pluse_V2.2_Class_6
P. 47

We can also give the reference of a cell containing the date to the
                 MONTH() function.  Similarly,  we can use  the  YEAR() and  DAY()                   Factopedia
                 functions to get the year and day from a date, respectively.


                         Let’s CatCh uP


                   Write the output of the following:
                   1.  =MIN (5,7,8)             _____________

                   2.  =LEFT("Computer", 4)     _____________
                                                                                                Examples of some
                   3.  =AVERAGE(12,3,6)         _____________
                                                                                                other spreadsheet
                   4.  =TODAY()                 _____________                                     programs are

                   5.  =LEN("Touch")            _____________                                 Google Sheets, iWork
                                                                                              Numbers, LibreOffice
                   6.  =COUNT(4,8,12)           _____________
                                                                                                 Calc and Lotus
                                                                                                   Symphony.





                                         Tech Hint

                       To use the common functions like Sum,
                      Average, Max and Min: click on the
                      down-arrow of the AutoSum command.
                                                                                                 One of the most
                       To use other  functions: click  on  More
                      Functions option.                                                       famous bug in Excel is
                                                                                              that it considers 1900
                                                                                                  as a leap year.






                            Let’s BaCk-uP

                       Excel allows users to  create  custom  formulas to  perform
                      calculations on their data.

                        A group of selected cells is called a range.
                                                                                              Microsoft considered
                        A cell reference is a cell address that can be used in a formula       other names for the
                      to denote a specific cell.                                                program including

                        The equal  sign  tells Excel  that  the  succeeding characters          "Mr. Spreadsheet"
                      constitute a formula.                                                     and "Master Plan"
                        Excel also contains  built-in  formulas called  functions  that         before deciding on
                      make it easy to perform common calculations on data.                           "Excel".





                                                                               Formulas and Functions in Excel 2016  45
   42   43   44   45   46   47   48   49   50   51   52