Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 91 - 2619_PlusGPT V2.1_C-7
P. 91

    d.  What is the difference between formula and function? Give two examples.

                             _____________________________________________________________________________________________
                             _____________________________________________________________________________________________

                                                                                            fun Zone

                       Let's soLve
                         Application based question.                                                    Critical Thinking

                           Aman is organising an event and needs to analyse data on past events. Which statistical functions
                         should he use to find the average attendance and the highest attendance for the activities?

                       Let's exPLore                                                                       Communication
                         Talk to the various departments in your school and find out how to use Google Sheets.
                         Discuss with your class.

                            teCh PraCtiCe                                                              Life Skills & Values

                         Create a similar invoice in Google Sheets.
                         1.  Fill-up details of five items, their quantities
                              and unit prices.

                         2.  Using  PRODUCT function,  calculate  the
                              amount for each item.
                         3.  Using SUM function, calculate the total amount.

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

                                                          For The Teacher

                           Explain different types of functions provided by Google Sheets to the students.
                           Do a walk-through of all the topics covered in this chapter.

                                                                                Formulas and Functions in Google Sheets  89

| 86 87 88 89 90 91 92 93 94 95 96 |