Page 43 - Touchpad_Plus_V3.2_Class 7
P. 43

Goal Seek status box                             Final data
                     PRINTING A WORKSHEET


                 Printing  a  worksheet  in Calc  allows you  to  create  a  physical copy  of  your  data  for  sharing,
                 reference, or record-keeping. Perform the following steps to print a worksheet:

                 Step 1  Select the range of data that you want to print.
                 Step 2  Click on the File menu.                    Tech Funda
                 Step 3  Click on the Print option.

                 Step 4  Click on the OK button.                  To open the Print dialog box: Ctrl + P
                 The selected range  of data will be
                 printed.


                        Restart


                       Calc can arrange the selected data in ascending or descending order.
                      Multiple Sort is used to apply sorting on more than one column in selected range on
                      different criteria.
                      Calc  can  apply  filters  to  show  only  required  information  while  hiding  the  unwanted
                      information.
                      The filters once applied can be easily removed.

                      Conditional Formatting can be applied on the basis of various criteria.



                                                          Checkpoint


                 A.  Tick ( ) the correct option.

                    1.  Which menu is used to apply sorting in Calc?

                       a.  Edit                                         b.  Data

                       c.  Format                                       d.  Tools
                    2.  Which feature in Calc is used to find a required value by changing input data automatically?

                       a.   AutoFilter                                  b.  Goal Seek

                       c.  Sort                                         d.  Conditional Formatting




                                                                                                  More on Calc       41
   38   39   40   41   42   43   44   45   46   47   48