Page 81 - TP_iPlus_V2.1_Class7
P. 81

3.  Excel calculates consecutive operators with the same level of precedence from ................... .

                        a. Right to left                                b. Up to down

                        c. Left to right                                d. Down to up

                     4.  What is the shortcut key combination to Copy?
                        a. Ctrl+X                                       b. Ctrl+C

                        c. Ctrl+Y                                       d. Ctrl+O

                     5.  To apply the text color, follow the following steps:

                        a. Home Tab   Font Group   Text Color

                        b. Home Tab   Text Group   Text Color

                        c. Home Tab   Font Group   Font Color

                        d. Home Tab   Text Group   Font Color

                     6.  The Select All button is located below the ................... .

                        a. Name box                                     b. Formula Bar

                        c. Input Line                                   d. The position of this button is not fixed.
                 B.  Fill in the blanks using the words given below.

                                              Hints: Autofill, Argument, Constants, Equal


                     1.  ................... is always enclosed within the opening and closing parenthesis.
                     2.  Formulas in Excel begin with an ................... sign.

                     3.  To extend the series 3, 6, ... use the ................... feature.

                     4.  Numbers or text values that do not change are called ................... .
                 C.  Write ‘T’ for true and ‘F’ for false.
                     1.  It is not possible to change the row height or column width.                       ...................

                     2.  We can select a range of cells by using the Shift Key.                             ...................

                     3.  It is possible to generate series of months in Excel using Autofill.               ...................
                     4.  Moving data is equivalent to Copy Paste.                                           ...................

                     5.  Even if a column or row has a width or height of 0, it remains visible in the grid.   ...................

                                                       Section B (Subjective)
                 A.  Short answer type questions:

                     1.  How can you select a range of cells in excel?

                     2.  What are the two ways to modify the content of a cell?
                     3.  What is the default row height?




                                                                                                                  79
                                                                                          More on Spreadsheets
   76   77   78   79   80   81   82   83   84   85   86