Page 45 - TP_Pro_V5.1_Class6
P. 45

21 st
                    LAB ACTIVITY                                                           Century   #Technology Literacy
                                                                                            Skills
                     Visit your computer lab and perform the following actions:
                     ▶  Open MS Excel and perform the following tasks:
                          Enter the following data in Excel:










                     ▶  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.

























                                                                                               Charts in Excel 2021  43
   40   41   42   43   44   45   46   47   48   49   50