Page 48 - ModularV1.1 _c6_flipbook
P. 48

C.  Write ‘T’ for true and ‘F’ for false.

                     1.  Every formula begins with a + sign.                                                 .....................
                     2.  Combined reference is a type of cell reference.                                     .....................

                     3.  The LEN( ) function returns the length of the text.                                 .....................
                     4.  The TODAY( ) function returns the current date.                                     .....................

                  D.  Short answer type questions.
                     1.  What is cell reference?

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

                     2.  What is the use of the CONCATENATE( ) function?
                        ......................................................................................................................................................................................

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

                        ......................................................................................................................................................................................
                  E.  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 examples.


                                                    In the lab                                          Inter-Disciplinary


                     Create a similar invoice in MS Excel.














                         •  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 the Invoice amount payable.




                   Teacher's Corner

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




                  46      Modular (Ver. 1.1)-VII
   43   44   45   46   47   48   49   50   51   52   53