Page 37 - Trackpad_ipro 4.1_Class8
P. 37

3.  Define sorting.

                        ...................................................................................................................................................................................
                     4.  What is an area chart?

                        ...................................................................................................................................................................................

                 B.  Long answer type questions.

                     1.  What is the use of the LEN function? Explain with an example.
                        ...................................................................................................................................................................................

                        ...................................................................................................................................................................................
                     2.  What are the rules for entering a function?

                        ...................................................................................................................................................................................

                        ...................................................................................................................................................................................
                     3.  Differentiate between a Column chart and a Scatter chart.

                        ...................................................................................................................................................................................
                        ...................................................................................................................................................................................

                 C.  Application-based questions.
                     1.  You’re helping your class plan a fundraising event and need to calculate
                        the  total  amount  raised  from  different  activities and  expenses.  Which
                        spreadsheet function will assist you in managing and analysing this data
                        efficiently?
                     2.  You’re presenting your class project on how different sports teams performed throughout
                        the year. Which types of charts in Excel will help you visualise and compare the performance
                        of each team more clearly?

                                                                                  #Experiential Learning
                 Higher Order Thinking Skills (HOTS)

                         Anjana has prepared stationery list to be purchased for her daughter in Excel as shown
                       below:

















                        Now, perform the following tasks on the prepared spreadsheet:
                        a.   In E2, she is writing the formula for calculating the amount spent on Notebooks,
                            as C2 * D2, but she is not getting any answer. Why? (Help her write the correct
                            input)



                                                                             Spreadsheet—Functions and Charts    35
   32   33   34   35   36   37   38   39   40   41   42