Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 24 - 2617_JSSPS_C-6
P. 24

    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

                     22     Premium Edition-VI

| 19 20 21 22 23 24 25 26 27 28 29 |