Page 38 - iPro_trackGPT_V5_Class8
P. 38

2.  What are the two main ways to add a formula to a worksheet?

                         ...................................................................................................................................................................................
                      3.  Name the three types of cell referencing that Excel uses.

                         ...................................................................................................................................................................................
                      4.  What is the purpose of changing a sheet's tab colour in Excel?

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

                  B.  Long answer type questions.

                      1.  What do you mean by mixed referencing? Give a suitable example.
                         ...................................................................................................................................................................................

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

                         ...................................................................................................................................................................................
                      2.  Write the procedure to sort data in Excel.
                         ...................................................................................................................................................................................

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

                         ...................................................................................................................................................................................
                      3.  Name and explain any two categories of functions available in Excel.

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

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


                  C.  Application-based questions.

                      1.  Payal has created an Excel sheet containing the names of all the students in the class, but
                         she mistakenly entered them in lowercase instead of uppercase. Is there a way to convert
                         these names to uppercase? If so, how can it be done?
                      2.  Pooja is creating charts in excel. Help her to decide the type of chart she
                         should choose if:

                          a.  She wants to show trends over a period of time.
                          b.  She wants to show how different parts make up a whole, often in percentages.



                                                                                   #Digital Literacy
                  Higher Order Thinking Skills (HOTS)
                      1.  Compare two different methods of entering a formula in Excel. Which method do you
                         find easier and why?

                      2.  Why is it useful to sort data in ascending or descending order? Can you give an example
                         of when you might do this?





                    36    TrackGPT iPRO (V5.0)-VIII
   33   34   35   36   37   38   39   40   41   42   43