Page 56 - ThinkGPT_V2.1_C7_Flipbook
P. 56

2.   What is the use of the conditional formatting?








                      3.  Write the steps to search a record in a form.










                                                                                          Critical Thinking
                                                                                          Information Literacy
                    Guess! Who am I?
                    1.  I restrict you to enter a specific range of values in a particular cell or a range of cells.

                    2.  I am a feature in Excel to separate unwanted data from a range of data.
                    3.  I am a type of formatting that can be applied on the basis of a criteria.
                    4.   I am an option that is selected when you want to add data bars to the cells
                        having numeric data.



                     Competency-based/Application-based questions                         Information Literacy

                    Anaya was making a list of all the students in her class. She wants to highlight bottom 10
                    roll numbers in her list. Which type of criteria can she use for this?





                            SDG Activity




                      Use  Excel  to  create  a  budget  tracker  where  you  input  your  weekly  savings and
                      expenses. Apply sorting to organize your expenses by amount, and use conditional
                      formatting to highlight any expenses that exceed your budget limits. Analyze the
                      results to see how managing your finances can lead to better economic stability."



                                                                                          Technology Literacy
                     byte TASK


                    A.   Make a list of your 10 friends in Excel 2016. Make columns for the distance of their home from school,
                        distance of post office from their home, etc.
                         Highlight the cells that have distance value less than 2.5 km in any cell.
                    B.   Make a list of 15 teachers and subjects taught by them. Apply Filters on the subjects field. Take
                        printouts of various filter options of subjects and their result.


                       54    Premium Edition-VII
   51   52   53   54   55   56   57   58   59   60   61