Page 32 - modular4.0
P. 32

Chapter Profile
                      Values or Numbers: Values are numeric data on which mathematical calculations are performed.
                     This type of data includes characters 0–9 and special characters, such as -, +, [, /, ?, >, <, %. The
                     numbers and characters are always aligned on the right side of the 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 2019 is an application software 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 column is called a cell.
                        There are mainly three data types in Excel that are label, number and formula.








                  Exercise



                  A.   Tick ( ) the correct option.
                      1.  Excel 2019 is a/an                   software to store and analyse data.

                          a.  System                                     b.  Application
                          c.   Utility                                   d.  programming

                      2.  What is the default file name of an Excel 2019 file?
                          a.  Book1                                      b.  Sheet1

                           c.   Worksheet1                               d.  Document1

                      3.  Which tab should be clicked to activate a specific worksheet?
                          a.  Formula tab                                b.   Status Tab
                          c.   Worksheet Tab                             d.   Name Tab

                      4.  What is the default alignment of values in a spreadsheet?
                          a.  Left                                       b.  Right

                          c.   Center                                    d.  Justify

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

                                              Quick access toolbar, spreadsheet, name box, alphabets

                      1.  A single page in Excel is called               .



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