Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 61 - Data_Science_Part_A C12
P. 61

    Action                                    Command/Menu Option
                 Making the text Bold, Italic or Underline
                 or use keyboard shortcuts as follows:
                 Bold – Ctrl + B
                 Italic – Ctrl + I
                 Underline – Ctrl +U

                 Changing the font colour or background
                 colour of the text

                            Task                                                        21 st  Century   #Technology Literacy
                                                                                            Skills

                     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.

                                                                                                     ICT Skills-III  59

| 56 57 58 59 60 61 62 63 64 65 66 |