Page 79 - Trackpad_ipro 4.1_Class7
P. 79

4.  What are different elements of a formula? Explain them in brief.

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

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

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

                     5.  List three certain rules of precedence for performing calculations using formulas in Excel.
                        ...................................................................................................................................................................................

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


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

                 C.  Application-based questions.

                     1.  Sonia is preparing project details in a spreadsheet. Some text in a cell is too long and
                        gets hidden when she types text in the adjacent cell on the right. How can she change
                        this?
                     2.  Anaya  has  prepared  a  marksheet  for  her  class. She realised  that  she  had
                        forgotten to enter the marks for one subject. How can she create space in the
                        marksheet to enter those marks?


                 Higher Order Thinking Skills (HOTS)                              #Coding and Computational Thinking

                     1.   Charles had to select row 7 in an Excel file. To do so, he clicked on the first cell of the row
                        and dragged it to select the entire row. If you were on his place, then how would you have
                        selected the entire row 7?

                     2.  Analyse the given table of Excel.















                            a.  In the given table, you have to merge cell B1 and C1. How will you do so?
                            b.   You have to calculate the total marks of all the students. Which formula will you use
                               for each student and in which cell will you type the formulas?















                                                                                         More on Spreadsheets    77
   74   75   76   77   78   79   80   81   82   83   84