1) What Excel function can be used to create time?

a. Year

b. Date

c. Len

d. Time

2) Which of the following statement is true?

a. None of the given statements is correct.

b. Pivot tables cannot be used to generate graphs and charts

c. Pivot tables can be easily turned into graphs or charts

d. Only regular excel tables can be used to create graphs and charts

3) What Excel function is used to conditionally add values that meet certain criteria?

a. Sumif

b. Sumproduct

c. Total

d. Sum

4) Which of the following output is not possible when you execute the Excel function:

=RANDBETWEEN(DATE(2019,1,31), DATE(2019, 6, 30))

a. 7/16/2019

b. 4/21/2019

c. 2/21/2019

d. 4/13/2019

5) What is the result of this Vlookup() function shown below?

a. 1%

b. None of the answers are correct

c. 6%

d. 4%

6) What Excel function will remove the extra white space in front of the text?

a. Left

b. Cut

c. Trim

d. Delete

7) What Excel function will return a random number between two specified numbers?

a. Rand

b. Len

c. Randbetween

d. Trim

8) What Excel function can we use to join two or more text strings into one string?

a. Add

b. Trim

c. Concatenate

d. Find

9) Which formula will concatenate cells A1, B1 and C1?

a. A1:C1

d. A1, B1, C1

c. A1&B1&C1

d. A1+B1+C1

10) What Excel function will you use to convert date to the corresponding day of the week?

a. Date

b. Time

c. Text

d. Day