Page 38 - iPlus_Ver_2.0_class_8
P. 38

4.  You can sort more than one column at a time in a selected
                         range of cells.                                                                  ..........................

                      5.  The Add Level button is available under the File tab.                           ..........................


                      6.  Data Labels refers to the horizontal and vertical lines in the plot area.       ..........................
                  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 chart                         c.  Sector showing relative size of each value

                      4.  Line chart                               d.  Correlation between two sets of values

                                                         Section B (Subjective)
                  A.  Short answer type questions:

                      1.  What is a cell range?

                      2.  Define the following terms:

                          a.  Data Labels

                          b.  Legend

                      3.  Define sorting.

                      4.  What is a scatter chart?

                  B.  Long answer type questions:

                      1.  What is the use of the CONCATENATE 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.  Competency-based/Application-based questions:

                      1.  Suman wants to present the information in the form of a chart. She has data for a single series
                         and the graph must show the relative circular size of each value. Which chart type must she
                         use?

                      2.  Nidhi has made a spreadsheet for the marks obtained by the students in her class in different
                         subjects. Which feature should she use to keep the spreadsheet updated if she has to change
                         marks in one of the subjects of any student?

                      3.  John is preparing a list of students with their marks obtained in exams. He wants to arrange the
                         data in ascending order according to the students' names. Suggest him a feature of Excel which
                         can help him in doing his work quickly.





                    36
                         iPlus (Ver. 2.0)-VIII
   33   34   35   36   37   38   39   40   41   42   43