Page 79 - ConceptGP_C5_Fb
P. 79

LAB ACTIVITY                                                                      Subject Enrichment


                    Visit your computer lab and perform the following actions:

                    ▶  Open Excel and enter the following data:










                        (a)  Add a column to the right of Sr. No. and enter the following entries:









                        (b)  Now, add a row above the fourth row and enter the following entries:




                        (c)  Lastly, correct the Sr. No. of the fourth and fifth rows.

                    ▶  Create the following worksheet in Excel:
























                        (a)  Set the height of Row 1 to 35.

                        (b)  Set the column width of B to 12, C to 15 and D to 12.

                        (c)  Use the AutoFill feature to enter the employee numbers.
                        (d)   After you are done entering the data, find out the total, average, lowest and highest
                             values, and write them in their respective cells.










                                                                                              Editing in Excel 2010  77
   74   75   76   77   78   79   80   81   82   83   84