Page 225 - CA_165_V2.0_C9_Flipbook
P. 225

21 st
                                                 Lab Assignment ‘n Activity                  Century   #Technology Literacy
                                                                                              Skills


                    Complete the following activities and tick on the circles:
                    ª  Make a worksheet with following data:

                              Name          Department         Salary       Bonus       Gross Salary
                         Zeba              Accounts            40000        10000
                         Kanchan           Marketing           40000        15000
                         Ruby              HR                  80000        20000
                         Naveen            Accounts            60000        10000
                         Sam               Marketing           40000        15000
                         Syed              Finance             40000        20000

                    ª   Hide HR department from Department and find gross salary of all employees by
                       using SUM function.
                    ª  Filter Bonus where bonus amount is greater than 10000.



                   CHARTS AND GRAPHS

                 In a spreadsheet software, there are additional features that help to represent information in the form
                 of charts and graphs. A chart is a visual or graphical representation of data from a worksheet which is
                 very useful for instant analysis and decision-making. There are various options related to charts that
                 can be used to display data in Calc in a graphical format.
                 Terms used in a chart


                 Following are the terms used in reference with a chart:
                   Element              Description

                   X-Axis               It is the horizontal axis known as category axis.

                                        It is the vertical axis and is known as value axis.
                   Y-Axis
                                        The X and Y axis divide the X-Y plane into four quadrants.




                                                                                                Data Analysis    223
   220   221   222   223   224   225   226   227   228   229   230