Page 39 - ThinkGPT_V2.1_C6_Flipbook
P. 39

7.   Function used to convert text string into uppercase
                                             1
                                            P    2 F             T         N
                                                                     3
                                            O                        L
                                                   M          4 T   O          Y

                                          5  C     L                 E                E
                                                       7
                                                 6 S   U


                                                       P

                                                       R




                                                                                        Critical Thinking
                   Competency-based/Application-based questions                         Information Literacy

                   1.   Siya has made a spreadsheet of the marks obtained in different subjects by the students
                      in her class. She has made some changes to the marks of some students. Now she wants
                      the total number of marks for those students to be automatically updated. Which func-
                      tion should she use to do so?
                   2.   Your friend Alisha is using Excel and wants to add the current date and time in it. She doesn't know
                      how to do this. Tell her the appropriate function she can use to do so.


                                                                                        Technology Literacy
                                                                                        Information Literacy
                    byte TASK


                   Create a similar invoice in Excel.













                      Fill-up details of five items, their quantities and unit prices.
                      Using the Product function, calculate the amount for each item.
                      Using the SUM function, calculate the total amount payable.


                                                                               Leadership & Responsibility
                             TECH VALUE                                        Initiative



                             Always check the formulas after entering it.


                                                                              Formulas and Functions in Excel  37
   34   35   36   37   38   39   40   41   42   43   44