Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2610_Springdales_C-7
P. 29

    Color Scales: Select this option to add color schemes to all selected cells, slowly varying from top
                       to bottom items. Hovering the mouse pointer over this option opens a sub-list that displays various
                       colour variations that can be applied to cells.

                         Icon Sets: This option is selected when you want to add icon sets to show which cells are acceptable,
                       which are moderate, and which need attention. When you hover the mouse pointer over this option,
                       a sub-list opens, displaying the different types of icon sets that you can add.
                     You can also define your own rule for highlighting cells by selecting the New Rule option from the
                     Conditional Formatting drop-down list. The conditional formatting features applied to a data range
                     can be cleared by selecting the Clear Rules option from the Conditional Formatting drop-down list.

                                Quick Quiz

                      1.  What does "Sorting Data" in a spreadsheet means?

                                 a. Organising data alphabetically or numerically based on certain criteria.

                                 b. Changing the formatting of data cells.

                      2.  What is the purpose of "Filtering Data" in a spreadsheet?

                                 a. Arranging data in a specific order.

                                 b. Displaying only the data that meets specific criteria.

                      3.   Which feature is most helpful for identifying values in a column of numbers based on criteria like greater
                          than or less than?

                                 a. Sorting Data                               b. Conditional Formatting

                                  Recap

                                   Sorting data means to organise the data in ascending or descending order.

                                   Custom sorting is used to apply sorting to more than one column in a selected range on different

                                criteria.
                                   The filters can be easily applied and removed according to the user’s requirements.

                                   Conditional formatting can be applied on the basis of different criteria.

                                                       Assess Yourself

                            Choose the correct option.

                           1.   Riyan has to arrange the roll numbers of all the students in a sequential order. Which of the following
                               feature of Excel will help him?

                                      a. Sorting                                    b. Filtering

                                      c. Conditional Formatting                     d. Not possible in Excel

                                                                                          Advanced Features of Excel    27

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