Page 79 - iPrime_V2.2_class7
P. 79

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?








                   Crack The            Code

                                                                                                     Critical Thinking
                 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




                           SDG Activity



                    Use Excel to create a budget tracker where you input your weekly savings
                    and expenses. Apply sorting to organise your expenses by amount, and

                    use  conditional formatting to highlight any expenses  that exceed your
                    budget limits. Analyse the results to see how managing your finances can
                    lead to better economic stability.




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