Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - logicode 2609 C6
P. 29

    b.  List some rules for using functions in Excel.

                         ______________________________________________________________________________________
                        c.  Write the purpose of the SUM function in Excel.
                         ______________________________________________________________________________________

                        d.  Summarise the use of the CONCATENATE function.

                         ______________________________________________________________________________________
                         ______________________________________________________________________________________

                        e.  Write the steps for SUM() function in Excel.
                         ______________________________________________________________________________________

                         ______________________________________________________________________________________

                         ______________________________________________________________________________________

                     5.  Differentiate between the following:
                        a.  Relative Cell Referencing                         Absolute Cell Referencing
                        ______________________________________                ______________________________________
                        ______________________________________                ______________________________________

                        b.  Comparison Operators                              Reference Operators
                        ______________________________________                ______________________________________
                        ______________________________________                ______________________________________

                                                                                                    21 st
                     6.  Competency-based/Application-based questions.                            Century   #Technology Literacy
                                                                                                   Skills
                        a.   Adhyay entered a ten-digit number in Excel. He now wants to extract the last three digits of this
                          number. Which function should he use for this? Also write the syntax.

                        b.   Gaurav wants to compare the values of two different columns. He wants to check whether the values
                          are equal or not. Which operator should he use? Give the symbol for that operator.

                        c.   Riya enters a formula to divide two numbers in Excel, but the divisor cell contains 0. Excel shows an
                          error #DIV/0!. Why does this error appear and how can Riya fix it?
                        d.   Tara is designing a spreadsheet and wants to display “Passed” if a student scores more than 50 and
                           “Failed” otherwise. Which logical function should she use, and how should it be structured in Excel?
                        e.   Simran tried to reference a cell that was deleted and Excel displayed #REF!. What does this error
                          mean and how should she adjust her formula to avoid invalid cell references in the future?

                                                                                                       21 st   #Communication
                     GROUP DISCUSSION                                                                Century   #Social Interaction
                                                                                                      Skills
                        Divide the students into two groups and discuss the difference between Mathematical Function
                        and Logical Function.

                                                                                     Formulas and Functions in Excel 2021  27

| 24 25 26 27 28 29 30 31 32 33 34 |