Page 26 - TP_Prime_V2.2_Class7
P. 26

Step 3:  Select  the  desired  conditional  formatting.  In  this  case,  we  have  selected  the
                            Orange Data Bar option under the Data Bars category. The selected conditional

                            formatting is applied to the selected cell range.






           Prime (Ver. 2.2)-VII
















          24


                                                       Using conditional formatting

                  You can also define your own rule for highlighting cells by selecting New Rule option from
                  the Conditional Formatting drop-down list. The conditional formatting features applied to a

                  data range can be cleared by selecting Clear Rules option from the Conditional Formatting
                  drop-down list.


                                                                                                   21 st
                                                                                                 Century   #Critical Thinking
                                                                                                   Skills
                        Warm           State whether these statements are True or False.
                        Up!            1.  A Bar chart is a graph that shows vertical bars with the

                                           axis values for the bars displayed at the left of the graph.  _____

                                       2.  A Line chart is used to show a trend over time.                     _____

                                       3.  Excel can arrange data in ascending order only.                     _____

                                       4.  You cannot sort more than one columns at a time in a
                                           selected range of cells.                                            _____

                                       5.  The Add Level button is available under the Insert tab.             _____

                                       6.  Sorting can also be done through Sort & Filter group
                                           under the Data tab.                                                 _____

                                       7.  You can not define your own rule in Conditional Formatting.  _____
   21   22   23   24   25   26   27   28   29   30   31