Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 44 - logicode 2609 C6
P. 44

    CONDITIONAL FORMATTING

                      To apply conditional formatting to a series of data, follow the given steps:

                                                               1  Select the data and click on the
                                                               Conditional Formatting command.

                                                                                                   2  Select the desired
                                                                                                  option.

                                                                                                   3  Choose desired
                                                                                                  fill effect.

                             Hashtag

                           #Chart: A graphical representation of data
                           #X-axis: The horizontal axis of a chart
                           #SUM(): This function is used to calculate the total of a given set of values
                           #IF(): This function is used to check a condition to be evaluated as True or False

                             REVISIT

                        ▶  Charts in Excel are the pictorial representation of data.
                        ▶  Title, X-axis, Y-axis, Data Series, and Legends are the main components of Excel charts.
                        ▶  Commonly used charts in Excel include Column Chart, Bar Chart, Line Chart, Area Chart, Pie Chart and
                          Doughnut Chart.
                        ▶  Excel allows us to change the type of the chart easily by using the Change Chart Type command.
                        ▶  Excel allows us to move and resize the chart to make it easier to read.
                        ▶  Excel allows us to change the background of the chart using the Format tab.
                        ▶   The SUM() function calculates the total of a given set of values.

                        ▶   The IF() function checks a condition to be evaluated as True or False, and based on the result, suitable
                          actions are performed.

                        ▶   The physical arrangement of data in ascending or descending order is called sorting.
                        ▶   The feature of viewing rows of data suiting a specified selection criterion is called filtering data.

                       42   Premium Edition-VI

| 39 40 41 42 43 44 45 46 47 48 49 |