Page 34 - KEC Khaitan C6 Flipbook
P. 34

d.  =MOD(10, 3)
                      ______________________________________________________________________________________

                     e.  =ROUND(5.678, 2)
                      ______________________________________________________________________________________

                     f.  =CONCATENATE("Excel", " ", "2021")
                      ______________________________________________________________________________________

                     g.  =LEFT("OpenAI", 4) return
                      ______________________________________________________________________________________

                     h.  =SQRT(49)
                      ______________________________________________________________________________________


                  3.  Error Identification Questions.

                     a.  Identify the error in =A1 / B1 when B1 is 0.
                      ______________________________________________________________________________________

                     b.  Determine the error in =POWER(2, -3) if negative powers are not allowed.
                      ______________________________________________________________________________________

                     c.   Find the issue with the formula =VLOOKUP("value", A1:A10, 2, FALSE) when the second argument
                        range is incorrect.

                      ______________________________________________________________________________________
                     d.  Spot the error in =SUM(A1:A5) * % when a percentage symbol is incorrectly used.

                      ______________________________________________________________________________________
                     e.  Identify the error in =DATE("2021", "01", "01") with incorrect data types.

                      ______________________________________________________________________________________

                  4.  Think and answer.

                     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.   If you want to find the average temperature recorded over a week, which function would you use?
                      ______________________________________________________________________________________

                      ______________________________________________________________________________________



                   32   Premium Edition-VI
   29   30   31   32   33   34   35   36   37   38   39