Page 81 - iPlus_Ver_2.0_class_7
P. 81

B.  Long answer type questions:

                    1.  Write the steps to create a custom number format in Excel.
                    2.  How will you change the row height and column width?

                    3.  How will you apply cell style?

                    4.  What are different elements of a formula? Explain them in brief.
                    5.  What are certain rules of precedence while performing calculations using a formula in Excel?

                 C.  Competency-based/Application-based questions:
                    1.  Sonia is preparing project details in a spreadsheet. Some of the 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.  Assertion (A): Anaya needs to create space in the marksheet to enter marks for a forgotten
                        subject.
                        Reason (R): To make room for the additional marks, she can adjust the layout or formatting of
                        the marksheet, such as adding a new row or column.

                    (a)  Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A)
                    (b)  Both Assertion (A) and Reason (R) are true and Reason (R) is not a correct explanation of
                        Assertion(A)

                    (c)  Assertion (A) is true and Reason (R) is false
                    (d)  Assertion (A) is false and Reason (R) is true

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


                  Locate six features of Excel in the grid.

                                            W   R   A   P   T   E   X   T   T   F   J   A
                                            R   V   G   E   U   R   E   T   I   O   O   U

                                            A   H   T   G   M   F   D   R   M   R   C   T
                                            M N     X   C   O   L   U   M N     M   E   O
                                             T  B   F   R   F   W   S   W   J   U   M   F

                                            M   E   R   G    I  N   G   C   E   L   L   I
                                            X   O   U   M N     L   H   E   K   A   F   L
                                             T  C   E   L   L   N   I    I  B   S   I   L




                                                                                     #Experiential Learning
                    Let’s Explore



                           Find out about more formulas used in Excel and discuss with your teacher.






                                                                                                                  79
                                                                                          More on Spreadsheets
   76   77   78   79   80   81   82   83   84   85   86