Possible answers: MAX; VLOOKUP; SIGN; HLOOKUP; ABS; Count; ^; CEILING; MIN; FLOOR
0 of 10 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 10 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)
Exercise 1
The function always looks up a value in the leftmost column of a table.
Exercise 2
You use function when your comparison values are located in a row across the top of a table of data.
Exercise 3
The function returns the largest value in a given list of arguments.
Exercise 4
The function counts the number of cells that contain numbers.
Exercise 5
The function returns the absolute value of a number.
Exercise 6
The operator can be used instead of POWER to indicate to what power the base number is to be raised.
Exercise 7
It Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative. The function is
Exercise 8
The function Rounds a number up to the nearest integer.
Exercise 9
The function Round a number down to the nearest integer.
Exercise 10
The function Returns the smallest number in a set of values.