Page 80 - Web_Application_v2.0_C12_Fb
P. 80

Action                                 Command/Menu Option

               Changing     the   font  colour   or
               background colour of the text

















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


                   Complete the following activities and tick on the circle.
                   1.  Create the following spreadsheet:




















                   2.  Add 5 more rows as per the data shown above.
                   3.  Calculate the following:
                       •    Sum of salaries
                       •    Average of salaries
                       •     Find the name of the employee having the minimum salary. Which department does
                           this employee belong to?
                   4.  Format the data giving separate colours and fonts to the headings and data.





                                                    Assignment ‘n Activity                 21 st  Century   #Technology Literacy
                                                                                               Skills
                                                                                                   #Critical Thinking
                     Complete the following activity and tick on the circle.
                     Give the keyboard shortcuts for the following:
                     a.  To print a spreadsheet
                     b.  To open a new file

                     c.  To format text to bold


                78    Touchpad Web Applications (Ver. 2.0)-XII
   75   76   77   78   79   80   81   82   83   84   85