Page 34 - Trackpad_V4.0_c6_Flpbook
P. 34

A Better Me!                                                  21 st  Century   #Leadership & Responsibility
                                                                                          Skills
                                                                                              #Productivity & Accountability
                    Don't copy someone's data without his/her permission. It is an illegal activity.




                       Explore in the Lab                                 21 st  Century   #Productivity & Accountability
                                                                              Skills
                                                                                  #Technology Literacy
                To
                Subject  Creating Worksheet
                 1.  Create the following sales report in an Excel worksheet by using the hints given below:
                                                     Sales Report (Month-January)


                                      Product            Units Sold  Unit Price   Total Sales
                                      Bats                       20         2000          40000
                                      Balls                      50          250          12500
                                      Stumps                    100         1000         100000
                                      Bails                      30          100           3000
                                      Pads (Leg Guards)          40         2500         100000
                                      Gloves                     60          800          48000
                                      Helmet                     70         1200          84000


                       Merge the cells of the first row.
                       Merge the cells of the second row.
                       Apply normal border for internal cells.

                       Apply Thick Outside Borders (Option in the Borders command).
                       Use cell styles on the first and third rows and make the text bold.

                 2.   Create an Excel workbook with five sheets (Students, Fees, Exams, Results, and Teachers). Change the
                    colour of the sheet tabs to green, blue, orange, gray, and gold, respectively. The final output of the sheet
                    tabs should look like the one given below.









              For The Teacher

                  Do a detailed walk-through with students on all the topics presented in the chapter.
                  Provide some tasks which make use of the functional facilities discussed in the chapter.




















                 32     Premium Edition-VI
   29   30   31   32   33   34   35   36   37   38   39