Page 32 - 2627_Trackpad Pro_C-6

d. =MOD(10, 3)
______________________________________________________________________________________

e. =ROUND(5.678, 2)
______________________________________________________________________________________

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

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

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?
______________________________________________________________________________________

______________________________________________________________________________________

30 Premium Edition-VI