Answer the following MCQs - 29)What statement below best describes why we do data analytics in business?

Select one:

a. Analytics improve our understanding of how the business works. We must show a return on the investment we make in data & analytical resources

b. We have to calculate & report financial results to owners / shareholders

c. We need specific insights to make business decisions

30)Cell E23 has a date value and you wish to place that date on an invoice prefaced with the text located in B15. What is the command to do that?

Select one:

a. =join(B15&E23)

b. =concatenate(B15,E23)

c. =B15&E23

d.=CONCATENATE(PROPER(B15),TEXT(E23,"mm/dd/yyyy"))

19)If vector x=c(2:5) and vector y=c(3:4) the output of x*y is

Select one:

a. 2,3,4,5,6

b. 5,7,9,11

c. 6 12 12 20

d. 6 12 0 0

20)Text Functions

Select one:

a. Returns ASCII value of characters

b. Replace Cell References

c. Concatenate and manipulate text

d. All of these

Tick the correct answer only no need to explain...