Page 55 - Dig_CodeAI_V2.1_Class_7
P. 55

TeCh Ready




                 A.  Tick ( ) the correct option.
                    1.  A                    is a digital tool that organises data in a grid of rows and columns.

                        (i)  Spreadsheet                                     (ii)  Row

                       (iii)  Column                                        (iv)  Form
                    2.  Which of the following is a window used to display or enter a record in an Excel worksheet?

                        (i)  Row                                             (ii)  Form

                       (iii)  Textbox                                       (iv)  Column
                    3.  Which of the following options is used to search a record in a form?

                        (i)  New                                             (ii)  Criteria

                       (iii)  Clear                                         (iv)  Outline
                    4.  In which tab is the Data Validation command present?

                        (i)  Data                                            (ii)  Insert

                       (iii)  Home                                          (iv)  None of these

                 B.  Fill in the blanks using the words given below.

                              Conditional formatting   Subtotal   Cell   Highlight Cells Rules   PivotTable

                    1.   Each box in the grid is called a                where you can input information.

                    2.                    opens a sub-list showing criteria like Greater Than, Less Than, Equal To, Between, etc.
                    3.   Color Scales is a feature available in              .
                    4.   The                   command allows you to calculate group-wise sum.

                    5.   The                   feature of Excel 2016 allows to consolidate, summarise and present data.
                 C.  State whether these statements are true or false.

                    1.   Highlight Cells Rules option is selected when you want to highlight all cells
                        satisfying a given condition.
                    2.   The filters once applied can be easily removed.

                    3.   A form displays only one record at a time.
                    4.   We cannot add records using form.
                    5.   Before using the Subtotal command, data must be sorted in ascending or
                        descending order.

                 D.  Answer the following questions:
                    1.  What is data validation?




                                                                             Advanced Features of Excel 2016  53
   50   51   52   53   54   55   56   57   58   59   60