Page 46 - KEC Khaitan C6 Flipbook
P. 46

▶  Now, select the data and click on the Insert tab to create the following charts:

                             Histogram
                             Frequency polygon

                             Pie chart
                             Column chart
                            Move and resize the charts to make them fit accordingly.

                            After the charts have been created, change the background of the charts by using the Format
                          tab and add any picture or texture.
                      ▶   Enter the data of your monthly expenditure in Excel. Use different columns for different months
                        (at least five months). Use different rows for different categories of expenditure. After you are
                        done, use the most suitable type of chart for this data and represent it graphically. You can also
                        change the background to make it look more eye-catchy.







                                                                                                21 st   #Technology Literacy
                                                                                             Century
                                                                                               Skills  #Critical Thinking
                   FUN ACTIVITY
                    Identify the types of charts available in Excel from the pictures given below:

                                a.


















                                b.























                   44   Premium Edition-VI
   41   42   43   44   45   46   47   48   49   50   51