Page 50 - TP_Pluse_V2.2_Class_6
P. 50

b.   Anjana has prepared stationery list to be purchased for her daughter in Excel as
                        shown below:











                          (i)   In E2, she is writing the formula for calculating the amount spent on Notebooks, as C2 * D2,
                             but she is not getting any answer. Why? (Help her write the correct input)

                         (ii)   After rectifying the formula in cell E2 she wants to calculate the Amount for all remaining
                             items, suggest her the simplest way to do the same.
                        (iii)  In Cell E8, she typed “=sum(E2:E7), what is she trying to do?
                        (iv)   She wants to find out, on which item has she spent the most? Suggest her a function to do
                            the same.



                  teCh Zone




                    Let's soLve                                                             21 st   #Productivity & Accountability
                                                                                          Century   #Critical Thinking
                      Solve the crossword using the clues.                                  Skills
                        Down:

                        1.   Cell address that is to be                    1              2
                           used in a calculation                                                  4
                                                               3           E              O       S
                        2.   Function  used  to  display
                           current date
                        4.   Function used to add
                           values in cells             5                   R                       6

                        6.   Predefined formula in
                           Excel
                                                                       7 C                         N
                        Across:
                                                           8      O
                        3.   Symbols that specify
                           calculations to be
                           performed
                                                                                        9          O
                        5.   Function used to convert
                           text string into uppercase

                        7.   Number or text that does not change
                        8.   Function used to convert text string into lowercase

                        9.   Function used to multiply values in cells

                  48    Plus (Ver. 2.2)-VI
   45   46   47   48   49   50   51   52   53   54   55