Page 44 - Digicode_AI_class_7
P. 44

3




































                                    Advanced Features


                                           of Excel 2016





              Learning Outcomes

                 Form in Excel                                 Using Form in Excel
                 Filtering Data                                Conditional Formatting
                 Using Data Validation                         Using Subtotal Command
                 Using Pivot Table



                                                                                    Critical Thinking
                                                                                    Information Literacy

                State whether these statements are True or False.
                1. Area chart displays the data trends over a period of time.

                2. A chart helps us to represent data pictorially.
                3. Plot area contains the actual chart and its other components.

                4. Excel provides only eight categories of charts.










                 42    DigiCode AI-VII
   39   40   41   42   43   44   45   46   47   48   49