Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 56 - 2620_Birla Open Mind C-6
P. 56

    B.     Tick ( ) the correct statements and cross ( ) the wrong ones.

                          1.  Every function begins with a + sign.

                          2.  Combined reference is a type of cell reference.

                          3.  The NOW( ) function is used to display the current date.

                          4.  Excel does not provide functions for working on textual content.

                          5.  The MAX( ) function returns the largest value from a set of values.

                          6.  The chart area includes all the objects and elements of a chart.

                  C.     Fill in the blanks with the correct words.

                                              Hints  equal, square root, Functions, MIN(), dollar($)

                          1.                 are predefined formulas in Excel.

                          2.  Formulas in Excel begin with the             sign.
                          3.  The SQRT function returns the               of the given number.

                          4.   In Mixed Referencing, you can lock either a column or a row by preceding it with a    symbol.

                          5.  The                function returns the smallest value.

                  D.  Answer the following questions:

                          1.  Explain any two components of the chart.

                          2.  What is cell reference?

                          3.  What is the use of the SUM( ) function?

                          4.  What are the Text functions? Write the names of any two Mathematical functions.

                          5.  What is the use of the IF function? Explain with example.

                          6.  What are the rules to use a function?

                      54  Premium Edition-VI

| 51 52 53 54 55 56 57 58 59 60 61 |