Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 49 - logicode 2609 C6
P. 49

    ▶   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.
                          Perform the following tasks in Excel 2021.
                          a.   Following is a list of names entered in Excel. Create the worksheet then use different features of
                             Excel as instructed.

                                Use the sorting feature to arrange the names in alphabetical order i.e., in ascending order.
                                Then again use the sorting feature to arrange the ages from smallest to largest.

                                Use the same data from the above part to use the filter feature on.

                                                                                                   21 st   #Technology Literacy
                                                                                                Century
                                                                                                  Skills  #Critical Thinking
                      FUN ACTIVITY

                       Identify the types of charts available in Excel from the pictures given below:
                           a.

                                                                                        Advanced Features of Excel 2021   47

| 44 45 46 47 48 49 50 51 52 53 54 |