Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 28 - 2610_Springdales_C-7
P. 28

    Art Integration Learning
                                                                                                           Lab Activity

                     List the one-day matches that have taken place over the past two years. Consider any five countries that
                     participated, including India. Make separate columns for the country name, runs, wins, and losses. Calculate the
                     total number of matches and total number of runs. Find how many matches India won and how many it lost.

                                     If Excel was a magical library, how would you sort books and filter books you had read?

                  CONDITIONAL FORMATTING

                  Suppose, you do not want to hide any rows but still want to highlight all the cells that satisfy a condition,
                  for example, greater than 80. This type of formatting is known as Conditional Formatting in Excel. To
                  apply conditional formatting to a series of data, follow these steps:

                           1   Select  the  data and  click  on  the    Select the desired conditional   2
                               Conditional Formatting button.           formatting.

                                                                                         Now select the desired
                                                                                         option to apply on the   3
                                                                                         selected cell range.

                  The conditional formatting command has the following options:

                       Highlight Cells Rules: Select this option to highlight all the cells that meet a specific condition. When
                     you hover the mouse pointer over this option, it opens a sub-list showing criteria like Greater Than,
                     Less Than, Equal To, Between, etc.

                       Top/Bottom Rules: Select this option to highlight the top or bottom number of items in a data
                     series. When you hover the mouse pointer over this option, it opens a sub-list showing criteria like
                     Top 10 Items, Top 10%, Bottom 10 Items, Bottom 10%, etc.
                       Data Bars: Select this option to add data bars to the cells having numeric data. Hovering the mouse
                     pointer over this option opens a sub-list that displays various types and colours of bars that you can
                     add to the cells.

                            Premium Edition-VII
                     26

| 23 24 25 26 27 28 29 30 31 32 33 |