Page 51 - Plus_V2.2_C6_Flipbook
P. 51

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

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

                         ______________________________________________________________________________

                    c.  What is relative 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





                                                                                        fun Zone




                    Let's soLve
                    1.  Application based question.                                                Experiential Learning

                        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?

                    2.   Solve the crossword using the clues.                                          Critical Thinking
                       Down:

                       1.   Cell address that is to be used in a calculation

                       2.   Function used to display current date
                       4.   Function used to add values in cells

                       6.   Predefined formula in Excel

                       Across:
                       3.   Symbols that specify calculations to be performed





                                                                               Formulas and Functions in Excel 2016  49
   46   47   48   49   50   51   52   53   54   55   56