0 of 9 Questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 9 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
1. We can use “^” operator instead of POWER function.
2. The CEILING function Round a number down to the nearest integer.
3. The FLOOR function Rounds a number up to the nearest integer.
4. The COUNT function counts the number of cells that contain TEXT data.
5. The VLOOKUP function always looks up a value in the leftmost column of a table.
6. You use HLOOKUP function when your comparison values are located in a row across the top of a table of data.
7. The SIGN function return 10 if a number is a positive number.
8. The MAX function Returns the largest value in a set of values.
9. The AVERAGE function Returns the average (arithmetic mean) of the arguments.