Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 45 - Data_Science_Part_A C12
P. 45

    3.3.16 Control Buttons

                Control buttons are essential interface elements that allow users to execute commands, such as minimizing, maximizing,
                or closing a window.

                3.4 PERFORMING BASIC OPERATIONS IN A SPREADSHEET

                A spreadsheet allows you to enter, edit and delete data and use data functions. Let us see the functions that spreadsheet
                allows you to perform.
                3.4.1 Entering Data in Sheet

                To begin entering the data, click on the cell. While typing, the data can also be seen in the Formula bar.

                After typing the data, press the Enter key or move the cursor to the other cell or click on the other cell using mouse.
                Consider an example to work on a spreadsheet:

                Open a new spreadsheet. Type the name of a school, say ‘ABC
                Public School’ in A1 cell and then press the down arrow key to
                make the cell A2 as the active cell.

                Now, in cell A2, type 'Performance Report'. Move to row number
                3. Type the  headings  of the data  in separate  columns by
                pressing the right arrow key/mouse click: Enroll. No. in column
                A, Name in column B, Class in column C, Section in column D
                and Father’s Name in column E.
                Now, we can feed data under the given headings in separate
                cells starting from the 4th row viz., below the separate column headings.

                To enter the formula in the cell, you need to first select the cell and then enter
                a formula. For example, to add the two values 5 and 3, you need to type =5+
                3 in the cell.

                3.4.2 Different Types of Data

                To begin working with a Calc, the user has to feed data. Data can be classified into numeric, text, date/time and formula.

                Text Data (Label)
                Text data are the data which are textual in nature. It refers to the data which is a combination of alphabets, spaces, digits
                and/or other characters. If number are to be inserted as text, they are mentioned within double quotes “  ”. By default,
                text data are aligned towards the left side of the cell and are generally not meant for calculation.
                Numeric Data (Values)
                Numeric data consist of digits (0–9), Exponential (e), decimal (.) and numeric operators like +, -, /, *, %, $. Numeric data
                or values are aligned towards the right side in a cell. Numeric data are the operands on which the formula is applied to
                perform arithmetic calculations. Operands refer to data on which the formula is applied. For example, 5+8, 5 and 8 are
                operands and + is the operator.

                Date and Time
                In LibreOffice Calc displays date as sequential numbers known as Serial Values. The time is displayed as a fractional
                part. Date and Time are values and therefore can be added or subtracted and can be included for other calculations. By
                default they are aligned towards the right side of the cell.

                                                                                                     ICT Skills-III  43

| 40 41 42 43 44 45 46 47 48 49 50 |