Page 49 - TP_Pluse_V2.2_Class_6
P. 49

4.  Short answer type questions.
                    a.  What is cell reference?

                         ______________________________________________________________________________

                         ______________________________________________________________________________

                    b.  Write the names of any two Date functions.
                         ______________________________________________________________________________

                    c.  What is absolute cell referencing?

                         ______________________________________________________________________________

                         ______________________________________________________________________________

                    d.  What is the use of the SUM( ) function?
                         ______________________________________________________________________________

                 5.  Long answer type questions.
                    a.  What are the Mathematical functions? Write the names of any two Mathematical functions.

                         ______________________________________________________________________________

                         ______________________________________________________________________________

                         ______________________________________________________________________________
                    b.  What is the use of the LEN function? Explain with example.

                         ______________________________________________________________________________

                         ______________________________________________________________________________

                         ______________________________________________________________________________

                    c.  Describe the ways to enter a formula.
                         ______________________________________________________________________________

                         ______________________________________________________________________________

                    d.  What are the rules to enter a function?

                         ______________________________________________________________________________
                         ______________________________________________________________________________

                 6.  Define the following functions:

                    a.  SQRT()      b.  DAY()     c.  MOD()      d.  INT()      e.  MIN()
                 7.  Competency-based/Application-based questions.

                    a.   Nidhi has made a spreadsheet for the marks obtained by the students of her class in different
                       subjects. Which feature should she use to keep the spreadsheet updated if she has to change
                       marks in one of the subjects of any student?



                                                                               Formulas and Functions in Excel 2016  47
   44   45   46   47   48   49   50   51   52   53   54