Page 38 - iprime_V2.2_class8
P. 38

D.  Match the following:

                     1.  Area Chart                          a. Trends over a period of time
                     2.  Pie Chart                           b. Quantitative magnitude of data

                     3.  XY Scatter Plot Chart               c. Sectors showing relative size of each value
                     4.  Line Chart                          d. Correlation between two sets of values



                    Let's Do           It                                                    Section B (Subjective)



                  A.  Short answer type questions.

                     1.  What is a cell reference?
                     2.  Define the following terms:
                         a. Data Series                        b. Legend

                     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:



















                  36     iPRIME (Ver. 2.2)–VIII
   33   34   35   36   37   38   39   40   41   42   43