Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 26 - 2617_JSSPS_C-6
P. 26

    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?

                     24     Premium Edition-VI

| 21 22 23 24 25 26 27 28 29 30 31 |