Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 38 - 2632_CodeMind
P. 38

    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 function 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

| 33 34 35 36 37 38 39 40 41 42 43 |