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

