Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 43 - Data_Science_Part_A C12
P. 43

    •  Insert: This menu contains commands like Image, Media, Chart, OLE Object, Shape, Date, Time, Headers and Footers,
                   and so on. These commands are used for inserting elements into a spreadsheet.

                   •  Format: This menu contains commands like Cells, Rows, Columns, Page Style, Align Text and so on. These commands
                   are used for modifying the layout of spreadsheet.

                   •  Styles: This menu contains commands like new style from Selection, Update Selected Style, Manage Styles and so on.
                   These commands are used for managing styles.

                   •  Sheet: This menu contains commands like Insert Cells, Insert Rows, Insert Columns, Delete Cells, Rename Sheet,
                   Move or Copy Sheet and so on.
                   •  Data: This menu contains commands like Sort, Define Range, Subtotals, Consolidate, Group and Outline and so on.
                   These commands are used for manipulating data.
                   •  Tools: This  menu contains commands  like  Spelling,  Goal Seek, Solver, Protect Sheet, Macros and so on. These
                   commands are used to check and customise spreadsheet.
                   •  Window: This menu contains commands like New Window, Close Window and so on. These commands are used to
                   display window.
                   •  Help: This menu contains commands like LibreOffice Help, User Guide, Get Help Online, Check For Update and so
                   on. These commands contains links to the help system included in the software and other miscellaneous functions.

                3.3.3 Toolbars

                By default LibreOffice Calc opens with the Standard and Formatting toolbars at the top of the workspace. These toolbars
                offer a wide range of common commands and functions. Hovering the mouse cursor over any icon displays a tooltip,
                which provides a brief explanation of the icon's function.

                3.3.4 Formula Bar

                Formula  bar  lies  below  the  formatting  toolbar.  Formula  that  performs  different  calculations  in  cells  is  entered  and
                displayed here. It is denoted by 'fx'.
                                   Function Wizard  Formula

                            Name Box   Select Function      Input Line

                It is used for  entering and editing the formula in the cell. Formula bar consists of:
                   • Name Box: It displays the cell reference, for example A1 or D10.
                   • Functions Wizard: It consists of a list of available functions that we can search.

                   •  Select Function: Click  the Select Function    drop-down list in the Formula bar opens a list of functions. You can
                   quickly select common functions like Sum, Average, Min, Max and so on. After choosing a function, its name appears
                   in the formula bar. Enter the required arguments directly in the formula bar or in the cell. For example, selecting SUM
                   allows you to type the range of cells to sum, such as A1:A5. By default, the Select Function tool in LibreOffice Calc
                   typically opens with the SUM function selected.
                   •  Formula: In LibreOffice Calc, the = symbol initiates a formula or function. It tells Calc to interpret the following text
                   as a formula rather than a regular piece of text or a number. For example:

                    =A1+B1 adds the values in cells A1 and B1.
                    =SUM(A1:A5) calculates the total of the values in cells A1 through A5.
                    The = symbol is essential for enabling calculations and functions in spreadsheet cells.
                   •  Input Line: It displays the contents of the selected cell (data, formula, or function). It allows editing of the cell
                   contents. Click in the area and, then type the changes. To edit within the current cell, just double-click in the cell.

                                                                                                     ICT Skills-III  41

| 38 39 40 41 42 43 44 45 46 47 48 |