Page 39 - iprime_V2.2_class8
P. 39

Now, perform the following tasks on the prepared spreadsheet:

                        a.   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)

                        b.  She wants to select all the items to be purchased along with the quantity. Guide her
                           how she can select the same with the help of mouse.
                        c.   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.
                        d.  In Cell E8, she typed “=sum(E2:E7), what is she trying to do?

                        e.   She wants to find out, on which item has she spent the most? Suggest her a function
                           to do the same.
                        f.   Help her prepare a pie chart so that she can observe on which item she has spent the
                           least.





                  Crack The             Code

                                                                                                      Critical Thinking
                   Solve the crossword using the clues.

                    Across:
                                                                           1              2
                    3.  Symbols      that     specify
                                                                                                  4
                        calculations to be performed
                                                                3          E              O       S
                    5.  Function used to convert
                        text string into uppercase
                    8.  Numbers or text that do
                                                        5                  R
                        not change

                    9.  Function used to convert
                        text string into lowercase
                   10.  Function used to multiply
                        values in cells                                                            6
                    Down:
                                                                    7
                    1.  Cell address that is to be
                                                                        8  C                       N
                        used in a calculation
                                                            9      O       E
                    2.  Function  used  to  display
                        current date
                    4.  Function used to add values
                        in cells                                                       10          O

                    6.  Predefined formula in Excel
                    7.  Chart type in which data is displayed in the form of vertical bars



                                                                             Spreadsheet—Functions and Charts      37
   34   35   36   37   38   39   40   41   42   43   44