Page 29 - iprime_V2.2_class8
P. 29

Step 4  Type =AVERAGE(B3:F3) function in cell I3 to find the average of the marks.

                 Step 5  Press the Enter key.















                                                        Using AVERAGE Function
                         When you press the Enter key, the average of marks appears in cell I3. Using the AutoFill
                         feature, we can calculate the average of the marks for each student.














                                                      Calculating Average of Marks
                 Date and Time Functions

                     Functions                           Purpose                                 Example

                                                                                       Input: =TODAY()
                      TODAY()         Returns the current date
                                                                                       Output: 23/07/2024
                                                                                       Input: =MONTH(TODAY())
                    MONTH(Date)       Returns the current month
                                                                                       Output: 7
                                                                                       Input: =YEAR(TODAY())
                     YEAR(Date)       Returns the current year
                                                                                       Output: 2024
                                                                                       Input: =DAY(TODAY())
                     DAY(Date)        Returns the current day
                                                                                       Output: 23
                                                                                       Input: = NOW()
                       NOW()          Returns the system's current date and time
                                                                                       Output: 23/07/2024 11:24
                                      Returns the hour from the system's current  Input: = HOUR(NOW())
                    HOUR(time)
                                      time                                             Output: 11

                                      Returns the minutes from the system's            Input: = MINUTE(NOW())
                   MINUTE(time)
                                      current time                                     Output: 24

                 To use the date functions in Excel, follow these steps:
                 Step 1  Type =TODAY() in the cell A1.
                 Step 2  Press the Enter key.


                                                                             Spreadsheet—Functions and Charts      27
   24   25   26   27   28   29   30   31   32   33   34