Page 56 - modular4.0
P. 56

Chapter Profile




                      3.  Explain any three Date and Time functions.








                                                                                                  21 st
                                                                                                Century   #Information Literacy
                  F.   Competency-based/Application-based questions.                              Skills

                      1.   Rahul has a list of product prices in his spreadsheet. He wants to round each price
                          to two decimal places. Which Excel function should he use?

                      2.   Jasmine is working on a spreadsheet and has entered the formula =A2+B2 in cell
                          C2. When she copies this formula to cell C3, what will the formula in C3 be?


                  In the Lab                                                                 Century   #Technology Literacy
                                                                                               21 st
                                                                                               Skills
                     Create a similar invoice in Excel 2019.














                          Write a formula in cell H3 to find total marks obtained by Aradhya.

                          Change the contents of cell B4 to lower case using a function.
                          Use formula to find the percentage in cell H3.

                          Use  function in the cell E7 to find highest marks obtained in Maths.
                          Use function in the cell F8 to find least marks obtained in Science.

                          Count the number of students who appeared for SST exam in cell C9.
                          Use autofill feature to find total and percentage of the remaining students.

                          If you alter Nimish's marks in English, will his overall total and percentage change? If so, why?





                    Teacher's Corner

                        Explain different types of functions provided by Excel 2019 to the students.
                        Do a walk-through of all the topics covered in this chapter.




                54   Modular (Ver. 4.0)-VII
   51   52   53   54   55   56   57   58   59   60   61