Page 47 - Computer Genius Class 07
P. 47

2.   What is the use of the conditional formatting?



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






                      FUN ZONE                                                          Critical Thinking
                                                                                        Information Literacy

                   Guess! Who am I?
                   1.    restrict you to enter a specific range o   alues in a particular cell or a range o  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.




                                                                                        Experiential Learning
                    Competency-based/Application-based questions                        Social Interaction

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



                                                                                        Experiential Learning
                    LAB Activity                                                        Technology Literacy


                   A.   a e a list o  your 1   riends in   cel 2 1 .  a e columns  or the distance o  their home  rom school
                      distance o  post o  ice  rom their home  etc.

                      Highlight the cells which 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.

























                                                                             Advanced Features of Excel 2016  45
   42   43   44   45   46   47   48   49   50   51   52