Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 23 - ClickGPT V4.0 C-5
P. 23

    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.

                                                                                                  More on Excel 2019    21

| 18 19 20 21 22 23 24 25 26 27 28 |