Page 48 - TP_Play_V2.1_class5
P. 48

3.  Date/Time: Dates and times for scheduling and tracking.

                  4.  Boolean: True or False values for logical operations.
                  5.  Error: Indicates a problem with a formula
                     or operation.                                                Each dolphin has a unique

                  6.  Array: A range of cells or values.                       whistle (name) just like Excel has
                                                                                 a unique name for each cell.
                  Each data type has its own formatting and
                  functions  for  manipulation  and  analysis
                  within Excel.
                      Labels: A label is an important entry in Excel. The label is used to define the
                     information on the spreadsheet, i.e. heading of columns, titles and names. It is

                     any text besides phone numbers, numbers, formulas, etc. Labels are aligned on
                     the left side of a cell.
                      Formula: A formula is a mathematical expression used to do simple and complex
                     calculations of the numeric data inserted in a cell or a range of cells. A formula
                     always begins with an equal to (=) sign e.g. = A2 + B2.

                     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

                      2.  What is a collection of worksheets called?

                          a.  Workbook                    b.  Vertical                   c.  Cell

                      3.  What is the intersection of a row and a column called?

                          a.  Row                         b.  Column                     c.  Cell


                      4.  What are the vertical divisions known as?
                          a.  Grid                        b.  Columns                    c.  Worksheet



                   46       Play (Ver. 2.1)-V
   43   44   45   46   47   48   49   50   51   52   53