Page 67 - Web Applications (803) Class 12
P. 67

Task                                                                       Interdisciplinary



                     Create the following spreadsheet:
























                     Do the following:
                      1.  Add 5 more rows as per the data shown above.
                      2.  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?
                      3.  Format the data giving separate colours and fonts to the headings and data.




                           Reboot


                      Give the keyboard shortcuts for the following:
                      a.   To print a spreadsheet

                      b.  To open a new file

                      c.   To format text to bold







                        Advanced Features in Calc

                 There are various advanced features of Calc. Let us learn about some of them in detail.


                 Sorting Data
                 Calc spreadsheet software helps people to organise and process data by the use of columns and rows with formulas and
                 some cool features. Let us understand how to sort data—arrange data alphabetically or in ascending/descending order.
                 Consider the following spreadsheet:
                                                                                                 ICT Skills-IV  65
   62   63   64   65   66   67   68   69   70   71   72