Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 39 - ClickGPT V4.0 C-5
P. 39

    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  37

| 34 35 36 37 38 39 40 41 42 43 44 |