Page 32 - TP_Pro_V5.1_Class6
P. 32

d.  Which function will you use to find the highest value in a range of cells?
                         (i)  SUM                                     (ii)  AVERAGE

                        (iii)  MAX                                   (iv)  MIN
                     e.  Which of the following errors indicates division by zero?
                         (i)  #VALUE!                                 (ii)  #NAME?

                        (iii)  #DIV/0!                               (iv)  #REF!
                  2.  Write the Output of the following Excel Functions:

                     a.  SUM(10, 20, 30)
                      ______________________________________________________________________________________

                     b.  =PRODUCT(5, 4, 3)
                      ______________________________________________________________________________________

                     c.  =POWER(2, 3)
                      ______________________________________________________________________________________

                     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.

                      ______________________________________________________________________________________


                   30   Pro (V5.1)-VI
   27   28   29   30   31   32   33   34   35   36   37