Page 326 - TP_IT_V1.0_C9_flipbpookl
P. 326

REVISIT



                    ▶ A spreadsheet can be defined as text and numbers that have been organised into rows and columns.
                    ▶ The electronic spreadsheet program is used for storing numeric data in an organised form so that the
                   calculation and analysis of the data can easily be done.
                    ▶ LibreOffice is an open source online office suite that includes applications like LibreOffice Writer, LibreOffice
                   Calc, etc., designed to enhance your productivity and creativity with a wide range of tools and features.
                    ▶ Name Box displays the name or reference of an active cell or a selected cell range.
                    ▶ Input Line is used to enter a formula that needs to be applied in the current cell or selected cell range.
                    ▶ The Sheet in Calc is also referred to as spreadsheet.
                    ▶ In a spreadsheet, the cell is the place where we enter the data. Before entering any data in the cell, it has to
                   be first selected by placing a cursor on it.
                    ▶ A group of continuous cells selected with a mouse or keyboard is known as a cell range.
                    ▶ The selection of cells done column-wise vertically will form a column range.
                    ▶ Any set of characters like letters, numbers or special characters that can be entered in a cell is called a label.
                    ▶ An expression that begins with an “=” sign is called a formula in a spreadsheet.
                    ▶ A function is a pre-defined formula in a spreadsheet that has a name followed by parentheses.
                    ▶ The Sum()  function returns the sum of the given values.
                    ▶ The  Min() function returns the minimum value out of the given values.
                    ▶ The Max() function returns the maximum value out of the given values.
                    ▶ The Count() function returns the count of the number of cells that contain numeric values.
                    ▶ The Average()  function returns the average of the given values.
                   ▶ Formatting data enhances the readability and visual appeal of your data, making it easier to interpret and analyse.
                    ▶ The Autofill feature helps you fill a predictable series automatically in a range of cells using the fill handle.
                    ▶ We know that a cell address is a combination of a column name and a row number such as A5, B12, H23, etc.
                   Using a cell address in a formula or a function is known as a cell reference.
                    ▶ Whenever a formula or function is copied to some other cell, the address in the formula or function changes
                   relative to the location where it is copied. This is known as relative referencing.
                    ▶ Chart represents the data in a pictorial form, which is easy to read and understand.






            Exercise





                                                                 Solved

                                                SECTION A (Objective Type Questions)


              A.  Choose the correct option.
                 1.  The intersection of a row and a column is called a   .
                    a. Sheet                                           b. Cell
                    c. Spreadsheet                                     d. Cell range
                 2.                in a spreadsheet is used for entering and editing a formula.
                    a. Status Bar                                      b. Menu Bar
                    c. Standard toolbar                                d. Formula Bar



                324   Trackpad Information Technology (Ver. 1.0)-IX
   321   322   323   324   325   326   327   328   329   330   331