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

