Page 32 - TP_Modular_V2.1_Class7
P. 32

Recap


                           Excel 2016 is an application software that helps to store and analyse numerical data.
                          A worksheet has grid-like divisions.
                           Vertical divisions are called columns whereas the horizontal divisions are known as rows.

                          The intersection of a row and a column is called a cell.
                          There are various data types in Excel that are label, number and date/time.


                                                         Exercise




                  A.  Tick ( ) the correct option.
                     1.  A cell that appears highlighted with green border is called ...............................

                          a.  Active cell                                 b.  Deleted cell

                          c.  Main cell                                   d.  Tab
                     2.  What is a collection of worksheets called?

                          a.  Workbook                                    b.  Folder

                          c.  Cell                                        d.  Document
                     3.  What is the intersection of a row and a column called?

                          a.  Row                                         b.  Column

                          c.  Cell                                        d.  Field
                     4.  What are the vertical divisions known as?

                          a.  Grid                                        b.  Columns

                          c.  Worksheet                                   d.  Row

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


                                                Calculations,  Formula,  1048576,  Excel 2016

                     1.  .............................. allows you to store and analyse data.

                     2.  Excel 2016 maintain account for sales, bills or do mathematical ...............................
                     3.  A .............................. is a mathematical expression.

                     4.  A worksheet contains .............................. rows.
                  C.  Write ‘T’ for true and ‘F’ for false.

                     1.  Microsoft Excel is a spreadsheet application.                                       .....................
                     2.  By default, a workbook contains 4 worksheets.                                       .....................

                     3.  The Ribbon contains multiple tabs, each with several groups of commands.            .....................
                     4.  Rows are denoted by numbers in a worksheet.                                         .....................

                   30       Modular (Ver. 2.1)-VII
   27   28   29   30   31   32   33   34   35   36   37