Page 28 - ModularV1.1 _c7_flipbook
P. 28

Step 2  Click on  the  Save option.  The  Save  As dialog  box
                          appears.

                  Step 3  Select the location where  you want  to save the
                          workbook and enter the file name in the File name
                          textbox.

                  Step 4  Click on the Save button.


                      TYPES OF DATA IN MS EXCEL                                              Save As dialog box


                  In Excel, there are three different types of data that you can enter in a spreadsheet. These are:

                       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.
                       Values  or  Numbers: Values are  numeric data  on which mathematical calculations are
                     performed. This type of data includes characters 0-9. The numbers 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



                           MS Excel is an application software to store and analyse numerical data.
                          A worksheet has grid-like divisions.
                          Vertical divisions are called columns 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– label, number and date/time.



                                                         Exercise




                  A.  Tick ( ) the correct option.

                     1.  A cell that appears highlighted with dark black 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 column called?

                       a. Row                               b. Column                     c. Cell

                  26      Modular (Ver. 1.1)-VII
   23   24   25   26   27   28   29   30   31   32   33