Page 51 - Plus V4 with Adobe class 6
P. 51

2.  Competency-based/Application-based questions:

                       a.   Siya has made a spreadsheet of the marks obtained in different subjects by the students in her
                         class. She has made some changes to the marks of some students. Now she wants the total number
                         of marks for those students to be automatically updated. Which function should she use to do so?

                       b.   Your friend Alisha was using Excel and wants to add the date and time of her daily visit to the local
                         church. She doesn’t know how to do this. Tell her the appropriate function she can use to do so.





                          Scan the QR Code and attempt the quiz.




                     A Better Me!                                                      Century   #Initiative
                                                                                         21 st
                                                                                        Skills  #Leadership & Responsibility
                     Your neighbour has been preparing a list of grocery items with their prices. She has been manually
                     calculating the total amount. Do you think  you should  be helping  people whenever you see an
                     opportunity?






                                                                              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 above 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.


                                                                          #Charts, Formulas and Functions in Excel  49
   46   47   48   49   50   51   52   53   54   55   56