Page 28 - iPro_trackGPT_V5_Class8
P. 28

To use the statistical functions, follow the given steps:





                       1  Type the
                      data in the Excel
                      worksheet.








                                                                    2  Type =MAX(B3:F3) function in cell G3 to find the
                                                                   maximum marks and press the Enter key.


                  When you press Enter key, you'll see the highest marks in cell G3. To quickly find the highest
                  marks for each student, use the AutoFill feature. To find the lowest marks, use the MIN() function
                  in the same way.
















                                                             3  Type =AVERAGE(B3:F3) function in cell I3 to find
                                                            the average of marks and press the Enter key.

                  Pressing Enter key will display the average marks in cell I3. By using the AutoFill feature, you can
                  calculate the average marks for each student.















                  Date and Time Functions


                        Function                           Purpose                               Example
                                                                                       Input: =TODAY()
                   TODAY()                It returns the current date.
                                                                                       Output: 6/18/2024

                                                                                       Input: =MONTH(TODAY())
                   MONTH(date)            It returns the current month.
                                                                                       Output: 6



                    26    TrackGPT iPRO (V5.0)-VIII
   23   24   25   26   27   28   29   30   31   32   33