Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 34 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 34

    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

| 29 30 31 32 33 34 35 36 37 38 39 |