Page 54 - TP_Modular_V2.1_Class7
P. 54

3.  What are date and time functions? Write the names of any two date and time functions.

                        .....................................................................................................................................................................................................
                        .....................................................................................................................................................................................................

                  D.  Long answer type questions.
                     1.  What is the use of the LEN function? Explain with example.

                        .....................................................................................................................................................................................................
                        .....................................................................................................................................................................................................

                     2.  What are the rules to enter a function?
                        .....................................................................................................................................................................................................

                        .....................................................................................................................................................................................................
                        .....................................................................................................................................................................................................

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

                        .....................................................................................................................................................................................................
                        .....................................................................................................................................................................................................

                                                                                            21 st   #Critical Thinking
                                                                                          Century
                  E.  Competency-based/Application-based question.                          Skills  #Productivity & Accountability
                     Aman is organising an event and needs to set exact dates and times for activities. Which
                     functions should he use to find the day, month, year, hour, minute, and second?





                                                                                             21 st   #Technology Literacy
                                                                                          Century
                                                                                            Skills  #Productivity & Accountability
                                                         In the lab

                     Create a similar invoice in Excel 2016.

                        Fill-up details of five items, their quantities and
                       unit prices.
                        Using PRODUCT function, calculate the
                       amount for each item.
                        Using SUM function, calculate the total
                       amount.
                         Using formula, calculate the GST according to the given rate.
                        Calculate Invoice amount payable.




                   Teacher's Corner

                  1.  Explain different types of functions provided by Excel 2016 to the students.
                  2.  Do a walk-through of all the topics covered in this chapter.


                   52       Modular (Ver. 2.1)-VII
   49   50   51   52   53   54   55   56   57   58   59