answer the following MCQs without explanation-

a)In case of using a FIND function to locate the position of searched word that is not found, the correct combination of formulas to handle it

Select one:

O a. ISERROR and FIND

O b. IF and FIND

O c. IFERROR and FIND

d. IF and SEARCH

b)The formula 4*2/10 and 4* (2/10) gives the same result:

Select one:

O a. FALSE

O b. TRUE

c)Suppose the column B4 contains the address with country code 'uk' and "1" of the customers they live. The correct formula to replace country code 'uk' with "United Kingdom' and i with "India" is

Select one:

a. =OR(REPLACE(FIND("uk",B4),"United Kingdom"), REPLACE(FIND("1",B4),"India"))

b. =OR(REPLACE(SEARCH("uk",B4),"United Kingdom"),REPLACE(SEARCH("1",B4),"India"))

c. None

d. =SUBSTITUTE(SULSTITUTE(B4,"uk","United Kingdom"), 7, "India")

d)Column C contains the yearly sales data.Which of the following can be used to draw a histogram using "*" for the yearwise sales.

Select one:

a. =REPT("*",C2/1o0)

O b. =DUPLIATE (*",C2)

O c. Using Histogram in Data Analysis

d. Using Graphs in Insert tab