Page 62 - TP_Prime_v2.2_Class_6
P. 62

b.   Nidhi is making a spreadsheet and she wants that date and time of the sheet
                         should show on top every time it is opened or used, so as to take screenshots
                         of the time when it is opened or altered. Which function would be helpful for
                         this?

                      Activity Time                                                                    21 st   #Critical Thinking
                                                                                                    Century
                                                                                                      Skills
           Prime (Ver. 2.2)-VI     Down:                                3         E             2      4
                    Solve the crossword using the clues.
                                                                                  1
                      1.   Cell address that is to be used in a calculation

                      2.   Function used to display current date

                                                                                                       S
                                                                                                O

                      4.   Function used to add values in cells

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

                      7.   Numbers or text that do not change
                      8.   Function used to convert text string
                         into lowercase                                                       9         O
                      9.   Function used to multiply values in cells


                     Find Out                                                                        Century   #Communication
                                                                                                       21 st
                                                                                                      Skills
                  Talk to the various departments in your school and find out how they use Excel. Discuss the

                  collected information with your class.




                                                                                            21 st
                             In the Lab                                                  Century   #Initiative
                                                                                               #Productivity & Accountability
                                                                                           Skills
                     Create a similar invoice in Excel.
                     1.  Fill-up details of five items, their quantities and

                        unit prices.
                     2.  Using Product function, calculate  the  amount
                        for each item.
                     3.  Using SUM function, calculate the total amount.
                     4.  Using formula, calculate the GST according to the given rate.

                     5.  Calculate Invoice amount payable.
   57   58   59   60   61   62   63   64   65   66   67