Page 36 - Computer Genius Class 06
P. 36

et us use the date and time  unctions in   cel. To use the date  unctions   ollo  the gi en steps

                          1  Type =TODAY() function in the cell and press the Enter  ey.




















                                        2  Type =MONTH(TODAY()) function and press the Enter  ey.


                  When you press the Enter key, the current date appears in cell A1 and current month appears in
                  cell  2.

                  We can also give the reference of a cell containing the date to the MONTH()  unction.  imilarly   e
                  can use the YEAR() and DAY()  unctions to get the year and day  rom a date  respecti ely.






                           The common functions like SUM, AVERAGE, MAX, and MIN,
                           can also be used by using the down arrow of the AutoSum
                           command.
                           To use other  unctions  clic  on the  ore Functions option.






                                                                                        Information Literacy
                         Quest                                                          Critical Thinking



                       Write the output of the following:
                       1.

                       2.   e t   omputer

                        .          12
                        .       Touch

                        .      T     12








                       34    Computer Genius-VI
   31   32   33   34   35   36   37   38   39   40   41