Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 58 - 2620_Birla Open Mind C-6
P. 58

    21 st
                           DIY In The Lab                                         Century   #Technology Literacy
                                                                                        #Productivity & Accountability
                                                                                    Skills
                   To
                   Subject   Using Formulas

                    1.  In Excel, enter the data for your daily expenses. Now, create a chart based on the entered data.
                    2.  Create a similar invoice in Excel.
                            Fill-up details of five items, their quantities and unit prices.
                            Using Product function, calculate the amount for each item.
                            Using SUM function, calculate the total amount.
                            Using formula, calculate the GST according to the given rate.
                            Calculate Invoice amount payable.

                  For The Teacher

                      Do a walk-through of all the Excel topics in detail listed in the chapter on the computer screen.
                      Explain to the children the use of Excel at homes, shops, business, industries etc.

                      56  Premium Edition-VI

| 53 54 55 56 57 58 59 60 61 62 63 |