Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 34 - 2612 Digimind C6
P. 34

    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.

                       32   Premium Edition-VI

| 29 30 31 32 33 34 35 36 37 38 39 |