Page 35 - TP_V5.1_C7_fb
P. 35

6.  Competency-based/Application-based questions.                                  Experiential Learning
                    a.   Alisha was using Excel and encountered an error that displayed ‘#Div/0!’. She doesn’t know about
                      this error. Tell her the meaning of this error and also give a tip to resolve this.
                     _____________________________________________________________________________________

                    b.   Shivam is adding date and time in his Excel sheet. Which function will he use to add for getting the
                      current system date and time?
                     _____________________________________________________________________________________


                 GROUP DISCUSSION                                                                       Communication


                    Divide the students into two groups and discuss the difference between Mathematical Function
                    and Logical Function.




                    LAB ACTIVITY                                                                      Subject Enrichment


                   Visit your computer lab and perform the following actions:
                   ▶  Open a  worksheet,  enter  your  first  name  in  the  A3  cell and  the  last  name  in  the  B3  cell. Now
                     concatenate your first and last name using the text formula in cell E5.

                   ▶  Create a similar invoice in Excel.











                     (a)   Fill-up details of five items, their quantities and unit prices.
                     (b)  Using Product function, calculate the amount for each item.
                     (c)  Using SUM function, calculate the total amount.
                     (d)  Using formula, calculate the GST according to the given rate.
                     (e)  Calculate Invoice amount payable.
                   ▶  Create a similar worksheet:














                      Set the status of stock as "Order" if the Quantity in Stock is less than 20, otherwise "No Action" by
                     using the IF() function.






                                                                                                 Functions in Excel  33
   30   31   32   33   34   35   36   37   38   39   40