Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 41 - ClickGPT V4.0 C-5
P. 41

    2.  What do you mean by operators in Excel?

                            3.  What will be the final result of the following formula:

                                =((10+6)/SQRT(8))

                            4.  Explain any two rules for using functions in Excel.

                            5.   If cells A2 and A3 contain 10 and 20 values, respectively, then what will be the output of the following
                               function:

                                =IF(A2 > A3, "A2 is greater than A3", "A2 is not greater than A3")

                            Scratch Your Brain.                                                      21 st  Century   #Critical Thinking
                                                                                                         Skills
                                                                                                             #Communication
                            1.  Match the following formulas with their outputs:
                                   Formula                                                                   Output
                                a.  =MAX(SUM(10, 20, 30),AVERAGE(10, 20, 30))                            i.   ORANGE6
                                b.  =CONCATENATE(UPPER("Orange"), LEN("Orange"))                         ii.   25
                                c.  =POWER(ABS(-5),ABS(-2))                                              iii.   60
                                d.  =LEN("12345") + LEN("Excel")                                         iv.   5
                                e.  =SQRT(INT(20.45) + SQRT(25))                                         v.   10

                            2.  Competency-based/Application-based questions.

                                a.   Avi has created the following worksheet:

                                                  Product        Sales Quantity      Price per Unit
                                                     A                 100                10
                                                     B                 150                20
                                                     C                  80                30
                                                     D                 200                40

                                     Now, he wants to calculate the total amount for each product. Which function of Excel will help him
                                  to do so?
                                b.   Mayra has written her first and last names in cells F1 and F2, respectively. To display the complete
                                  name, she has entered the following formula in cell F3:
                                   =CONCATENATE(F1+F2)
                                     However, she does not get the correct output. What could be the possible reason for not getting
                                  the correct output?

                                c.   Simi is working on a worksheet in which she wants to display the names of the students in
                                  uppercase. Which Excel function will help her to achieve this?

                                d.   Romi wants to calculate the total number of values in a particular range. Which function of Excel
                                  should he use to accomplish this?

                                                                                 Charts, Formulas & Functions in Excel  39

| 36 37 38 39 40 41 42 43 44 45 46 |