Question

6. This function returns the square root of a given number
a. sqroot
b. sqrt
d. sqr
c. sqt
7. It is useful when you want to manipulate the result which you have obtained by applying
some formula
a. Filter option
b. Sort option
c. Goal Seek option
d. Data manipulation option
8. This is used to make comparisons in your spreadsheet
a. Data manipulation
b. Logical functions
C. Text functions
d. None of these
9. Which function is used to display the records which have some specific criteria?
a. Filter option
b. Sort option
c. Goal seek option
d. Data manipulation option
10. Which function returns the number of characters including spaces?
a. Lower (text)
b. Len (text)
d. Sum
C. Mod​

Answer 1

Answer:

6.sqrt

7.data manipulation option

8.text functions

9.goal seek option

10.sum

Answer 2

Explanation:

6= sqrt

7= ??

8=?

9= a

10= c