Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 58 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 58

    Checkpoint

                      A.  Tick ( ) the correct option.

                         1.  Mark the Validity type that allows only whole numbers to be entered in a cell.
                            a.  Time                                         b.  Integer

                            c.  Text length                                  d.  Date

                         2.  Which option is used to remove an applied Standard Filter in Calc?

                            a.   AutoFilter                                  b.  Reset Filter
                            c.  Clear Filter                                 d.  Remove Filter

                         3.  Form in Calc is used to .........................

                            a.   Sort data                                   b.  Edit rows
                            c.  Create charts                                d.  Apply formulas

                         4.  In Calc, which box is used to choose the type of calculation for Subtotals?

                            a.   Group by                                    b.  Calculate

                            c.  Function                                     d.  Remove Filter

                         5.  ........................ option limits values within a minimum and maximum range in Calc.
                            a.   not equal                                   b.  equal

                            c.  valid range                                  d.  greater than

                      B.  Write ‘T’ for true and ‘F’ for false.

                         1.  Clicking the New button is the first step to add a record in Calc Form.           ........................

                         2.  A Pivot Table in Calc is used to analyse data from a selected range of cells.     ........................
                         3.  Multiple Sort can sort one column ascending and another descending.               ........................

                         4.  The Subtotals outline cannot be removed once applied.                             ........................

                         5.  Data Fields in a Pivot Table show item names instead of quantities.               ........................

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

                                              Hints

                                                     Incorrect, Range, Available Fields, Form, Category

                         1.  The ........................ section shows all the fields available from your data.
                         2.  Subtotal can group data by ........................ and sort them in ascending or descending order.

                         3.  Validity helps prevent ........................ data entries and ensures the data entered in Calc is accurate.

                     56     Premium Edition-VII

| 53 54 55 56 57 58 59 60 61 62 63 |