Page 51 - Trackpad_V4.0_c6_Flpbook
P. 51

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  49
   46   47   48   49   50   51   52   53   54   55   56