Page 44 - Touchpad_Plus_V3.2_Class 7
P. 44

3.  Conditional Formatting is applied through which menu in Calc?

                        a.  Data                                         b.  Edit

                        c.   Format                                      d.  Tools
                     4.  To print a selected range in Calc, which menu should you use?

                        a.  File                                         b.  Data

                        c.  Edit                                         d.  View

                  B.  Write ‘T’ for true and ‘F’ for false.
                     1.  The Conditional Formatting feature allows hiding rows based on conditions.        ........................

                     2.  You can sort data in Calc by choosing the Sort option from the Data menu.         ........................

                     3.  Goal Seek helps to set a target value by changing another cell’s value automatically  ........................
                     4.  To apply filters, use the Format menu in Calc.                                    ........................


                  C.  Fill in the blanks using the words given below:

                                           Hints

                                              Ctrl + P, Conditional Formatting, Conditional, Data Bars


                     1.   Color Scale is a feature available in ........................ option.

                     2.  The ........................ feature in Calc helps you find specific data based on set criteria without removing
                        any rows.
                     3.  To print a worksheet in Calc, press ........................ to open the Print dialog box.

                     4.  The ........................ option in Calc allows you to format cells based on specific conditions, such as
                        highlighting values greater than a certain number.
                  D.  Short answer type questions.

                     1.  What is the use of Goal Seek feature?

                        .....................................................................................................................................................................................................

                        .....................................................................................................................................................................................................
                     2.  Define sorting.

                        .....................................................................................................................................................................................................

                        .....................................................................................................................................................................................................

                     3.  What happens when you apply a filter in Calc and uncheck some checkboxes?
                        .....................................................................................................................................................................................................

                        .....................................................................................................................................................................................................






               42       Plus (Ver. 3.2)-VII
   39   40   41   42   43   44   45   46   47   48   49