Page 65 - iPlus_Ver_2.0_class_7
P. 65

6.  Which of the following is not a feature of Excel?

                        a. It allows you to enter data in a series using the Auto Fill feature.

                        b. It allows us to use formatting features to improve the look and feel of data.

                        c. It provides different types of functions to perform calculations.

                        d. It allows us to create vector graphics.

                 B.  Fill in the blanks using the words given below.

                                          Hints: Data, Formula, block, Quick Access, Title

                     1.  ................................  is automatically recalculated in the worksheet if any change is made in a single

                        cell.
                     2.  ................................  bar  is located  at  the  top  of  the  window  that  shows the  name  of  the  current
                        workbook.

                     3.  ................................ Toolbar displays commonly used commands such as Save, Undo, and Redo.

                     4.  ................................ bar is used to enter and edit formulas and perform calculations on your worksheet
                        data.
                     5.  A group of cells when selected forms a rectangle, which is called a ................................ .


                 C.  Write ‘T’ for true and ‘F’ for false.
                     1.  Data can be viewed in a graphical form as charts.                            ................................

                     2.  Title bar is a box located on the left side of the Excel window.             ................................
                     3.  A formula is an expression which helps perform arithmetic calculation,
                        and also executes non-arithmetic tasks.                                       ................................

                     4.  An active cell is a collection of two or more cells.                         ................................

                                                        Section B (Subjective)

                 A.  Short answer type questions:
                     1.  Define functions.

                     2.  What is a name box in Excel?
                     3.  What is an active cell?

                     4.  What is the cell range in Excel?
                 B.  Long answer type questions:

                     1.  What is the use of worksheet tab navigation buttons?
                     2.  What is the difference between a workbook and a worksheet?

                     3.  Define column heading.

                     4.  Write the steps to create a new workbook.




                                                                                                                  63
                                                                                  Spreadsheets—An Introduction
   60   61   62   63   64   65   66   67   68   69   70