Page 36 - iPlus_Ver_2.0_class_8
P. 36

To Sum Up

                           Excel allows users to create custom formulas to perform calculations on their data.

                           Excel also contains built-in formulas called functions that make it easy to perform
                         common calculations on data.

                           A group of selected cells is called a range.
                           A cell reference refers to a cell or a range of cells on a worksheet that can be used to
                         find the values or data.

                           Functions  are  predefined  formulas  in  Excel  to  perform  both  simple  and  complex
                         calculations.
                           A chart is a visual or graphical representation of data from a worksheet which is very
                         useful for instant analysis and decision making.

                           Excel provides a variety of different chart formats, such as Bar, Column, Pie, Line, Area,
                         Scatter.

                           Charts make it easier to draw comparisons, analyse growth and relationships among
                         the values.
                           Sorting of data refers to the process of arranging data in ascending or descending
                         order based on a certain criteria.





                                                           Exercise


                                                         Section A (Objective)

                  A.  Tick (✓) the correct option.

                      1.  Which of the following cell references can be included in the relative reference?

                        a. A3                                            b. A$1

                        c. $A$4                                          d. $D6


                      2.  Which of the following functions is used to calculate the average of a range of values?

                        a. AVERAGE                                       b. AVG

                        c. SUM                                           d. None of these

                      3.  What is the cell address in the formula known as?

                        a. Range                                         b. Mixed reference

                        c. Cell reference                                d. None of these




                    34
                         iPlus (Ver. 2.0)-VIII
   31   32   33   34   35   36   37   38   39   40   41