Page 77 - TechPluse_C6_Flipbook
P. 77

Conditional Formatting applied




                       Using Conditional Formatting

                 The selected conditional formatting is applied to the selected cell range. You can also define
                 your own rule for highlighting cells by selecting Manage option from the Conditional sub-menu.

                     PRINTING A WORKSHEET

                 Step 1      Select the range of data that you want to print and then click on the Print option from
                           File menu.

                 Step 2    Click on the OK button. The worksheet will be printed.


                  Tech

                    Funda

                                    To open the Print dialog box: Ctrl + P




                        Restart



                      LibreOffice Calc allows users to create custom formulas to perform calculations on their
                      data.
                      Formulas in LibreOffice Calc begin with an equal sign.

                      When performing calculations using a formula, Calc follows certain rules of precedence.
                      Calc also contains built-in formulas called functions that make it easy to perform common
                      calculations on data.
                      Charts make it easier to draw comparisons, analyse growth and relationship among the
                      values.





                                                                        Formulas, Functions and Charts in Calc       75
   72   73   74   75   76   77   78   79   80   81   82