Page 39 - Computer Genius Class 06
P. 39

Experiential Learning
                   Competency-based/Application-based questions
                                                                                        Information Literacy
                   1.    iya has made a spreadsheet o  the mar s o tained in di  erent su  ects  y the students in her
                       class.  he has made some changes to the mar s o  some students.  o  she  ants the total num er
                       o  mar s  or those students to  e automatically updated.  hich  unction should she use to do so
                   2.    our  riend  lisha is using   cel and  ants to add the current date and time in it.  he doesn t  no
                       ho  to do this. Tell her the appropriate  unction she can use to do so.






                                                                                        Experiential Learning
                    LAB Activity                                                        Information Literacy



                    reate a similar in oice in   cel.













                      Fill up details o   i e items  their  uantities and unit prices.

                       sing the  roduct  unction  calculate the amount  or each item.
                       sing the      unction  calculate the total amount.
                       sing a  ormula  calculate the   T according to the gi en rate.

                       alculate  n oice amount paya le.




                                                                               Leadership & Responsibility
                             TECH VALUE                                        Initiative


                              l ays chec  the  ormulas a ter entering it.























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