Page 82 - TP_iPlus_V2.1_Class7
P. 82

B.  Long answer type questions:

                     1.  Explain two ways to enhance your spreadsheet.
                     2.  What is the difference between splitting and merging of cells?

                     3.  Explain the elements of a formula.
                     4.  When performing calculations using a formula, Excel follows certain rules of precedence. Explain
                         them.

                     5.  Differentiate between Undo and Redo command.
                  C.  Competency-based/Application-based questions:

                     1.  Bhavik is creating an Excel worksheet where he has entered the names and
                         percentages of all the students in his class. When he prints the worksheet, the
                         border lines are not visible. What could be the possible reason for this?
                     2.  Mallika is entering the number 45.68 into cell B4. However, when she presses the Enter key,
                         the value changes to 45.7. What could be the possible reason for this?


                                                                                             #Digital Literacy
                  Higher Order Thinking Skills (HOTS)
                     1.  If Pavani selects cells A1 and A2 in Excel, both containing the number 5, and then uses the fill
                         handle to drag down to cell A10, what will the content of cell A8 be?

                     2.  If Archit selects cells D1 and D2 in Excel, containing the numbers 5 and 10 respectively, and then
                         uses the fill handle to drag down to cell D10, what will be the value in cell D9?



                                                                                      #Problem Solving & Logical Reasoning
                           Crack The Code                                             #Digital Literacy



                   Write the output:
                      1.  = 5 + 5^2

                      2.  = (5 + 5)^2
                      3.  = (8 + 4) – (3 – 2)^3

                      3.  = 9/3 * 4




                                                                                     #Experiential Learning
                     Let’s Explore



                            Browse the internet to understand the differences between a formula and a function.












                    80
                         iPlus (Ver. 2.1)-VII
   77   78   79   80   81   82   83   84   85   86   87