Page 39 - Digicode_AI_class_6
P. 39

Experiential Learning
               Competency-based/Application-based questions                        Information Literacy

              1.   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?

              2.   Your friend Alisha is using Excel and wants to add the current date and time in it. She doesn't know
                 how to do this. Tell her the appropriate function she can use to do so.



                                                                                   Experiential Learning
               byte TASK                                                           Information Literacy


              Create a similar invoice in Excel.














                 Fill-up details of five items, their quantities and unit prices.
                 Using the Product function, calculate the amount for each item.
                 Using the SUM function, calculate the total amount.

                 Using a formula, calculate the GST according to the given rate.
                 Calculate Invoice amount payable.



                                                                           Leadership & Responsibility
                        TECH VALUE                                         Initiative


                        Always check the formulas after entering it.



























                                                                         Formulas and Functions in Excel  37
   34   35   36   37   38   39   40   41   42   43   44