Page 49 - C_GPT _V4 _class_6
P. 49

Hintbot


                        To use the the common functions like SUM, AVERAGE, MAX and MIN: click
                        on the down-arrow of the AutoSum button.

                        To use other functions: click on More Functions option.






                         Topic Flashback                                           21 st  Century   #Technology Literacy
                                                                                       Skills  #Productivity & Accountability
                        Write the output of the following:
                        a.  =MIN(5,7,8)                                d.  =TODAY()
                        b.  =Left("Computer", 4)                       e.  =LEN("Touch")

                        c.  =AVERAGE(12,3,6)                           f.  =COUNT(4,8,12)





                            Quick Quiz
                  1.  Which feature in Excel is used to visually represent and analyse data, such as trends and comparisons?

                              a. Data Types                                b. Charts

                  2.  When creating a formula in Excel, what is a cell reference that doesn't change when copied to another cell?
                              a. Mixed Cell Reference                      b. Absolute Cell Reference




                              Recap


                              A cell reference is a cell address that can be used in a formula to denote a specific cell.
                              In relative reference, you actually refer to cell that is above or below and left or right to a number
                            of rows or columns.
                              If you wish to maintain the original references as they were, then you should make use of the

                            absolute references.
                              A mixed reference is a reference that refers to a specific row or column.
                              Functions are predefined formulas in Excel to perform both simple and complex calculations.



                                                   Assess Yourself


                        Choose the correct option.

                        1.   Sohan has created a worksheet in Excel to store the marks of students in his class. He wants to display
                           the data from the sheet in pictorial form. Which of the following features of Excel will help him to do so?

                                  a. Chart                                    b. Formula

                                  c. Text                                     d. Operator



                                                                             Charts, Formulas & Functions in Excel  47
   44   45   46   47   48   49   50   51   52   53   54