Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2607_Trackpad_Pro_5.1_flipbook_C6
P. 29

    ▶  Now create the following charts:

                            Frequency polygon              Pie chart             Column chart
                       ▶   In Excel, enter the monthly expenses for your home. 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.
                            Now change the background to make it look more eye-catchy.

                                                                                                               Creativity
                      FUN ACTIVITY
                       Collect the names and marks of five of your friends and draw a pie chart, a column chart, or a bar
                       chart on chart paper. Also, use different colour pens to make it attractive.

                             COding Zone       COding Zone    {}      =      COding Zone               COding Zone
                                                                                                     Computational Thinking
                                    {C ding z ne}
                                                                                                                []
                                                                             </>
                        1.   In numbers 1 to 39, the ones that are exactly divisible by 3 are arranged in an ascending order, the
                           minimum number being on the top, which number would come at the ninth place from the top?
                           ______________________________________________________________________________
                        2.  Write the missing number.

                                                  7       2       5       3       ?       8

                                                      4               6              120
                        3.  Choose the odd one out.
                           a.  50—80        b.  25—55        c.  135—170         d.  14—44

                           CAREER HERE
                     People who are experts in Microsoft Excel  may pursue their careers as Data Analysts.

                        FOR THE TEACHER
                       1.   Describe the different components of a chart to the students.
                       2.   Encourage the students to create a chart in Excel that shows their Annual Examination Result. Recommend them the
                         best chart type suitable for this task.

     26  Premium Edition-VI                                                                        Charts in Excel 2021  27

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