Please ans the following MCQ-

9. ____________ function returns a string consisting of a supplied text string, repeated a specified number of times.

Select one:

a. REPEAT()

b. REPT()

c. DUPLICATE()

d. RIGHT()

10. The ANOVA, in statistics, is;

Select one:

a. Used to test the null hypothesis that the means of two populations are equal.

b. Used to smooth out irregularities (peaks and valleys) to easily recognize trends.

c. Used to test the null hypothesis that the variances of two populations are equal.

d. Used to test the null hypothesis that the means of several populations are all equal.

11. Excel Macro is - Select the incorrect answer

Select one:

a. Macro is a single command like Vlookup or Sumif

b. You dont need to be a coder to write macro code

c. A record and playback tool

d. Macro can be executed as many times as you want

12. Function used to remove spaces from text

Select one:

a. CUT()

b. REMOVE()

c. LEN()

d. TRIM()

Please give only correct option no explanation required.